To Find the Navigation in PIA using Pagename,ProcessName..etc

Using Process Name:
SELECT PRCSPNL.PRCSNAME, MENUGROUP || ' > ' || MENULABEL || ' > ' || BARLABEL || ' > ' || ITEMLABEL "Path"
FROM PSMENUITEM MENU, PS_PRCSDEFNPNL PRCSPNL, PSMENUDEFN MNUDFN
WHERE MENU.PNLGRPNAME = PRCSPNL.PNLGRPNAME
AND MNUDFN.MENUNAME = MENU.MENUNAME
AND PRCSPNL.PRCSNAME LIKE '%Process_name%'


Using Page name:
SELECT MENU.PNLGRPNAME, PNLGRP.MARKET, PNLGRP.ITEMNAME, PNLGRP.PNLNAME, MENUGROUP || ' > ' || MENULABEL || ' > ' || MENU.BARLABEL || ' > ' || MENU.ITEMLABEL "Path"
FROM PSMENUITEM MENU, PSMENUDEFN MNUDFN, PSPNLGROUP PNLGRP
WHERE MNUDFN.MENUNAME = MENU.MENUNAME
AND MENU.PNLGRPNAME = PNLGRP.PNLGRPNAME
AND PNLGRP.PNLNAME LIKE '%Page_Name%'


Using Component Name-1:
SELECT MENU.PNLGRPNAME, MENUGROUP || ' > ' || MENULABEL || ' > ' || BARLABEL || ' > ' || ITEMLABEL "Path"
FROM PSMENUITEM MENU, PSMENUDEFN MNUDFN
WHERE MNUDFN.MENUNAME = MENU.MENUNAME
AND MENU.PNLGRPNAME LIKE '%Component_name%'


Using Component Name-2:
SELECT DISTINCT REVERSE(LTRIM(SYS_CONNECT_BY_PATH(REVERSE(PORTAL_LABEL),' >- '),' >- '))
FROM PSPRSMDEFN P
WHERE PORTAL_OBJNAME = 'PORTAL_ROOT_OBJECT'
START WITH PORTAL_URI_SEG2 = '<Component Name>'
CONNECT BY PRIOR PORTAL_PRNTOBJNAME = PORTAL_OBJNAME
AND PORTAL_NAME = PRIOR PORTAL_NAME
AND PORTAL_REFTYPE = 'F'

Following information is added by Rajinesh:
If you want to check the navigation of a component follow this navigation
" Main Menu --> People Tools --> Portal --> View Menu Item Detail". Here mention the component which you want to know the navigation....
ex: if you want to know the navigation of "ITEM_BILLING_GBL" component then in the search mention as "%ITEM_BILLING_GBL" and hit the search button.
As soon as we hit it, it will redirect us to the navigation. The Advantage using this is we can know all the permission lists, roles and the users who can access this component