select distinct table_name
from dba_constraints
where r_owner = 'SUPERMAG'
and constraint_type = 'R'
and r_constraint_name in
(
select constraint_name from dba_constraints
where constraint_type in ('P', 'U')
and table_name = 'SMSPECCO'
and owner = 'SUPERMAG'
);