Searching for Text within Oracle Stored Procedures

 SELECT * FROM ALL_source WHERE OWNER = 'UYUMSOFT' AND UPPER(text) LIKE '%ZZZW_ACC_TAG%'