[Home] [Help]
40: -- based on invoice currency)
41: -- else calculate using exchange rate for new check.
42:
43: CURSOR c_new_payments IS
44: SELECT ap_invoice_payments_s.nextval new_invoice_payment_id
45: , AIP.invoice_id invoice_id
46: , AIP.payment_num payment_num
47: , NVL(AIP.amount,0) amount
48: , AIP.set_of_books_id set_of_books_id
99: , AC.global_attribute20
100: , AC.global_attribute_category
101: , AC.org_id /* Bug 4759178. Added org_id */
102: FROM ap_checks AC
103: , ap_invoice_payments AIP
104: , ap_payment_schedules APS
105: , ap_system_parameters ASP
106: WHERE AC.check_id = P_Old_Check_Id
107: AND AIP.check_id = AC.check_id
152:
153:
154: SELECT ac.doc_category_code, aip.set_of_books_id
155: INTO l_doc_category_code, l_set_of_books_id
156: FROM ap_checks ac, ap_invoice_payments aip
157: WHERE AC.check_id = P_old_check_id
158: AND AC.check_id = AIP.check_id
159: AND AC.doc_sequence_value IS NOT NULL
160: AND rownum = 1;
377: -- BUG 4121323 : selecting payment_base_amount
378: select sum(nvl(payment_base_amount,amount)+decode(rec_new_payments.awt_include_discount_amt,
379: 'Y',nvl(discount_taken,0),0))
380: into l_prev_amt_paid
381: from ap_invoice_payments aip
382: where aip.reversal_inv_pmt_id is null
383: and aip.invoice_id = rec_new_payments.invoice_id
384: and aip.check_id= p_old_check_id;
385:
389: from ap_invoice_distributions aid
390: where aid.invoice_id=rec_new_payments.invoice_id
391: and aid.awt_invoice_payment_id
392: in (select invoice_payment_id
393: from ap_invoice_payments aip
394: where aip.check_id=p_old_check_id
395: and aip.reversal_inv_pmt_id is null
396: and aip.invoice_id=rec_new_payments.invoice_id);
397:
400:
401: /* Bug 3309344 commenting this select statement
402: SELECT MAX(AID.awt_gross_amount)
403: INTO l_awt_gross_amount
404: FROM AP_INVOICE_PAYMENTS AIP,
405: AP_INVOICE_DISTRIBUTIONS AID
406: WHERE AIP.invoice_id = rec_new_payments.invoice_id
407: AND AIP.check_id = p_old_check_id
408: AND AIP.reversal_inv_pmt_id IS NULL