API to get DEPENDENT OBEJCTS

API to get DEPENDENT OBEJCTS:


DBMS_UTILITY.GET_DEPENDENCY
   type      IN     VARCHAR2,
   schema    IN     VARCHAR2,
   name      IN     VARCHAR2);

SELECT * FROM ALL_DEPENDENCIES

Using above method, we can find out the Dependent Objects.