How to check table used in Package Posted on March 30, 2016 by admin select distinct ac.name,ac.line from all_source ac where ac.OWNER ='DBOWNERNAME' and lower(ac.TEXT) like '%TABLE_NAME%';