Skip to content
select *
from all_constraints
where r_constraint_name in (
    select constraint_name
    from all_constraints
    where table_name='TABLE_NAME'
); 

Reference

https://stackoverflow.com/questions/1143728/how-can-i-find-which-tables-reference-a-given-table-in-oracle-sql-developer