APPS.EDW_HR_SERVICE_M_SIZING SQL Statements

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

Line: 14

  SELECT count(*) total
  FROM hri_service_bands bnds
  WHERE NVL(last_update_date, to_date('01-01-2000','DD-MM-YYYY'))
  BETWEEN p_from_date AND p_to_date
  AND bnds.days_to_month IS NULL;

Line: 54

  x_last_update_date            NUMBER:=x_date;

Line: 57

/* Select the length of the instance code */
  CURSOR inst_cur IS
  SELECT avg(nvl( vsize(instance_code),0 ))
  FROM edw_local_instance;

Line: 63

  SELECT
   avg(nvl(vsize(bnds.band_max_total_years),0))
  ,avg(nvl(vsize(bnds.band_max_total_months),0))
  ,avg(nvl(vsize(bnds.band_max_total_weeks),0))
  ,avg(nvl(vsize(bnds.band_max_total_days),0))
  ,avg(nvl(vsize(bnds.band_min_total_years),0))
  ,avg(nvl(vsize(bnds.band_min_total_months),0))
  ,avg(nvl(vsize(bnds.band_min_total_weeks),0))
  ,avg(nvl(vsize(bnds.band_min_total_days),0))
  FROM
  hri_service_bands bnds
  WHERE bnds.last_update_date BETWEEN p_from_date AND p_to_date;

Line: 118

+ NVL(ceil(x_last_update_date + 1), 0)
+ NVL(ceil(x_creation_date + 1), 0);