Search text in Oracle DB; Returns all types of Oracle function where this text appears;

Select * from ALL_SOURCE  where TEXT LIKE '%Approval%'   

or 

Select * from dba_source where upper(text) like '%ENTER THE TEXT YOU WANT TO SEARCH HERE%'