[Home] [Help]
49: -- based on invoice currency)
50: -- else calculate using exchange rate for new check.
51:
52: CURSOR c_new_payments IS
53: SELECT ap_invoice_payments_s.nextval new_invoice_payment_id
54: , AIP.invoice_id invoice_id
55: , AIP.payment_num payment_num
56: , NVL(AIP.amount,0) amount
57: , AIP.set_of_books_id set_of_books_id
108: , AC.global_attribute20
109: , AC.global_attribute_category
110: , AC.org_id /* Bug 4759178. Added org_id */
111: FROM ap_checks AC
112: , ap_invoice_payments AIP
113: , ap_payment_schedules APS
114: , ap_system_parameters ASP
115: WHERE AC.check_id = P_Old_Check_Id
116: AND AIP.check_id = AC.check_id
170:
171:
172: SELECT ac.doc_category_code, aip.set_of_books_id
173: INTO l_doc_category_code, l_set_of_books_id
174: FROM ap_checks ac, ap_invoice_payments aip
175: WHERE AC.check_id = P_old_check_id
176: AND AC.check_id = AIP.check_id
177: AND AC.doc_sequence_value IS NOT NULL
178: AND rownum = 1;
415: -- BUG 4121323 : selecting payment_base_amount
416: select sum(nvl(payment_base_amount,amount)+decode(rec_new_payments.awt_include_discount_amt,
417: 'Y',nvl(discount_taken,0),0))
418: into l_prev_amt_paid
419: from ap_invoice_payments aip
420: where aip.reversal_inv_pmt_id is null
421: and aip.invoice_id = rec_new_payments.invoice_id
422: and aip.check_id= p_old_check_id;
423:
433: from ap_invoice_distributions aid
434: where aid.invoice_id=rec_new_payments.invoice_id
435: and aid.awt_invoice_payment_id
436: in (select invoice_payment_id
437: from ap_invoice_payments aip
438: where aip.check_id=p_old_check_id
439: and aip.reversal_inv_pmt_id is null
440: and aip.invoice_id=rec_new_payments.invoice_id);
441:
479:
480: /* Bug 3309344 commenting this select statement
481: SELECT MAX(AID.awt_gross_amount)
482: INTO l_awt_gross_amount
483: FROM AP_INVOICE_PAYMENTS AIP,
484: AP_INVOICE_DISTRIBUTIONS AID
485: WHERE AIP.invoice_id = rec_new_payments.invoice_id
486: AND AIP.check_id = p_old_check_id
487: AND AIP.reversal_inv_pmt_id IS NULL