Finding Table Name referenced by a constraint.

SELECT owner,
       constraint_name,
       constraint_type,
       table_name,
       r_owner,
       r_constraint_name
  FROM all_constraints
 WHERE     constraint_type = 'R'
       AND OWNER = 'Schema name'
       AND r_constraint_name IN
              (SELECT constraint_name
                 FROM all_constraints
                WHERE constraint_type IN ('P', 'U') AND table_name = 'Table Name');