select owner,constraint_name,constraint_type,table_name,r_owner,r_constraint_name
from all_constraints where 
-- constraint_type in ('P','U') and 
table_name='EMPLOYEES';

select *
from 
   user_dependencies
 where referenced_type = 'TABLE'
order by 
   name, referenced_owner, referenced_name, referenced_type