APPS.EDW_HR_RQN_VCNCY_M_SIZING SQL Statements

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

Line: 14

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

Line: 54

  x_last_update_date    NUMBER:= x_date;

Line: 71

/* Selects the length of the instance code */
  CURSOR inst_cur IS
  SELECT avg(nvl(vsize(instance_code),0))
  FROM edw_local_instance
  WHERE last_update_date BETWEEN p_from_date AND p_to_date;

Line: 78

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

Line: 86

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

Line: 91

  SELECT
   avg(nvl(vsize(vacancy_id),0))
  ,avg(nvl(vsize(status),0))
  ,avg(nvl(vsize(name),0))
  ,avg(nvl(vsize(number_of_openings),0))
  ,avg(nvl(vsize(budget_measurement_type),0))
  ,avg(nvl(vsize(budget_measurement_value),0))
  ,avg(nvl(vsize(business_group_id),0))
  ,avg(nvl(vsize(requisition_id),0))
  ,avg(nvl(vsize(vacancy_id),0))
  ,avg(nvl(vsize(hr_general.decode_lookup('BUDGET_MEASUREMENT_TYPE',budget_measurement_type)),0))
  ,avg(nvl(vsize(hr_general.decode_lookup('VACANCY_STATUS',status)),0))
  FROM per_all_vacancies
  WHERE last_update_date BETWEEN p_from_date AND p_to_date;

Line: 107

/* Selects the length of the instance code */
  OPEN inst_cur;

Line: 153

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