APPS.ARP_XLA_EVENTS dependencies on AR_MISC_CASH_DISTRIBUTIONS

Line 1224: ' FROM ar_misc_cash_distributions' || l_all_clause || ' mcd, ' || CRLF ||

1220:
1221: log('l_select_clause ' || l_select_clause);
1222:
1223: l_from_clause :=
1224: ' FROM ar_misc_cash_distributions' || l_all_clause || ' mcd, ' || CRLF ||
1225: ' ar_cash_receipts' || l_all_clause || ' cr, ' || CRLF ||
1226: ' ar_cash_receipt_history' || l_all_clause || ' crh ' || CRLF;
1227:
1228: log('l_from_clause ' || l_from_clause);

Line 1293: ' ar_misc_cash_distributions' || l_all_clause || ' mcd ' || CRLF ;

1289: l_from_clause :=
1290: ' FROM xla_events' || ' ev1, ' || CRLF ||
1291: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||
1292: ' ar_cash_receipt_history' || l_all_clause || ' crh, ' || CRLF ||
1293: ' ar_misc_cash_distributions' || l_all_clause || ' mcd ' || CRLF ;
1294:
1295: l_where_clause :=
1296: ' WHERE decode(crh.created_from,
1297: ''RATE ADJUSTMENT TRIGGER'', ''MISC_RECP_RATE_ADJUST'',

Line 3404: UPDATE ar_misc_cash_distributions

3400: WHERE event_id = p_event_id;
3401:
3402: ELSIF p_xla_doc IN ('CRHMCD', 'MCD') THEN
3403:
3404: UPDATE ar_misc_cash_distributions
3405: SET event_id = NULL
3406: WHERE event_id = p_event_id;
3407:
3408: ELSIF p_xla_doc = 'TRH' THEN

Line 3651: UPDATE ar_misc_cash_distributions_all mcd

3647: IF p_xla_ev_rec.xla_doc_table = 'MCD' AND test_flag = 'N' THEN
3648: log('Bulk Updating misc cash distributions');
3649: FORALL m IN ev_rec.dist_row_id.FIRST .. ev_rec.dist_row_id.LAST
3650: --6785758
3651: UPDATE ar_misc_cash_distributions_all mcd
3652: SET mcd.event_id = ev_rec.dist_event_id(m),
3653: mcd.last_update_date = TRUNC(SYSDATE),
3654: mcd.last_update_login = l_last_update_login,
3655: mcd.last_updated_by = l_last_updated_by