DBA Data[Home] [Help]

APPS.CE_AUTO_BANK_MATCH dependencies on CE_801_TRANSACTIONS_V

Line 3865: --FROM ce_801_transactions_v catv

3861: CE_AUTO_BANK_MATCH.trx_exchange_rate_type,
3862: CE_AUTO_BANK_MATCH.trx_org_id,
3863: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id,
3864: CE_AUTO_BANK_MATCH.gt_seq_id
3865: --FROM ce_801_transactions_v catv
3866: FROM ce_available_transactions_tmp catv
3867: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
3868: AND catv.bank_account_amount = CE_AUTO_BANK_MATCH.csl_amount
3869: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, catv.org_id)

Line 8880: cep_standard.debug('inserting data from ce_801_transactions_v');

8876: END IF;
8877:
8878: ELSIF l_trx_source = 'PAY' THEN
8879: IF CE_AUTO_BANK_MATCH.av_801_inserted_flag = 'N' THEN
8880: cep_standard.debug('inserting data from ce_801_transactions_v');
8881:
8882: insert into ce_available_transactions_tmp
8883: (seq_id,
8884: ROW_ID,

Line 9021: from ce_801_transactions_v

9017: LEGAL_ENTITY_ID,
9018: ORG_ID,
9019: CE_BANK_ACCT_USE_ID,
9020: 'N'
9021: from ce_801_transactions_v
9022: where bank_account_id = p_bank_account_id;
9023:
9024: CE_AUTO_BANK_MATCH.av_801_inserted_flag := 'Y';
9025: END IF;