[Home] [Help]
695: apip.invoice_id invoice_id
696: INTO l_check_id,
697: l_payment_num,
698: l_invoice_id
699: FROM ap_invoice_payments apip
700: WHERE apip.invoice_payment_id = P_Parent_Id;
701:
702: -- added to reverse the certificate.
703: select ac.payment_id
1249: IS
1250: SELECT apin.invoice_id invoice_id,
1251: apin.invoice_currency_code invoice_currency_code,
1252: apip.payment_num payment_num
1253: FROM ap_invoice_payments apip,
1254: ap_invoices apin
1255: WHERE apin.invoice_id = apip.invoice_id
1256: AND apip.check_id = P_Check_Id;
1257:
2154: FROM
2155: jl_zz_ap_inv_dis_wh jlwh,
2156: ap_invoices apin,
2157: ap_invoice_distributions apid,
2158: ap_invoice_payments apip,
2159: jl_zz_ap_supp_awt_types jlst,
2160: jl_zz_ap_sup_awt_cd jlsc,
2161: jl_zz_ap_awt_types jlty
2162: WHERE
2482: -- End Debug
2483:
2484: /*
2485: select TO_DATE(apip.ACCOUNTING_DATE, 'DD-MM-YYYY') into l_CODE_ACCOUNTING_DATE -- Argentina AWT ER
2486: from ap_invoice_payments apip
2487: where apip.INVOICE_PAYMENT_ID = rec_payment_wh.invoice_payment_id;
2488: */
2489:
2490: -- Bug: 8688219. Modified the payment Date Retrieval Logic for PPR
2492: THEN
2493: -- End Debug
2494: SELECT TO_DATE (apip.accounting_date, 'DD-MM-YYYY')
2495: INTO l_code_accounting_date -- Argentina AWT ER
2496: FROM ap_invoice_payments apip
2497: WHERE apip.invoice_payment_id = rec_payment_wh.invoice_payment_id;
2498: ELSIF (p_calling_module = 'AUTOSELECT') then
2499: SELECT TO_DATE (apsc.check_date, 'DD-MM-YYYY')
2500: INTO l_code_accounting_date -- Argentina AWT ER
2739: IF (p_calling_module = 'QUICKCHECK')
2740: THEN
2741: SELECT TO_DATE (apip.accounting_date, 'DD-MM-YYYY')
2742: INTO l_code_accounting_date -- Argentina AWT ER
2743: FROM ap_invoice_payments apip
2744: WHERE apip.invoice_payment_id = rec_payment_wh.invoice_payment_id;
2745: ELSIF (p_calling_module = 'AUTOSELECT') then
2746: SELECT TO_DATE (apsc.check_date, 'DD-MM-YYYY')
2747: INTO l_code_accounting_date -- Argentina AWT ER
3433: -- Payment Exchange Rate ER 8648739 End 6
3434: apip.invoice_payment_id invo_payment_id
3435: FROM ap_invoices apin,
3436: ap_invoice_distributions apid,
3437: ap_invoice_payments apip
3438: WHERE apin.invoice_id = apid.invoice_id
3439: AND apin.invoice_id = apip.invoice_id
3440: AND apip.check_id = P_Check_Id
3441: AND apid.line_type_lookup_code <> 'AWT'
4752: apip.payment_num payment_num,
4753: apip.amount amount,
4754: apip.payment_base_amount payment_base_amount,
4755: apip.invoice_base_amount invoice_base_amount
4756: FROM ap_invoice_payments apip
4757: WHERE apip.check_id = P_Check_Id
4758: FOR UPDATE OF apip.amount,
4759: apip.payment_base_amount,
4760: apip.invoice_base_amount;
4896: WHERE invoice_id = l_invoice_id;
4897:
4898: --------------------------------------------------------------
4899: -- Updates the payment amount
4900: -- Calling the AP Table Handler to update ap_invoice_payments.
4901: -- Bug 1827398
4902: --------------------------------------------------------------
4903: l_pay_amount := ap_utilities_pkg.ap_round_currency(
4904: l_pay_amount + (l_withhold_amount *
5982: apip.payment_num payment_num,
5983: apip.amount amount,
5984: apip.payment_base_amount payment_base_amount,
5985: apip.invoice_base_amount invoice_base_amount
5986: FROM ap_invoice_payments apip
5987: WHERE apip.check_id = P_Check_Id
5988: FOR UPDATE OF apip.amount,
5989: apip.payment_base_amount,
5990: apip.invoice_base_amount;
6010: P_Invoice_Id Number)
6011: IS
6012: SELECT sum(aid.amount)
6013: FROM ap_invoice_distributions aid,
6014: ap_invoice_payments aip,
6015: ap_invoices ai
6016: WHERE aid.invoice_id = aip.invoice_id
6017: AND ai.invoice_id = aid.invoice_id
6018: AND aid.invoice_id = P_Invoice_Id
6024: --bug 12335657 AND NVL(aid.REVERSAL_FLAG,'N') <> 'Y'
6025: UNION
6026: SELECT sum(aid.amount)
6027: FROM ap_invoice_distributions aid,
6028: ap_invoice_payments aip,
6029: ap_invoices ai
6030: WHERE aid.invoice_id = aip.invoice_id
6031: AND ai.invoice_id = aid.invoice_id
6032: AND aid.invoice_id = P_Invoice_Id
6152: WHERE invoice_id = l_invoice_id;
6153:
6154: --------------------------------------------------------------
6155: -- Updates the payment amount
6156: -- Calling the AP Table Handler to update ap_invoice_payments.
6157: --------------------------------------------------------------
6158: l_pay_amount := l_pay_amount - (l_withhold_amount *
6159: nvl(l_payment_cross_rate, 1));
6160: