Get Component Navigation in PIA using Query

Begin-Select
PI.PORTAL_NAME,
PI.PORTAL_OBJNAME

Let $CONTENT_REFERENCE = &PI.PORTAL_OBJNAME

FROM PSPRSMDEFN PI
WHERE PI.PORTAL_NAME = 'EMPLOYEE'
AND PI.PORTAL_URI_SEG2 = $Component_Name
End-Select


Begin-Select
PORTAL_LABEL,
LEVEL

Let $Path = $path || '>>'||&PORTAL_LABEL

FROM PSPRSMDEFN
WHERE PORTAL_NAME = 'EMPLOYEE' START WITH PORTAL_OBJNAME = $CONTENT_REFERENCE
CONNECT BY PRIOR PORTAL_PRNTOBJNAME = PORTAL_OBJNAME
ORDER BY LEVEL DESC
End-Select