APPS.EDW_HR_POSITION_M_SIZING SQL Statements

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

Line: 15

  SELECT count(position_id) total
  FROM per_all_positions
  WHERE NVL(last_update_date, to_date('01-01-2000','DD-MM-YYYY'))
  BETWEEN p_from_date AND p_to_date;

Line: 61

  x_last_update_date           NUMBER:= x_date;

Line: 65

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

Line: 71

  SELECT
      avg(nvl(vsize(name),0))
     ,avg(nvl(vsize(organization_id),0))
     ,avg(nvl(vsize(job_id),0))
     ,avg(nvl(vsize(position_id),0))
     ,avg(nvl(vsize(position_definition_id),0))
     ,avg(nvl(vsize(business_group_id),0))
     ,avg(nvl(vsize(probation_period),0))
     ,avg(nvl(vsize(replacement_required_flag),0))
     ,avg(nvl(vsize(time_normal_start),0))
     ,avg(nvl(vsize(time_normal_finish),0))
     ,avg(nvl(vsize(working_hours),0))
     ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY',frequency)),0))
  FROM per_all_positions
  WHERE last_update_date BETWEEN p_from_date AND p_to_date;

Line: 88

  SELECT
      avg(nvl(vsize(name),0))
  FROM hr_all_organization_units
  WHERE last_update_date BETWEEN p_from_date AND p_to_date;

Line: 141

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