How to search a table in a store proc and open the store proc

1.

select*fromdba_dependencieswherereferenced_name='CNTL_ISSUE'andTYPE='PROCEDURE'

2. 

selecttextfromall_sourcewherename='SP_ARA_TEMPALTE_UPLOAD'andtype='PROCEDURE'orderbyline