APPS.AP_ACCTG_PAY_ROUND_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 196: FROM ap_invoice_payments_all

192: -- still pending processing
193:
194: SELECT MAX(accounting_event_id)
195: INTO l_acctg_event_id
196: FROM ap_invoice_payments_all
197: WHERE invoice_id = p_inv_rec.invoice_id
198: AND NVL(accrual_posted_flag, 'N') = 'N';
199:
200: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 438: AP_Invoice_Payments_All AIP

434: APHD.Invoice_Dist_Base_Amount)
435: INTO l_sum_pay_dist_base_amt
436: FROM AP_Payment_Hist_Dists APHD,
437: AP_Payment_History_All APH,
438: AP_Invoice_Payments_All AIP
439: WHERE ((APHD.Invoice_Distribution_ID = l_inv_dist_rec.invoice_distribution_id
440: AND APHD.Pay_Dist_Lookup_Code IN
441: ('CASH', 'DISCOUNT', 'FINAL PAYMENT ROUNDING'))
442: OR (APHD.Pay_Dist_Lookup_Code='AWT'

Line 461: AP_Invoice_Payments_All AIP

457: APHD.Invoice_Dist_Base_Amount)
458: INTO l_sum_pay_dist_base_amt
459: FROM AP_Payment_Hist_Dists APHD,
460: AP_Payment_History_All APH,
461: AP_Invoice_Payments_All AIP
462: WHERE ((APHD.Invoice_Distribution_ID = l_inv_dist_rec.invoice_distribution_id
463: AND APHD.Pay_Dist_Lookup_Code IN
464: ('CASH', 'DISCOUNT', 'FINAL PAYMENT ROUNDING' ))
465: OR (APHD.Pay_Dist_Lookup_Code='AWT'

Line 483: AP_Invoice_Payments_All AIP

479: APHD.Invoice_Dist_Base_Amount)
480: INTO l_sum_pay_dist_base_amt
481: FROM AP_Payment_Hist_Dists APHD,
482: AP_Payment_History_All APH,
483: AP_Invoice_Payments_All AIP
484: WHERE ((APHD.Invoice_Distribution_ID = l_inv_dist_rec.invoice_distribution_id
485: AND APHD.Pay_Dist_Lookup_Code IN
486: ('CASH', 'DISCOUNT', 'FINAL PAYMENT ROUNDING' ))
487: OR (APHD.Pay_Dist_Lookup_Code='AWT'

Line 1031: -- AP_INVOICE_PAYMENTS_ALL.INVOICE_BASE_AMOUNT

1027:
1028: -- Bug fix 6314128 Starts
1029: -- Handling the difference amount in l_inv_rate_diff_amt
1030: -- Rule: SUM(AP_PAYMENT_HIST_DISTS.INVOICE_DIST_BASE_AMOUNT) =
1031: -- AP_INVOICE_PAYMENTS_ALL.INVOICE_BASE_AMOUNT
1032:
1033: IF NVL(l_inv_rate_diff_amt,0) <> 0 THEN
1034:
1035: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN