Querry to Find Depended objects

Querry to Find Depended objects 

SELECT "NAME", "OWNER", "TYPE", "OBJECT_ID", "STATUS", "TYPE_LINK" FROM(
SELECT DISTINCT
   'SQLDEV:LINK:'||b.owner||':'||b.object_type||':'/*||lpad(' ',4*l)*/||b.object_name||':oracle.dbtools.raptor.controls.grid.DefaultDrillLink' as NAME,
   b.owner,
   b.object_type TYPE,
   B.OBJECT_ID,
   b.status,
   replace(b.object_type,' ','_') type_link,
   b.owner sdev_link_owner,
   b.object_name sdev_link_name,
   b.object_type sdev_link_type
FROM
   sys.all_objects b,
   (SELECT object_id, referenced_object_id, level l, rownum ord
    FROM public_dependency
    START WITH object_id = :OBJECT_ID
    CONNECT BY NOCYCLE PRIOR referenced_object_id = object_id) c
WHERE b.object_id = c.referenced_object_id
AND b.owner NOT IN ('SYS', 'SYSTEM')
AND b.object_name <> 'DUAL'
--order by ord
);