APPS.AD_PATCH_ANALYSIS_ENGINE dependencies on AD_SNAPSHOT_BUGFIXES

Line 496: FROM ad_snapshot_bugfixes

492:
493: IF ( length(trim(p_baseline)) = 0 OR p_baseline = 'R12') THEN
494:
495: SELECT count(SNAPSHOT_BUG_ID) INTO l_count
496: FROM ad_snapshot_bugfixes
497: WHERE bugfix_id in
498: (SELECT bug_id FROM AD_BUGS
499: WHERE bug_number = to_char(p_bug_number)
500: AND ARU_RELEASE_NAME = p_release)

Line 509: FROM ad_snapshot_bugfixes

505: and snapshot_type = 'G');
506: ELSE
507:
508: SELECT count(SNAPSHOT_BUG_ID) INTO l_count
509: FROM ad_snapshot_bugfixes
510: WHERE bugfix_id in
511: (SELECT bug_id FROM AD_BUGS
512: WHERE bug_number = to_char(p_bug_number)
513: AND baseline_name = p_baseline