APPS.ARP_ADJUSTMENTS_MAIN dependencies on AR_TRANSACTION_HISTORY

Line 1241: from ar_transaction_history th,

1237: p_ard_rec.ref_customer_trx_line_id,
1238: p_ard_rec.ref_cust_trx_line_gl_dist_id,
1239: p_ard_rec.ref_line_id
1240: --}
1241: from ar_transaction_history th,
1242: ar_payment_schedules pay,
1243: ar_distributions ard
1244: where
1245: th.transaction_history_id =

Line 1247: from ar_transaction_history th1

1243: ar_distributions ard
1244: where
1245: th.transaction_history_id =
1246: (select max(th1.transaction_history_id)
1247: from ar_transaction_history th1
1248: where nvl(th1.POSTABLE_FLAG, 'N') = 'Y'
1249: and th1.status IN ('UNPAID', 'PENDING_REMITTANCE')
1250: and th1.customer_trx_id = p_adj_rec.customer_trx_id)
1251: and th.customer_trx_id = pay.customer_trx_id

Line 1615: from ar_transaction_history th

1611: | History Record must be for Matured Pending Risk elimination Endorsment|
1612: +-----------------------------------------------------------------------*/
1613: update ar_adjustments
1614: set link_to_trx_hist_id = (select max(th.transaction_history_id)
1615: from ar_transaction_history th
1616: where th.customer_trx_id = p_adj_rec.customer_trx_id
1617: and th.event = 'MATURITY_DATE'
1618: and exists (select 'x'
1619: from ar_distributions ard