Find All Components that have a Page

When looking to see what effect a change on a page might have, it is good to know where the page is used in the application. Here is an SQL to find all the places that the page 'SCC_BIO_DEMO_PERS' is used in the application.

SELECT

PNLGRPNAME, MARKET, PNLNAME,

SUBITEMNUM, ITEMNAME, ITEMLABEL,

FOLDERTABLABEL, HIDDEN

FROM SYSADM.PSPNLGROUP where pnlname = 'SCC_BIO_DEMO_PERS'