To find Dependencies in PLSQL objects in Oracle

All the object will be in the table: USER_OBJECTS
All the object dependencies are in this table USER_DEPENDENCIES


SELECT D.REFERENCED_NAME, O.STATUS
FROM USER_DEPENDENCIES D, USER_OBJECTS O
WHERE D.NAME = O.OBJECT_NAME
AND O.OBJECT_NAME = :OBJECT_NAME;