APPS.IEX_TRX_VIEW_PKG dependencies on AR_CASH_RECEIPTS

Line 13: FROM ar_cash_receipts acr,

9: --Begin - schekuri - Date 13-Apr-2005 - Bug#4113120
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'

Line 27: FROM ar_cash_receipts acr,

23: AND ACRH.STATUS NOT IN (DECODE (ACRH.FACTOR_FLAG, 'Y', 'RISK_ELIMINATED', 'N', ' '), 'REVERSED')
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

Line 170: FROM ar_cash_receipts acr,

166: --Begin - schekuri - Date 13-Apr-2005 - Bug#4113120
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'

Line 188: FROM ar_cash_receipts acr,

184: AND ACRH.CURRENT_RECORD_FLAG = 'Y');
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