APPS.EDW_HR_SERVICE_PKG SQL Statements

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

Line: 11

  SELECT days_to_month
  FROM hri_service_bands
  WHERE days_to_month IS NOT NULL;

Line: 17

  SELECT service_band_pk
  FROM edw_hr_service_fkv
  WHERE (((service_length_min_year * 12) + service_length_min_month) * v_days_to_month)
        + ((service_length_min_week * 7)  + service_length_min_day)
                             <= p_service_days
  AND ((service_length_max_year  IS NULL AND
        service_length_max_month IS NULL AND
        service_length_max_week  IS NULL AND
        service_length_max_day   IS NULL)
    OR ((((service_length_max_year * 12) + service_length_max_month) * v_days_to_month)
       + ((service_length_max_week * 7)  + service_length_max_day)
                             > p_service_days));