APPS.AD_PATCH_ANALYSIS_ENGINE dependencies on AD_PA_ANALYSIS_RUN_BUGS

Line 358: FROM ad_pa_analysis_run_bugs

354:
355: -- Perform the insertion in the Patch Wizard tables if analysis_id is specified
356: IF (p_analysis_run_id > 0) THEN
357: SELECT analysis_run_bug_id INTO l_analysis_run_bug_id
358: FROM ad_pa_analysis_run_bugs
359: WHERE analysis_run_id = p_analysis_run_id
360: AND bug_number = p_bug_number
361: AND baseline = p_baseline;
362:

Line 364: UPDATE ad_pa_analysis_run_bugs

360: AND bug_number = p_bug_number
361: AND baseline = p_baseline;
362:
363: IF (l_analysis_run_bug_id > 0) THEN
364: UPDATE ad_pa_analysis_run_bugs
365: SET analysis_status = l_patch_status
366: WHERE analysis_run_id = p_analysis_run_id
367: AND bug_number = p_bug_number
368: AND baseline = p_baseline;