SELECT * FROM SYS.DBA_DEPENDENCIES WHERE REFERENCED_NAME = '' AND REFERENCED_TYPE IN ('PACKAGE', 'PROCEDURE', 'FUNCTION');