PeopleSoft : Query to find the Menu Navigation

SELECT * FROM PSXLATITEM WHERE FIELDNAME = 'PROJECT_STATUS';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 = 'RUN_PCPL1000'  à<Component Name>

CONNECT BY PRIOR PORTAL_PRNTOBJNAME = PORTAL_OBJNAME;