APPS.AD_FILE_UTIL dependencies on DUAL

Line 2413: from dual where not exists(select 'Already exists'

2409: 5,
2410: sysdate,
2411: 5,
2412: 'N' /* ACTIVE_FLAG is set to 'N'. (Refer CONCURRENT_SESSIONS) */
2413: from dual where not exists(select 'Already exists'
2414: from ad_appl_tops t
2415: where t.name = 'GLOBAL' and
2416: t.appl_top_type = 'G' and
2417: t.applications_system_name = p_apps_system_name);

Line 2451: from dual where not exists(select 'Already exists'

2447: sysdate, /* have any significance for GLOBAL_VIEW */
2448: 5,
2449: 5,
2450: sysdate
2451: from dual where not exists(select 'Already exists'
2452: from ad_snapshots s
2453: where s.appl_top_id = l_appl_top_id
2454: and s.snapshot_type = 'G'
2455: and s.snapshot_name = 'GLOBAL_VIEW');