Following is a query to determine which (child) tables are dependent on another table, in this case ELEMENT_GLOBAL_RANK.

select
distinct c.TABLE_NAME
from
user_constraints c,
user_constraints p
where
c.R_CONSTRAINT_NAME = p.CONSTRAINT_NAME
and p.table_name='ELEMENT_GLOBAL_RANK';