[Home] [Help]
4986: undo_output VARCHAR2(2000);
4987: BEGIN
4988: /* Added below update for bug 8888311 */
4989:
4990: UPDATE ap_awt_temp_distributions_all aatd
4991: SET withholding_amount = rec_dont_pay_invoices.withholding_amount
4992: WHERE invoice_id = rec_dont_pay_invoices.invoice_id
4993: AND payment_num =rec_dont_pay_invoices.payment_num
4994: AND checkrun_id = rec_dont_pay_invoices.checkrun_id
5515: undo_output VARCHAR2(2000);
5516: BEGIN
5517: /* Added below update for bug 8888311 */
5518:
5519: UPDATE ap_awt_temp_distributions_all aatd
5520: SET withholding_amount = rec_all_sel_invs.withholding_amount
5521: WHERE invoice_id = rec_all_sel_invs.invoice_id
5522: AND payment_num = rec_all_sel_invs.payment_num
5523: AND checkrun_id = rec_all_sel_invs.checkrun_id
5709:
5710: -- End Bug 6743242
5711:
5712: --Bug 9255311 Regroup should occur before withholding so that orphans are not
5713: --left in ap_awt_temp_distributions_all
5714: --regroup
5715:
5716: group_interest_credits(p_checkrun_id, l_current_calling_sequence);
5717:
5749: undo_output VARCHAR2(2000);
5750: BEGIN
5751: /* Added below update for bug 8888311 */
5752:
5753: UPDATE ap_awt_temp_distributions_all aatd
5754: SET withholding_amount = rec_dont_pay_invoices.withholding_amount
5755: WHERE invoice_id = rec_dont_pay_invoices.invoice_id
5756: AND payment_num =rec_dont_pay_invoices.payment_num
5757: AND checkrun_id = rec_dont_pay_invoices.checkrun_id
6426: select si.invoice_id
6427: , si.vendor_id
6428: , si.payment_num
6429: from ap_selected_invoices_all si
6430: , ap_awt_temp_distributions_all atd
6431: where si.ok_to_pay_flag = 'N'
6432: and dont_pay_reason_code = 'OVERPAYMENT'
6433: and si.invoice_id = atd.invoice_id
6434: and si.payment_num = atd.payment_num