SELECT   a.object_type,
           a.object_name,
           b.owner,
           b.object_type,
           b.object_name,
           b.object_id,
           b.status,
           b.last_ddl_time
    FROM   sys.DBA_OBJECTS a,
           sys.DBA_OBJECTS b,
           (    SELECT   object_id, referenced_object_id
                  FROM   public_dependency
            START WITH   object_id =
                            (SELECT   object_id
                               FROM   sys.DBA_OBJECTS
                              WHERE       wner = 'DFMS'
                                      AND object_name = 'SP_WIP_TRANSFER'
                                      AND object_type = 'PROCEDURE')
            CONNECT BY   PRIOR referenced_object_id = object_id) c
   WHERE       a.object_id = c.object_id
           AND b.object_id = c.referenced_object_id
           AND a.owner NOT IN ('SYS', 'SYSTEM')
           AND b.owner NOT IN ('SYS', 'SYSTEM')
           AND a.object_name <> 'DUAL'
           AND b.object_name <> 'DUAL'
ORDER BY   8 DESC;