APPS.AMS_DCF_DEFAULT_VALUES SQL Statements

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

Line: 87

        SELECT year
	INTO   x_return_value
	FROM   BIM_R_CAMP_DIM_SUM_MV
 	WHERE  rownum < 2;

Line: 107

        SELECT qtr
	INTO   x_return_value
	FROM   BIM_R_CAMP_DIM_SUM_MV
 	WHERE  rownum < 2;

Line: 126

        SELECT year
	INTO   x_return_value
	FROM   BIM_R_EVEN_DIM_SUM_MV
 	WHERE  rownum < 2;

Line: 147

        SELECT qtr
	INTO   x_return_value
	FROM   BIM_R_EVEN_DIM_SUM_MV
 	WHERE  rownum < 2;

Line: 211

      select period_name into x_return_year from gl_periods_v g
       where trunc(SYSDATE) BETWEEN g.start_date AND g.end_date
         AND g.period_set_name = def_period
         AND g.period_type = def_year;

Line: 216

      select period_name into x_return_qtr from gl_periods_v g
       where trunc(SYSDATE) BETWEEN g.start_date AND g.end_date
         AND g.period_set_name = def_period
         AND g.period_type = def_quarter;

Line: 237

      select period_name into x_return_year from gl_periods_v g
       where trunc(SYSDATE) BETWEEN g.start_date AND g.end_date
         AND g.period_set_name = def_period
         AND g.period_type = def_year;

Line: 242

      select period_name into x_return_qtr from gl_periods_v g
       where trunc(SYSDATE) BETWEEN g.start_date AND g.end_date
         AND g.period_set_name = def_period
         AND g.period_type = def_quarter;

Line: 264

select period_name into x_return_value from gl_periods_v g
where trunc(SYSDATE) BETWEEN g.start_date AND g.end_date
   AND g.period_set_name = def_period
   AND g.period_type = def_quarter;

Line: 284

select period_name into x_return_value from gl_periods_v g
where trunc(SYSDATE) BETWEEN g.start_date AND g.end_date
   AND g.period_set_name = def_period
   AND g.period_type = def_year;

Line: 304

select period_name into x_return_value from gl_periods_v g
where trunc(SYSDATE) BETWEEN g.start_date AND g.end_date
   AND g.period_set_name = def_period
   AND g.period_type = def_quarter;