DBA Data[Home] [Help]

APPS.AD_PATCH_ANALYSIS_ENGINE dependencies on AD_SNAPSHOTS

Line 503: FROM ad_snapshots

499: WHERE bug_number = to_char(p_bug_number)
500: AND ARU_RELEASE_NAME = p_release)
501: AND snapshot_id =
502: (SELECT snapshot_id
503: FROM ad_snapshots
504: WHERE snapshot_name = 'GLOBAL_VIEW'
505: and snapshot_type = 'G');
506: ELSE
507:

Line 517: FROM ad_snapshots

513: AND baseline_name = p_baseline
514: AND ARU_RELEASE_NAME = p_release)
515: AND snapshot_id =
516: (SELECT snapshot_id
517: FROM ad_snapshots
518: WHERE snapshot_name = 'GLOBAL_VIEW'
519: and snapshot_type = 'G');
520: END IF;
521: