DBA Data[Home] [Help]

APPS.AP_ACCOUNTING_EVENTS_PKG dependencies on AP_PREPAY_APP_DISTS

Line 5320: FROM ap_prepay_app_dists apad,

5316: WHERE aid.invoice_id = l_prepay_app_invoice_ids(i)
5317: AND aid.accounting_event_id = p_adj_accounting_event_id
5318: AND NOT EXISTS
5319: (SELECT 1
5320: FROM ap_prepay_app_dists apad,
5321: ap_prepay_history_all apph
5322: WHERE apad.prepay_history_id = apph.prepay_history_id
5323: AND apph.transaction_type = 'PREPAYMENT APPLIED'
5324: AND apph.invoice_id = l_prepay_app_invoice_ids(i)

Line 7848: UPDATE AP_Prepay_App_Dists APAD

7844:
7845: IF l_prepay_hist_tab.count >0 THEN
7846:
7847: FORALL i IN l_prepay_hist_tab.FIRST..l_prepay_hist_tab.LAST
7848: UPDATE AP_Prepay_App_Dists APAD
7849: SET Accounting_Event_ID = p_accounting_event_id
7850: WHERE Prepay_History_ID = l_prepay_hist_tab(i);
7851:
7852: END IF;