DBA Data[Home] [Help]

APPS.ARP_XLA_EVENTS dependencies on AR_ADJUSTMENTS_ALL

Line 2580: ar_adjustments_all adj

2576: and ae2.event_id IN
2577: ( select MAX( ae.event_id )
2578: from xla_events ae,
2579: xla_transaction_entities_upg xt,
2580: ar_adjustments_all adj
2581: where adj.adjustment_id = ev_rec.trx_id(i)
2582: and NVL(xt.source_id_int_1,-99) = adj.adjustment_id
2583: and xt.entity_code = 'ADJUSTMENTS'
2584: and xt.ledger_id = adj.set_of_books_id

Line 3627: UPDATE ar_adjustments_all adj

3623:
3624: IF p_xla_ev_rec.xla_doc_table = 'ADJ' AND test_flag = 'N' THEN
3625: log('Bulk Updating Adjustments ');
3626: FORALL m IN ev_rec.dist_row_id.FIRST .. ev_rec.dist_row_id.LAST
3627: UPDATE ar_adjustments_all adj
3628: SET adj.event_id = ev_rec.dist_event_id(m),
3629: adj.last_update_date = TRUNC(SYSDATE),
3630: adj.last_update_login = l_last_update_login,
3631: adj.last_updated_by = l_last_updated_by