Query To Find Dependent Objects Of An Invalid Object

The relevant query is as follows:

SELECT owner, object_type, object_name

FROM     dba_objects

WHERE  status = ‘INVALID’

AND       object_name IN (SELECT referenced_name

                                                               FROM    dba_dependencies

                                                               WHERE  name = ‘<INVALID_OBJECT_NAME>’);


This will bring results down only one level of dependencies.