SYS.AD_ZD_SYS dependencies on DBA_DEPENDENCIES

Line 606: and not exists ( select null from dba_dependencies d

602: (select owner,object_name,object_type
603: from dba_objects o1
604: where o1.edition_name <> x_edition
605: and o1.owner in ( select username from dba_users where editions_enabled = 'Y')
606: and not exists ( select null from dba_dependencies d
607: where d.owner = o1.owner
608: and d.name = o1.object_name
609: and d.type = o1.object_type
610: and d.referenced_owner IN (select username from dba_users where editions_enabled = 'Y')

Line 620: FROM dba_dependencies c

616: where o2.edition_name <> x_edition
617: and o2.owner in (select username from dba_users where editions_enabled = 'Y')
618: AND o2.object_type = 'PACKAGE BODY'
619: AND NOT EXISTS ( SELECT NULL
620: FROM dba_dependencies c
621: WHERE c.owner = o2.owner
622: AND c.name = o2.object_name
623: AND c.TYPE = 'PACKAGE BODY'
624: AND c.referenced_owner IN (select username from dba_users where editions_enabled = 'Y')

Line 645: and not exists ( select null from dba_dependencies d

641: select owner,object_name,object_type
642: from dba_objects o2
643: where o2.edition_name <> x_edition
644: and o2.owner in ( select username from dba_users where editions_enabled = 'Y')
645: and not exists ( select null from dba_dependencies d
646: where d.owner = o2.owner
647: and d.name = o2.object_name
648: and d.type = o2.object_type
649: and d.referenced_owner IN (select username from dba_users where editions_enabled = 'Y')

Line 659: FROM dba_dependencies c

655: where o3.edition_name <> x_edition
656: and o3.owner in ( select username from dba_users where editions_enabled = 'Y')
657: AND o3.object_type = 'PACKAGE BODY'
658: AND NOT EXISTS ( SELECT NULL
659: FROM dba_dependencies c
660: WHERE c.owner = o3.owner
661: AND c.name = o3.object_name
662: AND c.TYPE = 'PACKAGE BODY'
663: AND c.referenced_owner IN (select username from dba_users where editions_enabled = 'Y')