APPS.AP_ACCTG_PAY_ROUND_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 474: AP_Invoice_Payments_All AIP

470: APHD.Invoice_Dist_Base_Amount)
471: INTO l_sum_pay_dist_base_amt
472: FROM AP_Payment_Hist_Dists APHD,
473: AP_Payment_History_All APH,
474: AP_Invoice_Payments_All AIP
475: WHERE ((APHD.Invoice_Distribution_ID = l_inv_dist_rec.invoice_distribution_id
476: AND APHD.Pay_Dist_Lookup_Code IN
477: ('CASH', 'DISCOUNT', 'FINAL PAYMENT ROUNDING'))
478: OR (APHD.Pay_Dist_Lookup_Code='AWT'

Line 506: AP_Invoice_Payments_All AIP

502: APHD.Invoice_Dist_Base_Amount)
503: INTO l_sum_pay_dist_base_amt
504: FROM AP_Payment_Hist_Dists APHD,
505: AP_Payment_History_All APH,
506: AP_Invoice_Payments_All AIP
507: WHERE ((APHD.Invoice_Distribution_ID = l_inv_dist_rec.invoice_distribution_id
508: AND APHD.Pay_Dist_Lookup_Code IN
509: ('CASH', 'DISCOUNT', 'FINAL PAYMENT ROUNDING' ))
510: OR (APHD.Pay_Dist_Lookup_Code='AWT'

Line 537: AP_Invoice_Payments_All AIP

533: APHD.Invoice_Dist_Base_Amount)
534: INTO l_sum_pay_dist_base_amt
535: FROM AP_Payment_Hist_Dists APHD,
536: AP_Payment_History_All APH,
537: AP_Invoice_Payments_All AIP
538: WHERE ((APHD.Invoice_Distribution_ID = l_inv_dist_rec.invoice_distribution_id
539: AND APHD.Pay_Dist_Lookup_Code IN
540: ('CASH', 'DISCOUNT', 'FINAL PAYMENT ROUNDING' ))
541: OR (APHD.Pay_Dist_Lookup_Code='AWT'

Line 1258: -- AP_INVOICE_PAYMENTS_ALL.INVOICE_BASE_AMOUNT

1254:
1255: -- Bug fix 6314128 Starts
1256: -- Handling the difference amount in l_inv_rate_diff_amt
1257: -- Rule: SUM(AP_PAYMENT_HIST_DISTS.INVOICE_DIST_BASE_AMOUNT) =
1258: -- AP_INVOICE_PAYMENTS_ALL.INVOICE_BASE_AMOUNT
1259:
1260: /*Commenting out as added new code to avoid negative base amounts due to rounding Bug-7156680
1261: IF NVL(l_inv_rate_diff_amt,0) <> 0 THEN
1262:

Line 3197: -- sum(ap_invoice_payments_all.payment_base_amount) are not

3193: -------------------------------------------------------------------------------
3194: -- Final_Cash
3195: -- This is procedure is to handle cash rounding where the
3196: -- ap_checks_all.base_amount and
3197: -- sum(ap_invoice_payments_all.payment_base_amount) are not
3198: -- Matching.
3199: -- Bug 8288996
3200: --
3201: --

Line 3233: FROM ap_invoice_payments_all aip

3229: END IF;
3230:
3231:
3232: SELECT count(*) into l_do_cash_rounding
3233: FROM ap_invoice_payments_all aip
3234: WHERE check_id = P_XLA_Event_Rec.source_id_int_1
3235: AND NOT EXISTS (SELECT 1
3236: FROM ap_payment_hist_dists aphd
3237: WHERE aphd.invoice_payment_id = aip.invoice_payment_id);

Line 3254: ap_invoice_payments_all aip

3250: ac.amount
3251: INTO l_ac_base_amount, l_transaction_type, l_ac_amount
3252: FROM ap_checks_all ac,
3253: ap_system_parameters_all aps,
3254: ap_invoice_payments_all aip
3255: WHERE ac.org_id = aps.org_id
3256: AND ac.check_id = P_XLA_Event_Rec.source_id_int_1
3257: AND aip.check_id = ac.check_id
3258: AND ac.currency_code <> aps.base_currency_code