SELECT referenced_owner AS table_owner, 

       referenced_name AS table_name

FROM   dba_dependencies

WHERE  owner = 'PACKAGE_OWNER'

AND    name = 'PACKAGE_NAME'

AND    referenced_type = 'TABLE';