To search for strings in PeopleCode programs, you can use the following SQL query. Before running the query, replace string {SEARCH_STRING} with the string that you want to find.
SELECT A.OBJECTID1, A.OBJECTVALUE1, A.OBJECTID2, A.OBJECTVALUE2, A.OBJECTID3, A.OBJECTVALUE3, A.OBJECTID4, A.OBJECTVALUE4, A.OBJECTID5, A.OBJECTVALUE5, A.OBJECTID6, A.OBJECTVALUE6, A.OBJECTID7, A.OBJECTVALUE7, A.PROGSEQ, A.LASTUPDDTTM, A.LASTUPDOPRID, B.PCTEXT
FROM PSPCMPROG A, PSPCMTXT B
WHERE A.OBJECTID1 = B.OBJECTID1
AND A.OBJECTVALUE1 = B.OBJECTVALUE1
AND A.OBJECTID2 = B.OBJECTID2
AND A.OBJECTVALUE2 = B.OBJECTVALUE2
AND A.OBJECTID3 = B.OBJECTID3
AND A.OBJECTVALUE3 = B.OBJECTVALUE3
AND A.OBJECTID4 = B.OBJECTID4
AND A.OBJECTVALUE4 = B.OBJECTVALUE4
AND A.OBJECTID5 = B.OBJECTID5
AND A.OBJECTVALUE5 = B.OBJECTVALUE5
AND A.OBJECTID6 = B.OBJECTID6
AND A.OBJECTVALUE6 = B.OBJECTVALUE6
AND A.OBJECTID7 = B.OBJECTID7
AND A.OBJECTVALUE7 = B.OBJECTVALUE7
AND A.PROGSEQ = B.PROGSEQ
AND B.PCTEXT LIKE '%{SEARCH_STRING}%';