APPS.CEFC_VIEW_CONST SQL Statements

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

Line: 269

        SELECT aging_type
        INTO   p_aging_type
        FROM   ce_forecast_headers
        WHERE  forecast_header_id = pn_header_id;

Line: 280

            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: 286

            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: 294

            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;