APPS.HR_EDW_WRK_SPRTN_F_SIZING SQL Statements

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

Line: 14

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

Line: 75

  x_last_update_date              NUMBER :=x_date;

Line: 83

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

Line: 89

  SELECT
   avg(nvl(vsize(pps.period_of_service_id),0 ))
  ,avg(nvl(vsize(pps.termination_accepted_person_id),0 ))
  ,avg(nvl(vsize(pps.leaving_reason),0 ))
  FROM per_periods_of_service     pps
  WHERE pps.last_update_date BETWEEN p_from_date AND p_to_date;

Line: 97

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

Line: 187

                + NVL(ceil(  x_last_update_date  + 1), 0)
                + NVL(ceil(  x_creation_date  + 1), 0)
                + NVL(ceil(  x_ntfd_trmntn_dt + 1), 0)
                + NVL(ceil(  x_accptd_trmntn_dt + 1), 0)
                + NVL(ceil(  x_prjctd_trmntn_dt + 1), 0)
                + NVL(ceil(  x_actual_trmntn_dt + 1), 0)
                + NVL(ceil(  x_final_process_dt + 1), 0)
                + NVL(ceil(  x_leaving_reason + 1), 0);