APPS.HRI_OLTP_PMV_UTIL_PARAM SQL Statements

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

Line: 239

    /* If All (no parameter value selected) is passed then default to Yes (rollup) */
      IF (p_parameter_rec.peo_sup_rollup_flag IS NULL OR
          p_parameter_rec.peo_sup_rollup_flag = '-1') THEN
        p_parameter_rec.peo_sup_rollup_flag := 'Y';

Line: 301

/* Multi-select dimension levels */
/*********************************/

    ELSIF (substr(p_page_parameter_tbl(i).parameter_name, 1, 10) = 'GEOGRAPHY+'
        OR substr(p_page_parameter_tbl(i).parameter_name, 1,  4) = 'JOB+'
        OR p_page_parameter_tbl(i).parameter_name = 'HRI_LOW+HRI_LOW_BAND_X'
        OR p_page_parameter_tbl(i).parameter_name = 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X'
        OR p_page_parameter_tbl(i).parameter_name = 'HRI_REASON+HRI_RSN_SEP_X') THEN
      IF is_parameter_set(p_page_parameter_tbl(i).parameter_id) THEN
        l_add_to_bind_table := TRUE;