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 153: ra_customer_trx_all ra

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

Line 154: WHERE adj.customer_trx_id = ra.customer_trx_id

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

Line 211: ra_customer_trx cm,

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

Line 212: ra_customer_trx inv

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