APPS.AD_ZD_ADOP dependencies on AD_PATCH_RUN_BUGS

Line 1018: from ad_patch_run_bugs

1014: v_process_cfhistory boolean := true;
1015:
1016: cursor bugs is
1017: select PATCH_RUN_BUG_ID
1018: from ad_patch_run_bugs
1019: where PATCH_RUN_ID=x_patch_run_id;
1020:
1021: cursor tes is
1022: select distinct abbreviation

Line 1036: delete ad_patch_run_bugs where patch_run_id=x_patch_run_id;

1032: where PATCH_RUN_BUG_ID=run_bug_id.patch_run_bug_id;
1033: end loop;
1034:
1035: -- Cleaning ad_patch_run_bug
1036: delete ad_patch_run_bugs where patch_run_id=x_patch_run_id;
1037:
1038: -- Cleaning Codelevels
1039: for te in tes
1040: loop