APPS.CE_JE_CREATION dependencies on CE_SYSTEM_PARAMETERS

Line 160: ce_system_parameters sys

156: log('>>valid_accounting_date');
157: SELECT count(*)
158: INTO l_count
159: FROM gl_period_statuses glp,
160: ce_system_parameters sys
161: WHERE glp.set_of_books_id = sys.set_of_books_id
162: AND sys.legal_entity_id = CE_JE_CREATION.ba_legal_entity_id
163: AND glp.closing_status in ('O','F')
164: AND glp.application_id = 101

Line 368: l_xchange_rate_date VARCHAR2(10); --CE_SYSTEM_PARAMETERS.exchange_rate_date%TYPE;

364: | HISTORY |
365: | 28-JUL-2004 xxwang Created |
366: --------------------------------------------------------------------- */
367: PROCEDURE Determine_exchange_info (p_result IN OUT NOCOPY VARCHAR2) IS
368: l_xchange_rate_date VARCHAR2(10); --CE_SYSTEM_PARAMETERS.exchange_rate_date%TYPE;
369: l_xchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
370: l_xchange_rate GL_DAILY_RATES.conversion_rate%TYPE;
371: precision NUMBER;
372: ext_precision NUMBER;

Line 849: ce_system_parameters sys, -- change to base table per BH's request

845: CE_JE_CREATION.sys_exchange_rate_date,
846: CE_JE_CREATION.sys_exchange_rate_type,
847: CE_JE_CREATION.sys_sob_id
848: FROM
849: ce_system_parameters sys, -- change to base table per BH's request
850: gl_sets_of_books sob,
851: ce_bank_accounts ba
852: --xle_fp_ou_ledger_v xle
853: WHERE