APPS.HRI_OPL_REC_BANDS SQL Statements

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

Line: 17

SELECT
 band_min_value  min_val
,band_max_value  max_val
,to_char(DECODE(band_min_value, 0, 0, band_min_value + 1)) ||
 DECODE(band_max_value, to_number(null), ' +', ' - ' || to_char(band_max_value))
                 band_name
,band_sequence   seq_no
FROM hri_time_bands
WHERE type = 'APL_STAGE';

Line: 30

SELECT
 band_min_value  min_val
,band_max_value  max_val
,to_char(DECODE(band_min_value, 0, 0, band_min_value + 1)) ||
 DECODE(band_max_value, to_number(null), ' +', ' - ' || to_char(band_max_value))
                 band_name
,band_sequence   seq_no
FROM hri_time_bands
WHERE type = 'VACANCY';