APPS.GL_GLXCLVAL_XMLP_PKG SQL Statements

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

Line: 7

  SELECT period_year, min(period_num)
  INTO   dummy, first_period_num
  FROM   gl_periods
  WHERE
         period_set_name = periodset
  AND    period_type = periodtype
  AND    period_year = first_period_year
  GROUP BY period_year;

Line: 25

  SELECT number_per_fiscal_year, user_period_type
  --INTO   max_period, user_period_type
  INTO   max_period, user_period_type1
  FROM   gl_period_types
  WHERE
         period_type = periodtype1;

Line: 38

  SELECT max(period_year)
  INTO   max_year
  FROM   gl_periods
  WHERE
         period_set_name = periodset
  AND    period_type = periodtype;

Line: 52

        SELECT
          max(end_date)
        INTO date_low
        FROM gl_periods
        WHERE  period_set_name = periodset
        AND    period_type     = periodtype
        AND    period_year < P_start_year
        ;

Line: 61

           SELECT min(start_date)
           INTO date_low
           FROM  gl_periods
           WHERE  period_set_name = periodset
           AND    period_type     = periodtype
           AND    period_year = P_start_year;

Line: 80

        SELECT
             min(start_date)
        INTO date_high
        FROM gl_periods
        WHERE  period_set_name = periodset
        AND    period_type     = periodtype
        AND    period_year > P_end_year
        ;

Line: 89

           SELECT max(end_date)
           INTO date_high
           FROM  gl_periods
           WHERE  period_set_name = periodset
           AND    period_type     = periodtype
           AND    period_year = P_end_year;

Line: 105

  SELECT min(period_year)
  INTO   first_period_year
  FROM   gl_periods
  WHERE
         period_set_name = periodset
  AND    period_type = periodtype
  AND    start_date = to_date(first_period_date,'YYYY/MM/DD');

Line: 117

  SELECT min(decode(p.period_year,
                    first_period_year, p.quarter_num, 1))
  INTO   min_quarter
  FROM   gl_periods p
  WHERE  p.period_set_name = periodset
  AND    p.period_type     = periodtype
  AND    p.period_year     = period_year_qg;

Line: 129

  SELECT max(p.quarter_num)
  INTO   max_quarter
  FROM   gl_periods p
  WHERE  p.period_set_name = periodset
  AND    p.period_type     = periodtype
  AND    p.period_year     = period_year_qg;