select  a.object_type, a.object_name,
  b.owner ref_owner, b.object_type ref_object_type, b.object_name ref_object_name
from  DBA_OBJECTS a, DBA_OBJECTS b,
(select object_id, referenced_object_id
  FROM PUBLIC_DEPENDENCY
  start with object_id = (select object_id
  from DBA_OBJECTS
  WHERE owner        = 'SCOTT'
  AND   object_name  = 'EMP_VIEW'
  AND   object_type  = 'VIEW')
   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 <> 'SYS' 
 and a.owner  <> 'DUAL' 
 and a.owner  <> 'SYSTEM' 
 and b.owner <> 'SYS' 
 and b.owner  <> 'DUAL' 
 and b.owner  <> 'SYSTEM'