Finding all the packages where a particular table is used

Finding all the packages where a particular table is used

SELECT *

  FROM all_dependencies

 -- user_dependencies

 -- dba_dependencies

 WHERE     1 = 1

       AND owner = 'APPS'

       AND referenced_name = UPPER ('OE_ORDER_HEADERS_ALL')

       AND name LIKE 'XX%'

       AND TYPE = 'PACKAGE BODY';