SELECT * 

FROM DBA_DEPENDENCIES 

WHERE REFERENCED_NAME = '<table_name>'

AND REFERENCED_TYPE = 'TABLE'

AND TYPE IN ('VIEW', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'PACKAGE BODY');

/