[EN] WHICH SPs ARE USING DATABASE LINKS

select * from dba_dependencies where referenced_link_name is not null and (owner,name,type) in
(select owner,object_name,object_type from dba_objects
where object_type in ('FUNCTION','TRIGGER','PROCEDURE','PACKAGE','VIEW')
--and status = 'INVALID'
and owner = 'SEMA1')