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;