APPS.ARP_XLA_EVENTS dependencies on AR_MISC_CASH_DISTRIBUTIONS

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

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

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

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

Line 3416: UPDATE ar_misc_cash_distributions

3412: WHERE event_id = p_event_id;
3413:
3414: ELSIF p_xla_doc IN ('CRHMCD', 'MCD') THEN
3415:
3416: UPDATE ar_misc_cash_distributions
3417: SET event_id = NULL
3418: WHERE event_id = p_event_id;
3419:
3420: ELSIF p_xla_doc = 'TRH' THEN

Line 3663: UPDATE ar_misc_cash_distributions_all mcd

3659: IF p_xla_ev_rec.xla_doc_table = 'MCD' AND test_flag = 'N' THEN
3660: log('Bulk Updating misc cash distributions');
3661: FORALL m IN ev_rec.dist_row_id.FIRST .. ev_rec.dist_row_id.LAST
3662: --6785758
3663: UPDATE ar_misc_cash_distributions_all mcd
3664: SET mcd.event_id = ev_rec.dist_event_id(m),
3665: mcd.last_update_date = SYSDATE,
3666: mcd.last_update_login = l_last_update_login,
3667: mcd.last_updated_by = l_last_updated_by