APPS.ARP_BALANCE_CHECK dependencies on AR_CASH_RECEIPT_HISTORY

Line 201: select /*+ index(CRH AR_CASH_RECEIPT_HISTORY_N1) */

197: from ar_misc_cash_distributions
198: where cash_receipt_id = p_cr_id
199: and posting_control_id = -3
200: UNION ALL
201: select /*+ index(CRH AR_CASH_RECEIPT_HISTORY_N1) */
202: cash_receipt_id cr_id,
203: cash_receipt_history_id src_id,
204: 'CRH' src_tab,
205: 'N' cc_flag,

Line 207: from ar_cash_receipt_history

203: cash_receipt_history_id src_id,
204: 'CRH' src_tab,
205: 'N' cc_flag,
206: gl_date
207: from ar_cash_receipt_history
208: where cash_receipt_id = p_cr_id
209: and posting_control_id = -3
210: and nvl(postable_flag,'Y') = 'Y'
211: UNION ALL

Line 443: from ar_cash_receipts cr, ar_cash_receipt_history crh

439: crh.cash_receipt_history_id src_id,
440: 'CRH' src_tab,
441: 'N' cc_flag,
442: crh.gl_date
443: from ar_cash_receipts cr, ar_cash_receipt_history crh
444: where cr.cash_receipt_id between p_cr_id_low and p_cr_id_high
445: and cr.cash_receipt_id = crh.cash_receipt_id
446: and crh.posting_control_id = -3
447: and nvl(crh.postable_flag,'Y') = 'Y'