APPS.HR_EDW_WRK_CMPSTN_F_SIZING SQL Statements

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

Line: 14

  SELECT count(*) total
  FROM hri_edw_cmpstn_snpsht_dts;

Line: 65

  x_last_update_date        NUMBER:=x_date;

Line: 68

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

Line: 74

  SELECT
   avg(nvl(vsize(asg.assignment_id ),0))
  ,avg(nvl(vsize(asg.business_group_id ),0))
  ,avg(nvl(vsize(asg.grade_id),0))
  ,avg(nvl(vsize(asg.job_id),0))
  ,avg(nvl(vsize(asg.location_id ),0))
  ,avg(nvl(vsize(asg.organization_id),0))
  ,avg(nvl(vsize(asg.person_id ),0))
  ,avg(nvl(vsize(asg.position_id ),0))
  FROM  per_all_assignments_f      asg
  WHERE last_update_date BETWEEN p_from_date AND p_to_date;

Line: 144

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