513: l_period_num_to gl_periods.period_num%TYPE;
514: l_date_from gl_periods.start_date%TYPE;
515: l_date_to gl_periods.end_date%TYPE;
516: l_func_currency_code fnd_currencies.currency_code%TYPE;
517: l_period_type gl_ledgers.accounted_period_type%TYPE;
518: --l_source fnd_application.application_short_name%TYPE;
519: l_source_id fnd_application.application_id%TYPE;
520:
521: -- the interim variables for activities all table
720:
721: --Get base currency code
722: SELECT currency_code, accounted_period_type
723: INTO l_func_currency_code, l_period_type
724: FROM gl_ledgers
725: WHERE ledger_id = p_ledger_id;
726:
727: -- Get l_date_from, l_date_to
728: BEGIN