APPS.CE_AUTO_BANK_MATCH dependencies on CE_222_TXN_FOR_BATCH_V

Line 347: FROM ce_222_txn_for_batch_v a

343: b.batch_id NOWAIT;
344:
345: CURSOR Receipt_Amounts (X_batch_id NUMBER) IS
346: SELECT SUM(a.bank_account_amount)
347: FROM ce_222_txn_for_batch_v a
348: WHERE a.batch_id = x_batch_id
349: AND nvl(a.status, 'REMITTED') <> 'REVERSED';
350:
351: --

Line 2880: FROM ce_222_txn_for_batch_v catv

2876: CE_AUTO_BANK_MATCH.trx_cleared_amount,
2877: no_of_currencies,
2878: CE_AUTO_BANK_MATCH.trx_curr_amount,
2879: CE_AUTO_BANK_MATCH.csl_match_type
2880: FROM ce_222_txn_for_batch_v catv
2881: WHERE catv.batch_id = CE_AUTO_BANK_MATCH.trx_id
2882: AND nvl(catv.status, 'REMITTED') <> 'REVERSED';
2883: END IF;
2884: