[Home] [Help]
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
234: ELSE
235: SELECT MIN(glp.start_date)
236: INTO CE_JE_CREATION.cf_cleared_date
237: FROM gl_period_statuses glp,
238: ce_system_parameters SYS
239: WHERE glp.set_of_books_id = sys.set_of_books_id
240: AND sys.legal_entity_id = CE_JE_CREATION.ba_legal_entity_id /*13114107 fixed*/
241: AND glp.closing_status IN ('O','F')
242: AND glp.application_id = 101
411: | HISTORY |
412: | 28-JUL-2004 xxwang Created |
413: --------------------------------------------------------------------- */
414: PROCEDURE Determine_exchange_info (p_result IN OUT NOCOPY VARCHAR2) IS
415: l_xchange_rate_date VARCHAR2(10); --CE_SYSTEM_PARAMETERS.exchange_rate_date%TYPE;
416: l_xchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
417: l_xchange_rate GL_DAILY_RATES.conversion_rate%TYPE;
418: precision NUMBER;
419: ext_precision NUMBER;
892: CE_JE_CREATION.sys_exchange_rate_date,
893: CE_JE_CREATION.sys_exchange_rate_type,
894: CE_JE_CREATION.sys_sob_id
895: FROM
896: ce_system_parameters sys, -- change to base table per BH's request
897: gl_sets_of_books sob,
898: ce_bank_accounts ba
899: --xle_fp_ou_ledger_v xle
900: WHERE