APPS.CE_AUTO_BANK_MATCH dependencies on CE_801_EFT_TRANSACTIONS_V

Line 1976: | matching batch for eft payments from CE_801_EFT_TRANSACTIONS_V |

1972: | |
1973: | DESCRIPTION |
1974: | Using the statement line transaction number, transaction date |
1975: | and Amount try to find a |
1976: | matching batch for eft payments from CE_801_EFT_TRANSACTIONS_V |
1977: | |
1978: | CALLED BY |
1979: | match_line |
1980: --------------------------------------------------------------------- */

Line 2029: --FROM ce_801_EFT_transactions_v catv

2025: no_of_matches,
2026: CE_AUTO_BANK_MATCH.trx_group,
2027: CE_AUTO_BANK_MATCH.trx_org_id,
2028: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id
2029: --FROM ce_801_EFT_transactions_v catv
2030: FROM ce_available_transactions_tmp catv
2031: WHERE ltrim(upper(catv.batch_name)) =
2032: ltrim(upper(CE_AUTO_BANK_MATCH.csl_bank_trx_number))
2033: AND catv.trx_date = CE_AUTO_BANK_MATCH.csl_trx_date

Line 9277: cep_standard.debug('inserting data from ce_801_eft_transactions_v');

9273: END IF;
9274:
9275: ELSIF l_trx_source = 'PAY_EFT' THEN
9276: IF CE_AUTO_BANK_MATCH.av_801_eft_inserted_flag = 'N' THEN
9277: cep_standard.debug('inserting data from ce_801_eft_transactions_v');
9278:
9279: insert into ce_available_transactions_tmp
9280: (seq_id,
9281: ROW_ID,

Line 9418: from ce_801_eft_transactions_v

9414: LEGAL_ENTITY_ID,
9415: ORG_ID,
9416: CE_BANK_ACCT_USE_ID,
9417: 'N'
9418: from ce_801_eft_transactions_v
9419: where bank_account_id = p_bank_account_id;
9420:
9421: CE_AUTO_BANK_MATCH.av_801_eft_inserted_flag := 'Y';
9422: END IF;