DBA Data[Home] [Help]

APPS.CE_AUTO_BANK_MATCH dependencies on CE_801_TRANSACTIONS_V

Line 3984: -- ce_801_transactions_v catv

3980: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id,
3981: CE_AUTO_BANK_MATCH.gt_seq_id
3982:
3983: FROM
3984: -- ce_801_transactions_v catv
3985: ce_available_transactions_tmp catv
3986: WHERE
3987: catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
3988: AND catv.bank_account_amount = CE_AUTO_BANK_MATCH.csl_amount

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

9124: END IF;
9125:
9126: ELSIF l_trx_source = 'PAY' THEN
9127: IF CE_AUTO_BANK_MATCH.av_801_inserted_flag = 'N' THEN
9128: cep_standard.debug('inserting data from ce_801_transactions_v');
9129:
9130: insert into ce_available_transactions_tmp
9131: (seq_id,
9132: ROW_ID,

Line 9269: from ce_801_transactions_v

9265: LEGAL_ENTITY_ID,
9266: ORG_ID,
9267: CE_BANK_ACCT_USE_ID,
9268: 'N'
9269: from ce_801_transactions_v
9270: where bank_account_id = p_bank_account_id;
9271:
9272: CE_AUTO_BANK_MATCH.av_801_inserted_flag := 'Y';
9273: END IF;