APPS.CE_AUTO_BANK_CLEAR1 dependencies on CE_222_TXN_FOR_BATCH_V

Line 19: --FROM ce_222_txn_for_batch_v a

15: a.gl_date receipt_gl_date,
16: a.exchange_rate_date exchange_rate_date,
17: a.exchange_rate_type exchange_rate_type,
18: a.seq_id seq_id
19: --FROM ce_222_txn_for_batch_v a
20: FROM ce_available_transactions_tmp a
21: WHERE a.batch_id = rbatch_id
22: AND nvl(a.status, 'REMITTED') <> 'REVERSED'
23: AND a.application_id = 222

Line 39: FROM ce_222_txn_for_batch_v a

35: a.receipt_gl_date receipt_gl_date,
36: a.exchange_rate_date exchange_rate_date,
37: a.exchange_rate_type exchange_rate_type,
38: a.org_id
39: FROM ce_222_txn_for_batch_v a
40: --FROM ce_available_transactions_tmp a
41: WHERE a.batch_id = rbatch_id
42: AND nvl(a.status, 'REMITTED') <> 'REVERSED';
43: