Identify PeopleSoft Menu Navigation via Componet Name

-- Navigation of Component (Oracle DB)

SELECT DECODE(LEVEL,1,PORTAL_LABEL, PORTAL_LABEL  || ' -> ') "NAVIGATION"

FROM (SELECT PORTAL_LABEL, PORTAL_PRNTOBJNAME, PORTAL_OBJNAME, PORTAL_URI_SEG2 FROM PSPRSMDEFN A

WHERE PORTAL_NAME = 'EMPLOYEE' ) B

WHERE B.PORTAL_PRNTOBJNAME != ' '

START WITH (B.PORTAL_URI_SEG2 =  'YOUR COMPONENT NAME HERE')

CONNECT BY PRIOR B.PORTAL_PRNTOBJNAME = B.PORTAL_OBJNAME

ORDER BY LEVEL DESC;

-- Navigation of Component ( in different format)  (Oracle DB)

SELECT

LTRIM(MAX(SYS_CONNECT_BY_PATH(PORTAL_LABEL ,' <- ')) KEEP (DENSE_RANK LAST ORDER BY LEVEL ),',') "NAVIGATION"

FROM (SELECT PORTAL_LABEL, PORTAL_PRNTOBJNAME, PORTAL_OBJNAME, PORTAL_URI_SEG2 FROM PSPRSMDEFN A

WHERE PORTAL_NAME = 'EMPLOYEE' ) B

WHERE B.PORTAL_PRNTOBJNAME != ' '

START WITH (B.PORTAL_URI_SEG2 =  'YOUR COMPONENT NAME HERE')

CONNECT BY PRIOR B.PORTAL_PRNTOBJNAME = B.PORTAL_OBJNAME