APPS.HR_EDW_WRK_RCTMNT_F_SIZING SQL Statements

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

Line: 14

  SELECT count(rec.application_id) total
  FROM hri_recruitment_stages       rec
  WHERE NVL(rec.last_update_date, to_date('01-01-2000','DD-MM-YYYY'))
  BETWEEN p_from_date AND p_to_date;

Line: 80

  x_last_update_date          NUMBER := x_date;

Line: 82

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

Line: 88

  SELECT
   avg(nvl(vsize(application_id),0))
  ,avg(nvl(vsize(assignment_id),0))
  ,avg(nvl(vsize(business_group_id  ),0))
  ,avg(nvl(vsize(person_id),0))
  FROM
   per_all_assignments_f
  WHERE last_update_date BETWEEN p_from_date AND p_to_date;

Line: 156

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