DBA Data[Home] [Help]

APPS.AD_ZD_SEED dependencies on DBA_OBJECTS_AE

Line 817: ( select syn.object_name from dba_objects_ae syn

813: begin
814: -- check if synonym exists in the run edition
815: select 'Y' into l_exists from dual
816: where exists
817: ( select syn.object_name from dba_objects_ae syn
818: where syn.owner = ad_zd.apps_schema
819: and syn.object_name = x_table_name
820: and syn.object_type = 'SYNONYM'
821: and syn.edition_name =

Line 822: ( select max(ed.edition_name) from dba_objects_ae ed

818: where syn.owner = ad_zd.apps_schema
819: and syn.object_name = x_table_name
820: and syn.object_type = 'SYNONYM'
821: and syn.edition_name =
822: ( select max(ed.edition_name) from dba_objects_ae ed
823: where ed.owner = syn.owner
824: and ed.object_name = syn.object_name
825: and ed.edition_name < ad_zd.get_edition ) );
826: error(c_module, 'Cannot upgrade existing table from Patch Edition: '