Navigations - Peoplesoft HCM

-- To Find the  Run control page for any Process (SQR,AE etc.,)

Instructions : Copy-Paste the URL in  beginning with the c/ in your browser.

SELECT B.PRCSNAME, C.PORTAL_URLTEXT

FROM PS_PRCSDEFNPNL B

--

INNER JOIN PSPRSMDEFN C

ON  B.PNLGRPNAME = C.PORTAL_URI_SEG2

--

WHERE UPPER(B.PRCSNAME) LIKE UPPER('% xxx%');

--TO GET NAVIGATION IF YOU KNOW THE COMPONENT NAME, PAGE NAME

SELECT DISTINCT

REVERSE(LTRIM(SYS_CONNECT_BY_PATH (REVERSE(PORTAL_LABEL),' >- '),' >- '))

AS "NAVIGATION"

FROM PSPRSMDEFN P

WHERE PORTAL_OBJNAME = 'PORTAL_ROOT_OBJECT'

START WITH PORTAL_URI_SEG2 like (‘--------------------‘)

CONNECT BY PRIOR PORTAL_PRNTOBJNAME = PORTAL_OBJNAME

AND PORTAL_NAME = PRIOR PORTAL_NAME

AND PORTAL_REFTYPE = 'F'