DBA Data[Home] [Help]

APPS.ARP_RECEIPTS_MAIN dependencies on AR_TRANSACTION_HISTORY

Line 2540: from ar_transaction_history th

2536: | pending risk elimination |
2537: +-----------------------------------------------------------------------*/
2538: update ar_receivable_applications
2539: set link_to_trx_hist_id = (select max(th.transaction_history_id)
2540: from ar_transaction_history th
2541: where th.customer_trx_id = p_app_rec.applied_customer_trx_id
2542: and th.event = 'MATURITY_DATE'
2543: and exists (select 'x'
2544: from ar_distributions ard