APPS.EDW_HR_REC_ACT_M_SIZING SQL Statements

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

Line: 14

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

Line: 66

  x_last_update_date        NUMBER :=x_date;

Line: 70

/* 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: 77

  SELECT
   avg(nvl(vsize(name),0))
  ,avg(nvl(vsize(external_contact),0))
  ,avg(nvl(vsize(business_group_id),0))
  ,avg(nvl(vsize(recruitment_activity_id),0))
  ,avg(nvl(vsize(actual_cost),0))
  ,avg(nvl(vsize(planned_cost),0))
  FROM per_recruitment_activities
  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: 93

  SELECT avg(nvl(vsize(lookup_code),0))
  ,avg(nvl(vsize(meaning),0))
  FROM hr_lookups
  WHERE last_update_date BETWEEN p_from_date AND p_to_date
  AND lookup_type = 'REC_TYPE';

Line: 101

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

Line: 135

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

Line: 158

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