APPS.ARP_ADJUSTMENTS_MAIN dependencies on AR_TRANSACTION_HISTORY

Line 1248: from ar_transaction_history th,

1244: p_ard_rec.ref_customer_trx_line_id,
1245: p_ard_rec.ref_cust_trx_line_gl_dist_id,
1246: p_ard_rec.ref_line_id
1247: --}
1248: from ar_transaction_history th,
1249: ar_payment_schedules pay,
1250: ar_distributions ard
1251: where
1252: th.transaction_history_id =

Line 1254: from ar_transaction_history th1

1250: ar_distributions ard
1251: where
1252: th.transaction_history_id =
1253: (select max(th1.transaction_history_id)
1254: from ar_transaction_history th1
1255: where nvl(th1.POSTABLE_FLAG, 'N') = 'Y'
1256: and th1.status IN ('UNPAID', 'PENDING_REMITTANCE')
1257: and th1.customer_trx_id = p_adj_rec.customer_trx_id)
1258: and th.customer_trx_id = pay.customer_trx_id

Line 1639: from ar_transaction_history th

1635: | History Record must be for Matured Pending Risk elimination Endorsment|
1636: +-----------------------------------------------------------------------*/
1637: update ar_adjustments
1638: set link_to_trx_hist_id = (select max(th.transaction_history_id)
1639: from ar_transaction_history th
1640: where th.customer_trx_id = p_adj_rec.customer_trx_id
1641: and th.event = 'MATURITY_DATE'
1642: and exists (select 'x'
1643: from ar_distributions ard