APPS.JL_AR_AP_WITHHOLDING_PKG dependencies on AP_INVOICE_PAYMENTS

Line 687: FROM ap_invoice_payments apip

683: apip.invoice_id invoice_id
684: INTO l_check_id,
685: l_payment_num,
686: l_invoice_id
687: FROM ap_invoice_payments apip
688: WHERE apip.invoice_payment_id = P_Parent_Id;
689:
690: -- added to reverse the certificate.
691: select ac.payment_id

Line 1197: FROM ap_invoice_payments apip,

1193: IS
1194: SELECT apin.invoice_id invoice_id,
1195: apin.invoice_currency_code invoice_currency_code,
1196: apip.payment_num payment_num
1197: FROM ap_invoice_payments apip,
1198: ap_invoices apin
1199: WHERE apin.invoice_id = apip.invoice_id
1200: AND apip.check_id = P_Check_Id;
1201:

Line 2079: ap_invoice_payments apip,

2075: FROM
2076: jl_zz_ap_inv_dis_wh jlwh,
2077: ap_invoices apin,
2078: ap_invoice_distributions apid,
2079: ap_invoice_payments apip,
2080: jl_zz_ap_supp_awt_types jlst,
2081: jl_zz_ap_sup_awt_cd jlsc,
2082: jl_zz_ap_awt_types jlty
2083: WHERE

Line 3270: ap_invoice_payments apip

3266: nvl(apip.invoice_base_amount,apip.amount) payment_amount,
3267: apip.invoice_payment_id invo_payment_id
3268: FROM ap_invoices apin,
3269: ap_invoice_distributions apid,
3270: ap_invoice_payments apip
3271: WHERE apin.invoice_id = apid.invoice_id
3272: AND apin.invoice_id = apip.invoice_id
3273: AND apip.check_id = P_Check_Id
3274: AND apid.line_type_lookup_code <> 'AWT'

Line 4520: FROM ap_invoice_payments apip

4516: apip.payment_num payment_num,
4517: apip.amount amount,
4518: apip.payment_base_amount payment_base_amount,
4519: apip.invoice_base_amount invoice_base_amount
4520: FROM ap_invoice_payments apip
4521: WHERE apip.check_id = P_Check_Id
4522: FOR UPDATE OF apip.amount,
4523: apip.payment_base_amount,
4524: apip.invoice_base_amount;

Line 4663: -- Calling the AP Table Handler to update ap_invoice_payments.

4659: WHERE invoice_id = l_invoice_id;
4660:
4661: --------------------------------------------------------------
4662: -- Updates the payment amount
4663: -- Calling the AP Table Handler to update ap_invoice_payments.
4664: -- Bug 1827398
4665: --------------------------------------------------------------
4666: l_pay_amount := ap_utilities_pkg.ap_round_currency(
4667: l_pay_amount + (l_withhold_amount *

Line 5656: FROM ap_invoice_payments apip

5652: apip.payment_num payment_num,
5653: apip.amount amount,
5654: apip.payment_base_amount payment_base_amount,
5655: apip.invoice_base_amount invoice_base_amount
5656: FROM ap_invoice_payments apip
5657: WHERE apip.check_id = P_Check_Id
5658: FOR UPDATE OF apip.amount,
5659: apip.payment_base_amount,
5660: apip.invoice_base_amount;

Line 5684: ap_invoice_payments aip,

5680: P_Invoice_Id Number)
5681: IS
5682: SELECT sum(aid.amount)
5683: FROM ap_invoice_distributions aid,
5684: ap_invoice_payments aip,
5685: ap_invoices ai
5686: WHERE aid.invoice_id = aip.invoice_id
5687: AND ai.invoice_id = aid.invoice_id
5688: AND aid.invoice_id = P_Invoice_Id

Line 5698: ap_invoice_payments aip,

5694: AND NVL(aid.REVERSAL_FLAG,'N') <> 'Y'
5695: UNION
5696: SELECT sum(aid.amount)
5697: FROM ap_invoice_distributions aid,
5698: ap_invoice_payments aip,
5699: ap_invoices ai
5700: WHERE aid.invoice_id = aip.invoice_id
5701: AND ai.invoice_id = aid.invoice_id
5702: AND aid.invoice_id = P_Invoice_Id

Line 5825: -- Calling the AP Table Handler to update ap_invoice_payments.

5821: WHERE invoice_id = l_invoice_id;
5822:
5823: --------------------------------------------------------------
5824: -- Updates the payment amount
5825: -- Calling the AP Table Handler to update ap_invoice_payments.
5826: --------------------------------------------------------------
5827: l_pay_amount := l_pay_amount - (l_withhold_amount *
5828: nvl(l_payment_cross_rate, 1));
5829: