====== Content Reference Heirarchical Query======

PIA navigation to any given component:

<code>
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 = :1
connect by prior
         portal_prntobjname = portal_objname
</code>