Get process's navigation path by using process name

1. SELECT DISTINCT RTRIM( REVERSE ( SYS_CONNECT_BY_PATH(REVERSE (portal_label),' > ')) ,' > ') PATH 
2. FROM PSPRSMDEFN 
3.       WHERE PORTAL_NAME ='EMPLOYEE'  
4.         AND PORTAL_PRNTOBJNAME = 'PORTAL_ROOT_OBJECT'  
5.   START WITH PORTAL_URI_SEG2IN ( 
6.                         SELECT DISTINCT pnlgrpname  
7.                         FROM ps_prcsdefnpnl  
8.                         WHERE prcsnamein ('PROCESS_NAME_HERE') )  
9.   CONNECT BYPRIOR PORTAL_PRNTOBJNAME = portal_objname;