Searching for PL/SQL code for a string or key
SELECT type, name, line
FROM user_source
WHERE LOWER(text) LIKE LOWER('%&KEYWORD%')
You can view this article online at:
http://www.kiranreddys.com/knowledgebase/index.php/article/searching-for-plsql-code-for-a-string-or-key