APPS.CE_AUTO_BANK_MATCH dependencies on CE_SYSTEM_PARAMETERS

Line 1755: FROM CE_SYSTEM_PARAMETERS s

1751: s.AUTHORIZATION_BAT,
1752: s.BSC_EXCHANGE_DATE_TYPE,
1753: s.BAT_EXCHANGE_DATE_TYPE,
1754: 1
1755: FROM CE_SYSTEM_PARAMETERS s
1756: WHERE s.legal_entity_id = CE_AUTO_BANK_MATCH.trx_legal_entity_id;
1757: */
1758: curr NUMBER;
1759: tx_type VARCHAR2(30);

Line 2198: ce_system_parameters sp,

2194: CE_AUTO_BANK_MATCH.trx_cleared_date,
2195: CE_AUTO_BANK_MATCH.trx_org_id,
2196: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id
2197: FROM gl_sets_of_books sob,
2198: ce_system_parameters sp,
2199: ce_statement_reconcils_all rec,
2200: ce_bank_acct_uses_ou_v aba,
2201: ce_bank_accounts ba,
2202: --ce_bank_acct_uses_ou_v aba2, -- Bug 9062935 removed use of view

Line 2303: ce_system_parameters sp,

2299: CE_AUTO_BANK_MATCH.trx_org_id,
2300: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id
2301: FROM
2302: gl_sets_of_books sob,
2303: ce_system_parameters sp,
2304: ce_statement_reconcils_all rec,
2305: /* Bug 13610807: do not use ce_bank_acct_uses_ou_v aba*/
2306: ce_bank_acct_uses_all aba,
2307: ce_bank_accounts ba,

Line 2483: ce_system_parameters sp,

2479: CE_AUTO_BANK_MATCH.trx_cleared_date,
2480: CE_AUTO_BANK_MATCH.trx_org_id,
2481: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id
2482: FROM gl_sets_of_books sob,
2483: ce_system_parameters sp,
2484: ce_statement_reconcils_all rec,
2485: ce_bank_accounts ba,
2486: ce_bank_acct_uses_ou_v aba,
2487: ap_payment_history_all aph,

Line 2579: ce_system_parameters sp,

2575: CE_AUTO_BANK_MATCH.trx_exchange_rate_type,
2576: CE_AUTO_BANK_MATCH.trx_org_id,
2577: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id
2578: FROM gl_sets_of_books sob,
2579: ce_system_parameters sp,
2580: ce_statement_reconcils_all rec,
2581: ce_bank_accounts ba,
2582: ce_bank_acct_uses_ou_v aba,
2583: ar_cash_receipt_history_all crh,

Line 7135: FROM CE_SYSTEM_PARAMETERS;

7131: OI_CLEAR_STATUS_OLD,
7132: FLOAT_HANDLING_FLAG_OLD,
7133: SHOW_VOID_PAYMENT_FLAG,
7134: OI_MATCHING_CODE_OLD
7135: FROM CE_SYSTEM_PARAMETERS;
7136:
7137: END IF;
7138: cep_standard.debug('< 7139: EXCEPTION

Line 10067: CE_SYSTEM_PARAMETERS1_PKG.select_columns(

10063:
10064: -- configuration set at system parameter's level level
10065: IF (CE_AUTO_BANK_REC.G_legal_entity_id is null) THEN
10066: IF (CE_AUTO_BANK_MATCH.ba_owner_le_id is not null) THEN
10067: CE_SYSTEM_PARAMETERS1_PKG.select_columns(
10068: CE_AUTO_BANK_REC.G_rowid,
10069: CE_AUTO_BANK_REC.G_set_of_books_id,
10070: CE_AUTO_BANK_REC.G_cashbook_begin_date,
10071: CE_AUTO_BANK_REC.G_show_cleared_flag,

Line 10093: CE_SYSTEM_PARAMETERS1_PKG.ba_select_columns(

10089:
10090: -- bug 4914608 set bank account variables
10091: -- configuration set at bank account level
10092: IF (CE_AUTO_BANK_MATCH.csh_bank_account_id is not null) THEN
10093: CE_SYSTEM_PARAMETERS1_PKG.ba_select_columns(
10094: CE_AUTO_BANK_MATCH.BA_ROWID,
10095: CE_AUTO_BANK_MATCH.ba_ap_amount_tolerance,
10096: CE_AUTO_BANK_MATCH.ba_ap_percent_tolerance,
10097: CE_AUTO_BANK_MATCH.ba_ar_amount_tolerance,