DBA Data[Home] [Help]

APPS.AR_POSTBATCH_PARALLEL dependencies on AR_CASH_RECEIPTS

Line 240: FROM ar_cash_receipts cr,

236: fnd_file.put_line( FND_FILE.LOG, ' Getting the applied count and applied amount');
237:
238: SELECT count(*), nvl(sum(cr.amount),0)
239: INTO l_act_app_cnt, l_act_app_amt
240: FROM ar_cash_receipts cr,
241: ar_cash_receipt_history crh
242: WHERE cr.cash_receipt_id = crh.cash_receipt_id
243: AND crh.batch_id = p_batch_id
244: AND cr.status = 'APP';