APPS.EDW_HR_GRADE_M_SIZING SQL Statements

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

Line: 14

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

Line: 52

  x_last_update_date	NUMBER := x_date;

Line: 57

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

Line: 63

  SELECT
   avg(nvl(vsize(sequence),0))
  ,avg(nvl(vsize(name),0))
  ,avg(nvl(vsize(grade_id),0))
  ,avg(nvl(vsize(business_group_id),0))
  FROM per_grades
  WHERE last_update_date BETWEEN p_from_date AND p_to_date;

Line: 72

  SELECT
  avg(nvl(vsize(name),0))
  FROM hr_all_organization_units
  WHERE last_update_date BETWEEN p_from_date AND p_to_date;

Line: 78

  SELECT
  avg(nvl(vsize(grade_definition_id),0))
  FROM per_grade_definitions
  WHERE last_update_date BETWEEN p_from_date AND p_to_date;

Line: 118

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