APPS.AP_SLA_PROCESSING_PKG dependencies on AP_PREPAY_APP_DISTS

Line 27: -- ap_payment_hist_dists ap_prepay_app_dists

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

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

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

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

2455: 'MANUAL PAYMENT ADJUSTED', 'REFUND RECORDED', 'REFUND ADJUSTED',
2456: 'REFUND CANCELLED', 'MANUAL REFUND ADJUSTED'); --bug 10336668
2457: END IF;
2458:
2459: /* Get the total prepaid amount from the ap_prepay_app_dists table */
2460: -- 9803363 , added code to get dist id and awt calculated on it
2461: SELECT SUM(APAD.Amount)
2462: INTO l_prepaid_acctd_amt
2463: FROM AP_Prepay_App_Dists APAD,

Line 2463: FROM AP_Prepay_App_Dists APAD,

2459: /* Get the total prepaid amount from the ap_prepay_app_dists table */
2460: -- 9803363 , added code to get dist id and awt calculated on it
2461: SELECT SUM(APAD.Amount)
2462: INTO l_prepaid_acctd_amt
2463: FROM AP_Prepay_App_Dists APAD,
2464: AP_Prepay_History_All APH
2465: WHERE APAD.Invoice_Distribution_ID in (select p_invoice_distribution_id from dual
2466: union
2467: /* awt distributions which are applied on the p_invoice_distribution_id*/

Line 2469: from ap_prepay_app_dists aphd_awt,

2465: WHERE APAD.Invoice_Distribution_ID in (select p_invoice_distribution_id from dual
2466: union
2467: /* awt distributions which are applied on the p_invoice_distribution_id*/
2468: select distinct aphd_awt.invoice_distribution_id
2469: from ap_prepay_app_dists aphd_awt,
2470: ap_prepay_app_dists aphd_item
2471: where 1=1
2472: and aphd_item.invoice_distribution_id = p_invoice_distribution_id
2473: and aphd_item.prepay_dist_lookup_code <> 'AWT'

Line 2470: ap_prepay_app_dists aphd_item

2466: union
2467: /* awt distributions which are applied on the p_invoice_distribution_id*/
2468: select distinct aphd_awt.invoice_distribution_id
2469: from ap_prepay_app_dists aphd_awt,
2470: ap_prepay_app_dists aphd_item
2471: where 1=1
2472: and aphd_item.invoice_distribution_id = p_invoice_distribution_id
2473: and aphd_item.prepay_dist_lookup_code <> 'AWT'
2474: and aphd_awt.awt_related_id = aphd_item.invoice_distribution_id