DBA Data[Home] [Help]

APPS.AR_ARXAPRMB_XMLP_PKG dependencies on AR_CASH_RECEIPT_HISTORY

Line 131: FROM ar_cash_receipt_history crh,

127: ELSE
128:
129: SELECT sum(nvl(crh.amount,0)+nvl(crh.factor_discount_amount,0))
130: INTO l_amount
131: FROM ar_cash_receipt_history crh,
132: ar_cash_receipt_history crhprv
133: WHERE crh.batch_id = p_batch_id
134: AND crh.cash_receipt_history_id =
135: crhprv.reversal_cash_receipt_hist_id

Line 132: ar_cash_receipt_history crhprv

128:
129: SELECT sum(nvl(crh.amount,0)+nvl(crh.factor_discount_amount,0))
130: INTO l_amount
131: FROM ar_cash_receipt_history crh,
132: ar_cash_receipt_history crhprv
133: WHERE crh.batch_id = p_batch_id
134: AND crh.cash_receipt_history_id =
135: crhprv.reversal_cash_receipt_hist_id
136: AND crhprv.status = 'CONFIRMED'