APPS.AP_SLA_PROCESSING_PKG dependencies on AP_PREPAY_APP_DISTS

Line 26: -- ap_payment_hist_dists ap_prepay_app_dists

22: -- | | |
23: -- | +---------------------------------------------+ |
24: -- | | |
25: -- /|\ /|\ /|\
26: -- ap_payment_hist_dists ap_prepay_app_dists
27: --
28: --
29: -- Each record in the AP_INVOICE_PAYMENTS_ALL table relates a portion of a
30: -- payment to an invoice.

Line 38: -- Each record in the AP_PREPAY_APP_DISTS table relates a prepayment

34: --
35: -- Each record in the AP_PAYMENT_HIST_DISTS table relates a payment
36: -- distribution to a distribution.
37: --
38: -- Each record in the AP_PREPAY_APP_DISTS table relates a prepayment
39: -- distribution to a distribution.
40: --
41: --
42: -- +-----------------+------------+---------------+

Line 2091: /* Get the total prepaid amount from the ap_prepay_app_dists table */

2087: 'REFUND RECORDED', 'REFUND ADJUSTED', 'REFUND CANCELLED');
2088:
2089: END IF;
2090:
2091: /* Get the total prepaid amount from the ap_prepay_app_dists table */
2092: SELECT SUM(APAD.Amount)
2093: INTO l_prepaid_acctd_amt
2094: FROM AP_Prepay_App_Dists APAD,
2095: AP_Prepay_History_All APH

Line 2094: FROM AP_Prepay_App_Dists APAD,

2090:
2091: /* Get the total prepaid amount from the ap_prepay_app_dists table */
2092: SELECT SUM(APAD.Amount)
2093: INTO l_prepaid_acctd_amt
2094: FROM AP_Prepay_App_Dists APAD,
2095: AP_Prepay_History_All APH
2096: WHERE APAD.Invoice_Distribution_ID = p_invoice_distribution_id
2097: AND APAD.Prepay_History_ID = APH.Prepay_History_ID
2098: AND APH.Posted_Flag = 'Y';