select owner, object_type, object_name, status 
  from  sys.dba_objects 
where object_id in (    
               select object_id
                 from public_dependency 
               connect by prior object_id        = referenced_object_id
                 start with referenced_object_id = ( 
                                                     select object_id 
                                                       from sys.dba_objects
                                                     where owner        = 'FRAN'
                                                       and object_name  = 'DEPARTMENTS'
                                                       and object_type  = 'TABLE'
                                                   )
                   )
;