APPS.IEX_TRX_VIEW_PKG dependencies on AR_CASH_RECEIPT_HISTORY

Line 21: FROM ar_cash_receipt_history acrh

17: AND nvl(acr.confirmed_flag, 'Y') = 'Y'
18: AND acr.reversal_date is null
19: AND EXISTS
20: (SELECT '1'
21: FROM ar_cash_receipt_history acrh
22: WHERE acr.cash_receipt_id = acrh.cash_receipt_id
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

Line 29: ar_cash_receipt_history acrh

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
33: AND nvl(acr.confirmed_flag, 'Y') = 'Y'

Line 181: FROM ar_cash_receipt_history acrh

177: AND ara.display = 'Y'
178: -- End-fix bug #4572737-JYPARK-08/30/2005-exclude unapplied receipt
179: AND EXISTS
180: (SELECT '1'
181: FROM ar_cash_receipt_history acrh
182: WHERE acr.cash_receipt_id = acrh.cash_receipt_id
183: AND ACRH.STATUS NOT IN (DECODE (ACRH.FACTOR_FLAG, 'Y', 'RISK_ELIMINATED', 'N', ' '), 'REVERSED')
184: AND ACRH.CURRENT_RECORD_FLAG = 'Y');
185:

Line 190: ar_cash_receipt_history acrh

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
194: AND nvl(acr.confirmed_flag, 'Y') = 'Y'