SELECT *
FROM DBA_DEPENDENCIES
WHERE REFERENCED_NAME = '<table_name>'
AND REFERENCED_TYPE = 'TABLE'
AND TYPE IN ('VIEW', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'PACKAGE BODY');
/
SELECT *
FROM DBA_DEPENDENCIES
WHERE REFERENCED_NAME = '<table_name>'
AND REFERENCED_TYPE = 'TABLE'
AND TYPE IN ('VIEW', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'PACKAGE BODY');
/