Finding the Navigation of PeopleSoft Components - Part 4 - Yet Another SQL Query to find navigation of PS Component

SELECT DISTINCT( portal_objname ),
               portal_uri_seg2 AS 'COMPONENT'
FROM   psprsmdefn
WHERE  portal_uri_seg2 IN (SELECT pnlgrpname
                           FROM   pspnlgroup
                           WHERE  pnlname = '');

Go to the below navigation and then find the Menu item and Portal Object Name.

Peopletools > Portal > View Menu Item Details

Now run the below SQL query and search for the PORTAL_OBJNAME found above.
Menu path will provide the navigation of the desired Page.