WITH parent (breadcrumb, portal_label, portal_objname, portal_prntobjname, portal_reftype, component) AS
(SELECT varchar(rtrim(portal_label), 1000)
, portal_label
, portal_objname
, portal_prntobjname
, portal_reftype
, RIGHT(portal_urltext, length(portal_urltext) - locate('.', portal_urltext))
FROM psprsmdefn
WHERE portal_name = 'EMPLOYEE'
AND portal_reftype = 'C'
UNION ALL
SELECT varchar(rtrim(c.portal_label), 1000) || ' > ' || p.breadcrumb
, c.portal_label
, c.portal_objname
, c.portal_prntobjname
, c.portal_reftype
, p.component
FROM parent p
, psprsmdefn c
WHERE c.portal_reftype = 'F'
AND c.portal_name = 'EMPLOYEE'
AND c.portal_objname = p.portal_prntobjname)
SELECT breadcrumb, component FROM parent WHERE portal_prntobjname = 'PORTAL_ROOT_OBJECT'
AND char(component)='Component Name.GBL'
ORDER BY 1;