Dependencias de un objeto

SELECT DISTINCT p.owner, P.NAME, P.TYPE, 
       B.STATUS,P.REFERENCED_OWNER,P.REFERENCED_NAME
FROM dba_dependencies p,
     dba_objects b 
WHERE  referenced_name = 'NOMBRE_DEL_OBJETO'
AND p.name = b.object_name;