Checking oracle constraint dependency

Checking oracle constraint dependency

SELECT * FROM ALL_CONSTRAINTS
WHERE CONSTRAINT_TYPE='R' AND R_CONSTRAINT_NAME='CONSTRAINT_NAME';