Finding the Navigation of PeopleSoft Components - Part 2 - SQL Query to find navigation of PS Component

Earlier, in one of my posts I had two different SQL queries to find the online navigation of a PeopleSoft component. Sometime back, I came across another SQL from PeopleSoft  tipster which the author claims to be the most succinct version and rightly so. This SQL is short and comes in handy several times to find the Portal navigation.

Here is the SQL:
SELECT DISTINCT RTRIM(REVERSE
                       (SYS_CONNECT_BY_PATH(REVERSE

                         (PORTAL_LABEL), ' > ')), ' > ') PATH

FROM PSPRSMDEFN

WHERE PORTAL_NAME = 'EMPLOYEE'

      AND PORTAL_PRNTOBJNAME = 'PORTAL_ROOT_OBJECT'

START WITH 

      PORTAL_URI_SEG2 = ‘NAME_OF_THE_COMPONENT’

CONNECT BY PRIOR

      PORTAL_PRNTOBJNAME = PORTAL_OBJNAME;