SELECT DISTINCT RTRIM( REVERSE ( SYS_CONNECT_BY_PATH(REVERSE (portal_label), ' > ')) ,' > ') PATH FROM PSPRSMDEFN
WHERE portal_name = 'EMPLOYEE'
AND portal_prntobjname = 'PORTAL_ROOT_OBJECT'
START WITH portal_uri_seg2 IN (
SELECT DISTINCT pnlgrpname
FROM ps_prcsdefnpnl
WHERE prcsname in ('PROCESS_NAME_HERE') )
CONNECT BY PRIOR portal_prntobjname = portal_objname;