SQL>
SQL>
SQL> select owner || '.' || name name, type, dependency_type
2 from dba_dependencies
3 where referenced_owner = 'HR' and referenced_name = 'EMPLOYEES'
4 /
NAME TYPE DEPE
------------------------------ ----------------- ----
HR.EMP_DETAILS_VIEW VIEW HARD
HR.SECURE_EMPLOYEES TRIGGER HARD
HR.UPDATE_JOB_HISTORY TRIGGER HARD
3 rows selected.
SQL>
SQL> --