DBA Data[Home] [Help]

APPS.CE_AUTO_BANK_MATCH dependencies on CE_CASHFLOWS

Line 281: FROM ce_cashflows cc,

277: -- cashflow transaction
278: --
279: CURSOR lock_260_cf (X_call_mode VARCHAR2,trx_rowid VARCHAR2) IS
280: SELECT cc.cashflow_id
281: FROM ce_cashflows cc,
282: ce_statement_reconcils_all rec
283: WHERE cc.rowid = trx_rowid
284: AND rec.reference_id(+) = cc.cashflow_id
285: AND rec.reference_type(+) = 'CASHFLOW'

Line 295: FROM ce_cashflows cc

291: -- cashflow clearing
292: --
293: CURSOR clear_lock_260_cf (X_call_mode VARCHAR2,trx_rowid VARCHAR2) IS
294: SELECT cc.cashflow_id
295: FROM ce_cashflows cc
296: WHERE cc.rowid = trx_rowid
297: FOR UPDATE OF cc.cashflow_id NOWAIT;
298:
299: --

Line 1593: | Seq Matching Criteria Tolerance CE_CASHFLOWS column

1589: | DESCRIPTION |
1590: | Cash Managment transaction will be matched in the following
1591: | sequence
1592:
1593: | Seq Matching Criteria Tolerance CE_CASHFLOWS column
1594: | --- ----------------- --------- -------------------
1595: | 1 Statement Line ID Yes STATEMENT_LINE_ID
1596:
1597: For ZBA transfers created through the sweep transactions

Line 7510: -- bug 4435028 - get JEC lines from ce_cashflows

7506: P_AMOUNT NUMBER;
7507: BEGIN
7508: cep_standard.debug( '>>CE_AUTO_BANK_MATCH.match_stmt_line_JE ' );
7509:
7510: -- bug 4435028 - get JEC lines from ce_cashflows
7511:
7512: /*
7513: SELECT
7514: JEL.JE_HEADER_ID,

Line 10179: -- bug 4435028 amount in ce_cashflows should be positive ??

10175: -- will be negative. If the transaction is a
10176: -- MISC_DEBIT, reverse the sign on the amount.
10177: --
10178: /* JEC Bug 4234483 modified the IF condition below */
10179: -- bug 4435028 amount in ce_cashflows should be positive ??
10180: /*
10181: IF (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_DEBIT' and
10182: (CE_AUTO_BANK_MATCH.csl_je_status_flag is null OR
10183: (CE_AUTO_BANK_MATCH.csl_je_status_flag <> 'C'))) THEN