APPS.AP_SLA_PROCESSING_PKG dependencies on AP_PREPAY_HISTORY_ALL

Line 227: UPDATE ap_prepay_history_all APPH

223: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
224: ---------------------------------------------------------------------
225:
226: FORALL i IN 1 .. p_event_ids.count
227: UPDATE ap_prepay_history_all APPH
228: SET POSTED_FLAG = 'S'
229: -- bug 10101613
230: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
231: ,LAST_UPDATE_DATE = SYSDATE

Line 1048: UPDATE ap_prepay_history_all APPH

1044: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1045: -----------------------------------------------------------------------
1046:
1047: FORALL num in 1 .. l_event_list.COUNT
1048: UPDATE ap_prepay_history_all APPH
1049: SET APPH.posted_flag = 'Y'
1050: -- bug 10101613
1051: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1052: ,LAST_UPDATE_DATE = SYSDATE

Line 1775: UPDATE ap_prepay_history_all APPH

1771: SET POSTED_FLAG = 'N'
1772: WHERE AIP.accounting_event_id in
1773: ( select event_id from xla_events_gt);
1774:
1775: UPDATE ap_prepay_history_all APPH
1776: SET APPH.posted_flag = 'N'
1777: WHERE APPH.accounting_event_id in
1778: ( select event_id from xla_events_gt);
1779: -- */

Line 2151: UPDATE ap_prepay_history_all APPH

2147: -- bug9444952 : Setting posted flags to appropriate statuses
2148: -- in case the Event_Status_Code is 'N'
2149: --
2150: FORALL i IN 1 .. l_event_ids.count
2151: UPDATE ap_prepay_history_all APPH
2152: SET APPH.posted_flag =
2153: CASE
2154: WHEN l_event_status(i) = 'N' THEN 'Y'
2155: ELSE 'N'

Line 2464: AP_Prepay_History_All APH

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*/
2468: select distinct aphd_awt.invoice_distribution_id