select object_name from all_objects where object_ID IN ( select A.REFERENCED_OBJECT_ID from PUBLIC_DEPENDENCY A,all_objects B WHERE A.OBJECT_ID= B.object_id AND B.object_name ='TEST')
select name from dba_dependencies where REFERENCED_NAME='TEST'
select distinct name from dba_source where type='PROCEDURE' and instrb(text,upper('table_name'))!=0
where object_ID IN (
select A.REFERENCED_OBJECT_ID from PUBLIC_DEPENDENCY A,all_objects B
WHERE A.OBJECT_ID= B.object_id AND B.object_name ='TEST')