PeopleSoft : SQL to search peoplecode

SELECT OBJECTVALUE1 ,OBJECTVALUE2 ,OBJECTVALUE3 ,OBJECTVALUE4 ,PCTEXT

  from PSPCMTXT ;

Example:

SELECT OBJECTVALUE1 ,OBJECTVALUE2 ,OBJECTVALUE3 ,OBJECTVALUE4 ,PCTEXT

  from PSPCMTXT

 WHERE PCTEXT LIKE '%cleardropdownitem%'

In the above query  OBJECTVALUE  represents any one of the following:
1.component.
2.record.
3.field.
4.peoplecode event.

PCTEXT--Represents the actual text in the peoplecode for an event.