APPS.AP_SLA_PROCESSING_PKG dependencies on AP_PREPAY_HISTORY_ALL

Line 202: UPDATE ap_prepay_history_all APPH

198: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
199: ---------------------------------------------------------------------
200:
201: FORALL i IN 1 .. p_event_ids.count
202: UPDATE ap_prepay_history_all APPH
203: SET POSTED_FLAG = 'S'
204: WHERE APPH.accounting_event_id = p_event_ids(i);
205:
206: -- COMMIT; bug 7351478

Line 1302: UPDATE ap_prepay_history_all APPH

1298: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1299: -----------------------------------------------------------------------
1300:
1301: FORALL num in 1 .. l_event_list.COUNT
1302: UPDATE ap_prepay_history_all APPH
1303: SET APPH.posted_flag = 'Y'
1304: WHERE APPH.accounting_event_id = l_event_list(num);
1305:
1306: -----------------------------------------------------------------------

Line 1500: UPDATE ap_prepay_history_all APPH

1496: SET POSTED_FLAG = 'N'
1497: WHERE AIP.accounting_event_id in
1498: ( select event_id from xla_events_gt);
1499:
1500: UPDATE ap_prepay_history_all APPH
1501: SET APPH.posted_flag = 'N'
1502: WHERE APPH.accounting_event_id in
1503: ( select event_id from xla_events_gt);
1504: -- */

Line 1870: UPDATE ap_prepay_history_all APPH

1866: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1867: ---------------------------------------------------------------------
1868:
1869: FORALL i IN 1 .. l_event_ids.count
1870: UPDATE ap_prepay_history_all APPH
1871: SET APPH.posted_flag = 'N'
1872: WHERE APPH.accounting_event_id = l_event_ids(i);
1873:
1874: ---------------------------------------------------------------------

Line 2095: AP_Prepay_History_All APH

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';
2099: