APPS.AD_PATCH_ANALYSIS_ENGINE dependencies on AD_SNAPSHOTS

Line 504: FROM ad_snapshots

500: WHERE bug_number = to_char(p_bug_number)
501: AND ARU_RELEASE_NAME = p_release)
502: AND snapshot_id in
503: (SELECT snapshot_id
504: FROM ad_snapshots
505: WHERE snapshot_name = 'GLOBAL_VIEW'
506: and snapshot_type in ('G','Q'));
507: ELSE
508: --if p_baseline like %.0 remove the .0

Line 524: FROM ad_snapshots

520: AND baseline_name = adj_baseline
521: AND ARU_RELEASE_NAME = p_release)
522: AND snapshot_id in
523: (SELECT snapshot_id
524: FROM ad_snapshots
525: WHERE snapshot_name = 'GLOBAL_VIEW'
526: and snapshot_type in ('G','Q'));
527: END IF;
528: