DBA Data[Home] [Help]

APPS.CE_AUTO_BANK_MATCH dependencies on CE_101_TRANSACTIONS_V

Line 3914: --FROM ce_101_transactions_v catv

3910: CE_AUTO_BANK_MATCH.trx_exchange_rate,
3911: CE_AUTO_BANK_MATCH.trx_exchange_rate_date,
3912: CE_AUTO_BANK_MATCH.trx_exchange_rate_type,
3913: CE_AUTO_BANK_MATCH.gt_seq_id
3914: --FROM ce_101_transactions_v catv
3915: FROM ce_available_transactions_tmp catv
3916: WHERE catv.trx_type = tx_type
3917: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
3918: AND catv.trx_number = CE_AUTO_BANK_MATCH.csl_bank_trx_number

Line 8576: cep_standard.debug('inserting data from ce_101_transactions_v');

8572: ELSIF l_trx_source = 'JE' THEN
8573:
8574: IF CE_AUTO_BANK_MATCH.av_101_inserted_flag = 'N' THEN
8575:
8576: cep_standard.debug('inserting data from ce_101_transactions_v');
8577:
8578: insert into ce_available_transactions_tmp
8579: (seq_id,
8580: ROW_ID,

Line 8719: from ce_101_transactions_v

8715: LEGAL_ENTITY_ID,
8716: ORG_ID,
8717: CE_BANK_ACCT_USE_ID,
8718: 'N'
8719: from ce_101_transactions_v
8720: where bank_account_id = p_bank_account_id;
8721:
8722: CE_AUTO_BANK_MATCH.av_101_inserted_flag := 'Y';
8723: END IF;