DBA Data[Home] [Help]

APPS.CE_AUTO_BANK_MATCH dependencies on CE_222_TXN_FOR_BATCH_V

Line 328: FROM ce_222_txn_for_batch_v a

324: b.batch_id NOWAIT;
325:
326: CURSOR Receipt_Amounts (X_batch_id NUMBER) IS
327: SELECT SUM(a.bank_account_amount)
328: FROM ce_222_txn_for_batch_v a
329: WHERE a.batch_id = x_batch_id
330: AND nvl(a.status, 'REMITTED') <> 'REVERSED';
331:
332: --

Line 2923: ce_222_txn_for_batch_v catv

2919: no_of_currencies,
2920: CE_AUTO_BANK_MATCH.trx_curr_amount,
2921: CE_AUTO_BANK_MATCH.csl_match_type
2922: FROM
2923: ce_222_txn_for_batch_v catv
2924: WHERE
2925: catv.batch_id = CE_AUTO_BANK_MATCH.trx_id
2926: AND nvl(catv.status, 'REMITTED') <> 'REVERSED';
2927: END IF;