APPS.GL_GLYRLJGE_XMLP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

    SELECT name, chart_of_accounts_id
    INTO   C_ACCESS_SET_NAME, C_CHART_OF_ACCTS_ID
    FROM   gl_access_sets
    WHERE  access_set_id = P_ACCESS_SET_ID;

Line: 55

      SELECT name, currency_code, object_type_code, consolidation_ledger_flag,
             period_set_name, accounted_period_type
      INTO   PARAM_LEDGER_NAME, PARAM_LEDGER_CURR,
             PARAM_LEDGER_TYPE, CONSOLIDATION_LEDGER_FLAG,
             per_set, per_type
      FROM   gl_ledgers
      WHERE  ledger_id = P_LEDGER_ID;

Line: 77

      SELECT PERIOD_SET_NAME, ACCOUNTED_PERIOD_TYPE
      INTO per_set, per_type
      FROM GL_ACCESS_SETS
      WHERE ACCESS_SET_ID = P_ACCESS_SET_ID;

Line: 97

      SELECT consolidation_ledger_flag
      INTO CONSOLIDATION_LEDGER_FLAG
      FROM gl_system_usages;

Line: 109

      SELECT substr(ltrim(to_char(11, '9G9')), 2, 1)
      INTO   THOUSANDS_SEPARATOR
      FROM   dual;

Line: 128

        select t.period_year
        into   fiscal_year_s
        from   gl_periods t
        where  t.period_set_name = per_set
        and    t.period_type = per_type
        and    C_START_DATE between t.start_date and t.end_date
        and    t.adjustment_period_flag like
			decode(P_ADJUSTMENT_PERIODS,'N','N',
							 '%')
        and    rownum = 1;

Line: 138

        select t.period_year
        into   fiscal_year_e
        from   gl_periods t
        where  t.period_set_name = per_set
        and    t.period_type = per_type
        and    C_END_DATE between t.start_date and t.end_date
        and    t.adjustment_period_flag like
			decode(P_ADJUSTMENT_PERIODS,'N','N',
							 '%')
        and    rownum = 1;

Line: 201

  select name
  from fnd_currencies_vl
  where currency_code = currency1;