APPS.EDW_HR_PRSN_TYP_M_SIZING SQL Statements

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

Line: 14

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

Line: 64

x_last_update_date           NUMBER:=x_date;

Line: 72

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

Line: 80

  SELECT
   avg(nvl(vsize(person_type_pk),0))
  ,avg(nvl(vsize(employee),0))
  ,avg(nvl(vsize(permanent),0))
  ,avg(nvl(vsize(intern),0))
  ,avg(nvl(vsize(fixed_term_lower),0))
  ,avg(nvl(vsize(fixed_term_upper),0))
  ,avg(nvl(vsize(agency),0))
  ,avg(nvl(vsize(self_employed),0))
  ,avg(nvl(vsize(consultant),0))
  ,avg(nvl(vsize(ex_employee),0))
  ,avg(nvl(vsize(applicant),0))
  ,avg(nvl(vsize(dependent),0))
  ,avg(nvl(vsize(retiree),0))
  ,avg(nvl(vsize(beneficiary),0))
  ,avg(nvl(vsize(surviving_family_member),0))
  ,avg(nvl(vsize(surviving_spouse),0))
  ,avg(nvl(vsize(ex_applicant),0))
  ,avg(nvl(vsize(other),0))
  ,avg(nvl(vsize(participant),0))
  ,avg(nvl(vsize(former_spouse),0))
  ,avg(nvl(vsize(former_family_member),0))
  FROM hri_person_type_cmbns
  WHERE last_update_date BETWEEN p_from_date AND p_to_date;

Line: 106

SELECT
  avg(nvl(vsize(hr_general.decode_lookup('YES_NO','Y')),0))
 ,avg(nvl(vsize(hr_general.decode_lookup('YES_NO','N')),0))
FROM dual;

Line: 178

  + NVL(ceil(x_last_update_date + 1), 0)
  + NVL(ceil(x_creation_date + 1), 0)
  + (26 * NVL(ceil(x_avg_flag + 1), 0));