APPS.CEFC_VIEW_CONST SQL Statements

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

Line: 258

    SELECT        aging_type
    INTO          p_aging_type
    FROM          ce_forecast_headers
    WHERE         forecast_header_id = pn_header_id;

Line: 268

      SELECT      start_date, period_type
      INTO        p_period_start_date, p_period_type
      FROM        gl_periods
      WHERE       period_set_name = pn_period_set_name    AND
                  period_name = pn_start_period;

Line: 274

      SELECT      count(*)
      INTO        p_max_col
      FROM        gl_periods
      WHERE       period_set_name = pn_period_set_name       	AND
		  period_type = p_period_type			AND
                  start_date >= p_period_start_date;

Line: 281

      SELECT      count(*)
      INTO        p_min_col
      FROM        gl_periods
      WHERE       period_set_name = pn_period_set_name       	AND
		  period_type = p_period_type			AND
                  start_date < p_period_start_date;