PIA Navigation for a Component

The following query is used to get the PIA Navigation for a component:

SELECT DISTINCT Rtrim (Reverse (Sys_connect_by_path (Reverse (portal_label),

                                ' > ')), ' > ')

                "PIA NAVIGATION"

FROM   psprsmdefn

WHERE  portal_name = 'EMPLOYEE'

       AND portal_prntobjname = 'PORTAL_ROOT_OBJECT'

START WITH portal_uri_seg2 = 'COMPONENT_NAME'

CONNECT BY PRIOR portal_prntobjname = portal_objname;