APPS.HRI_OPL_REC_BANDS dependencies on HRI_TIME_BANDS

Line 24: FROM hri_time_bands

20: ,to_char(DECODE(band_min_value, 0, 0, band_min_value + 1)) ||
21: DECODE(band_max_value, to_number(null), ' +', ' - ' || to_char(band_max_value))
22: band_name
23: ,band_sequence seq_no
24: FROM hri_time_bands
25: WHERE type = 'APL_STAGE';
26:
27: /* Bug 2669294 - Incremented band min value for the displayed name if it */
28: /* is non-zero */

Line 37: FROM hri_time_bands

33: ,to_char(DECODE(band_min_value, 0, 0, band_min_value + 1)) ||
34: DECODE(band_max_value, to_number(null), ' +', ' - ' || to_char(band_max_value))
35: band_name
36: ,band_sequence seq_no
37: FROM hri_time_bands
38: WHERE type = 'VACANCY';
39:
40: /******************************************************************************/
41: /* Returns an indicator for whether the supplied value is within the */