APPS.ARP_PA_UTILS dependencies on RA_CUSTOMER_TRX

Line 113: ra_customer_trx cm,

109: ,l_xchange_gain
110: ,l_xchange_loss
111: FROM ar_receivable_applications app,
112: ar_cash_receipts cr,
113: ra_customer_trx cm,
114: ra_customer_trx inv
115: WHERE
116: applied_customer_trx_id = p_customer_trx_id
117: AND applied_customer_trx_id = inv.customer_trx_id

Line 114: ra_customer_trx inv

110: ,l_xchange_loss
111: FROM ar_receivable_applications app,
112: ar_cash_receipts cr,
113: ra_customer_trx cm,
114: ra_customer_trx inv
115: WHERE
116: applied_customer_trx_id = p_customer_trx_id
117: AND applied_customer_trx_id = inv.customer_trx_id
118: AND app.status in ('APP')

Line 152: ra_customer_trx_all ra

148: sum(adj.line_adjusted*ra.exchange_rate)
149: INTO l_line_adjusted ,
150: l_acctd_line_adjusted
151: FROM ar_adjustments_all adj ,
152: ra_customer_trx_all ra
153: WHERE adj.customer_trx_id = ra.customer_trx_id
154: AND adj.customer_trx_id = p_customer_trx_id
155: AND adj.status='A'
156: AND adj.apply_date <= p_as_of_date;

Line 153: WHERE adj.customer_trx_id = ra.customer_trx_id

149: INTO l_line_adjusted ,
150: l_acctd_line_adjusted
151: FROM ar_adjustments_all adj ,
152: ra_customer_trx_all ra
153: WHERE adj.customer_trx_id = ra.customer_trx_id
154: AND adj.customer_trx_id = p_customer_trx_id
155: AND adj.status='A'
156: AND adj.apply_date <= p_as_of_date;
157:

Line 210: ra_customer_trx cm,

206: FROM ar_receivable_applications app,
207: ar_mc_receivable_apps amr,
208: ar_cash_receipts cr,
209: gl_ledger_relationships glr,
210: ra_customer_trx cm,
211: ra_customer_trx inv
212: WHERE applied_customer_trx_id = p_customer_trx_id
213: AND applied_customer_trx_id = inv.customer_trx_id
214: AND app.status in ('APP')

Line 211: ra_customer_trx inv

207: ar_mc_receivable_apps amr,
208: ar_cash_receipts cr,
209: gl_ledger_relationships glr,
210: ra_customer_trx cm,
211: ra_customer_trx inv
212: WHERE applied_customer_trx_id = p_customer_trx_id
213: AND applied_customer_trx_id = inv.customer_trx_id
214: AND app.status in ('APP')
215: AND app.cash_receipt_id = cr.cash_receipt_id (+)