oracle 根据表查询涉及到的包、存储过程

select owner, 
       object_name,
       object_type,
       created,
       last_ddl_time,
       status,
       t.use_tables
  from dba_objects u
  left join (SELECT name,
                    type,
                    referenced_owner || '.' || referenced_name use_tables
               FROM dba_dependencies
              WHERE referenced_type IN ('TABLE')
                and type in ('PACKAGE BODY', 'PACKAGE', 'PROCEDURE', 'FUNCTION', 'TRIGGERS', 'SEQUENCE', 'SYNONYM', 'VIEW', 'MATERIALIZED VIEW', 'TYPE', '', 'TYPE BODY') 
    and referenced_name in (
          'TS_USER_INFO'
          ) 
              ) t
    on u.object_name = t.name
   and u.object_type = t.type
 where object_type in ('PACKAGE BODY', 'PACKAGE', 'PROCEDURE', 'FUNCTION', 'TRIGGERS', 'SEQUENCE', 'SYNONYM', 'VIEW', 'MATERIALIZED VIEW', 'TYPE', '', 'TYPE BODY') 
   and t.use_tables is not null ;