APPS.CE_AUTO_BANK_MATCH dependencies on CE_801_EFT_TRANSACTIONS_V

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

1957: | |
1958: | DESCRIPTION |
1959: | Using the statement line transaction number, transaction date |
1960: | and Amount try to find a |
1961: | matching batch for eft payments from CE_801_EFT_TRANSACTIONS_V |
1962: | |
1963: | CALLED BY |
1964: | match_line |
1965: --------------------------------------------------------------------- */

Line 2012: --FROM ce_801_EFT_transactions_v catv

2008: no_of_matches,
2009: CE_AUTO_BANK_MATCH.trx_group,
2010: CE_AUTO_BANK_MATCH.trx_org_id,
2011: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id
2012: --FROM ce_801_EFT_transactions_v catv
2013: FROM ce_available_transactions_tmp catv
2014: WHERE upper(catv.batch_name) =
2015: upper(CE_AUTO_BANK_MATCH.csl_bank_trx_number)
2016: AND catv.trx_date = CE_AUTO_BANK_MATCH.csl_trx_date

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

9025: END IF;
9026:
9027: ELSIF l_trx_source = 'PAY_EFT' THEN
9028: IF CE_AUTO_BANK_MATCH.av_801_eft_inserted_flag = 'N' THEN
9029: cep_standard.debug('inserting data from ce_801_eft_transactions_v');
9030:
9031: insert into ce_available_transactions_tmp
9032: (seq_id,
9033: ROW_ID,

Line 9170: from ce_801_eft_transactions_v

9166: LEGAL_ENTITY_ID,
9167: ORG_ID,
9168: CE_BANK_ACCT_USE_ID,
9169: 'N'
9170: from ce_801_eft_transactions_v
9171: where bank_account_id = p_bank_account_id;
9172:
9173: CE_AUTO_BANK_MATCH.av_801_eft_inserted_flag := 'Y';
9174: END IF;