APPS.EDW_HR_ASG_CHNG_M_SIZING SQL Statements

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

Line: 14

  SELECT count(*) total
FROM
  (SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup
         ,lookup_code
         ,last_update_date
         ,creation_date
   FROM   hr_lookups
   WHERE lookup_type = 'YES_NO') t1
 ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup
         ,lookup_code
   FROM   hr_lookups
   WHERE lookup_type = 'YES_NO') t2
 ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup
         ,lookup_code
   FROM   hr_lookups
   WHERE lookup_type = 'YES_NO') t3
 ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup
         ,lookup_code
   FROM   hr_lookups
   WHERE lookup_type = 'YES_NO') t4
 ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup
         ,lookup_code
   FROM   hr_lookups
   WHERE lookup_type = 'YES_NO') t5
 ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup
         ,lookup_code
   FROM   hr_lookups
   WHERE lookup_type = 'YES_NO') t6
 ,(SELECT hr_general.decode_lookup('YES_NO', lookup_code) lookup
         ,lookup_code
   FROM   hr_lookups
   WHERE lookup_type = 'YES_NO') t7;

Line: 78

  x_last_update_date    NUMBER := x_date;

Line: 80

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

Line: 87

  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: 115

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