APPS.AD_FILE_UTIL dependencies on DUAL

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

2489: 5,
2490: sysdate,
2491: 5,
2492: 'N' /* ACTIVE_FLAG is set to 'N'. (Refer CONCURRENT_SESSIONS) */
2493: from dual where not exists(select 'Already exists'
2494: from ad_appl_tops t
2495: where t.name = 'GLOBAL' and
2496: t.appl_top_type = 'G' and
2497: t.applications_system_name = p_apps_system_name);

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

2527: sysdate, /* have any significance for GLOBAL_VIEW */
2528: 5,
2529: 5,
2530: sysdate
2531: from dual where not exists(select 'Already exists'
2532: from ad_snapshots s
2533: where s.appl_top_id = l_appl_top_id
2534: and s.snapshot_type = l_global_snapshot_type
2535: and s.snapshot_name = 'GLOBAL_VIEW');