To search all packages for a line of code

To search all packages for a line of code,AskHareesh blog for OracleApps

To search all packages for a line of code
 
SELECT  *
FROM    ALL_SOURCE
WHERE   TYPE IN ('PACKAGE', 'PACKAGE BODY')
AND     TEXT LIKE '%NNNN%



*/