APPS.AP_SLA_PROCESSING_PKG dependencies on AP_PAYMENT_HIST_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 35: -- Each record in the AP_PAYMENT_HIST_DISTS table relates a payment

31: --
32: -- Each record in the AP_INVOICE_DISTRIBUTIONS_ALL table relates a portion of
33: -- the cost of an invoice to an accounting cost object.
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.

Line 2053: FROM AP_Payment_Hist_Dists APHD,

2049:
2050: /* Getting the sum of dist amount for the given distribution */
2051: SELECT SUM(APHD.Invoice_Dist_Amount)
2052: INTO l_paid_acctd_amt
2053: FROM AP_Payment_Hist_Dists APHD,
2054: AP_Payment_History_All APH
2055: WHERE APHD.Invoice_Distribution_ID = p_invoice_distribution_id
2056: AND APH.Posted_Flag = 'Y'
2057: AND APH.Payment_History_ID = APHD.Payment_History_ID

Line 2067: FROM AP_Payment_Hist_Dists APHD,

2063:
2064: /* Getting the sum of dist amount for the given distribution */
2065: SELECT SUM(APHD.Invoice_Dist_Amount)
2066: INTO l_paid_acctd_amt
2067: FROM AP_Payment_Hist_Dists APHD,
2068: AP_Payment_History_All APH
2069: WHERE APHD.Invoice_Distribution_ID = p_invoice_distribution_id
2070: AND APH.Posted_Flag = 'Y'
2071: AND APH.Payment_History_ID = APHD.Payment_History_ID

Line 2080: FROM AP_Payment_Hist_Dists APHD,

2076:
2077: /* Getting the sum of dist amount for the given distribution */
2078: SELECT SUM(APHD.Invoice_Dist_Amount)
2079: INTO l_paid_acctd_amt
2080: FROM AP_Payment_Hist_Dists APHD,
2081: AP_Payment_History_All APH
2082: WHERE APHD.Invoice_Distribution_ID = p_invoice_distribution_id
2083: AND APH.Posted_Flag = 'Y'
2084: AND APH.Payment_History_ID = APHD.Payment_History_ID