APPS.IEX_TRX_VIEW_PKG dependencies on AR_RECEIVABLE_APPLICATIONS

Line 14: ar_receivable_applications ara

10: --modified the query to reduce the Disk reads and Query reads
11: cursor c_pay IS
12: SELECT '1'
13: FROM ar_cash_receipts acr,
14: ar_receivable_applications ara
15: WHERE ara.applied_payment_schedule_id = p_payment_schedule_id
16: AND ara.cash_receipt_id = acr.cash_receipt_id
17: AND nvl(acr.confirmed_flag, 'Y') = 'Y'
18: AND acr.reversal_date is null

Line 28: ar_receivable_applications ara,

24: AND ACRH.CURRENT_RECORD_FLAG = 'Y');
25: /*cursor c_pay IS
26: SELECT '1'
27: FROM ar_cash_receipts acr,
28: ar_receivable_applications ara,
29: ar_cash_receipt_history acrh
30: WHERE ara.applied_payment_schedule_id = p_payment_schedule_id
31: AND ara.cash_receipt_id = acr.cash_receipt_id
32: AND acr.cash_receipt_id = acrh.cash_receipt_id

Line 171: ar_receivable_applications ara

167: --modified the query to reduce the Disk reads and Query reads
168: cursor c_pay(p_payment_schedule_id NUMBER) IS
169: SELECT '1'
170: FROM ar_cash_receipts acr,
171: ar_receivable_applications ara
172: WHERE ara.applied_payment_schedule_id = p_payment_schedule_id
173: AND ara.cash_receipt_id = acr.cash_receipt_id
174: AND nvl(acr.confirmed_flag, 'Y') = 'Y'
175: AND acr.reversal_date is null

Line 189: ar_receivable_applications ara,

185:
186: /*cursor c_pay(p_payment_schedule_id NUMBER) IS
187: SELECT '1'
188: FROM ar_cash_receipts acr,
189: ar_receivable_applications ara,
190: ar_cash_receipt_history acrh
191: WHERE ara.applied_payment_schedule_id = p_payment_schedule_id
192: AND ara.cash_receipt_id = acr.cash_receipt_id
193: AND acr.cash_receipt_id = acrh.cash_receipt_id