DBA Data[Home] [Help]

APPS.AR_POSTBATCH_PARALLEL dependencies on AR_CASH_RECEIPTS

Line 247: FROM ar_cash_receipts cr,

243: fnd_file.put_line( FND_FILE.LOG, ' Getting the applied count and applied amount');
244:
245: SELECT count(*), nvl(sum(cr.amount),0)
246: INTO l_act_app_cnt, l_act_app_amt
247: FROM ar_cash_receipts cr,
248: ar_cash_receipt_history crh
249: WHERE cr.cash_receipt_id = crh.cash_receipt_id
250: AND crh.batch_id = p_batch_id
251: AND cr.status = 'APP';