PeopleSoft Learning

Query to find the RECORDS associated with a particular component:

select distinct recname from pspnlfield where pnlname in (select distinct pnlname from pspnlgroup where pnlgrpname ='Component_Name')

This might useful when we look for tunning a particular component for performance issues.