DBA Data[Home] [Help]

APPS.AD_ZD_SEED dependencies on DUAL

Line 815: select 'Y' into l_exists from dual

811: -- In Patch Edition, table must be new (not visible in Run Edition)
812: if ad_zd.get_edition_type = 'PATCH' then
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

Line 837: select 'Y' into l_exists from dual

833:
834: -- LONG column not supported
835: begin
836: -- Check if long column exists
837: select 'Y' into l_exists from dual
838: where exists
839: ( select column_name
840: from dba_tab_columns
841: where owner = l_table_owner