eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDW_HR_MVMNT_TYP_M_SIZING SQL Statements

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

Line: 14


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

Line: 65


  x_last_update_date     NUMBER :=x_date;

Line: 176


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

Line: 183


  SELECT
   avg(nvl(vsize(cmbn.description),0))
  ,avg(nvl(vsize(cmbn.combination_id),0))
  FROM
   hri_edw_event_hrchy_cmbns  cmbn
  WHERE cmbn.last_update_date BETWEEN p_from_date AND p_to_date;

Line: 193


  SELECT
   avg(nvl(vsize(gns.event_code),0))
  ,avg(nvl(vsize(hr_general.decode_lookup('HRI_GAIN_TYPES',gns.event_code)),0))
  ,avg(nvl(vsize(gns.event_id),0))
  FROM
   hri_edw_event_hrchys    gns
  WHERE gns.level_number = 1
  AND gns.hierarchy = 'Gain'
  AND gns.last_update_date BETWEEN p_from_date AND p_to_date;

Line: 204


  SELECT
   avg(nvl(vsize(gns.event_code),0))
  ,avg(nvl(vsize(hr_general.decode_lookup('HRI_GAIN_TYPES',gns.event_code)),0))
  ,avg(nvl(vsize(gns.event_id),0))
  FROM
   hri_edw_event_hrchys    gns
  WHERE gns.level_number = 2
  AND gns.hierarchy = 'Gain'
  AND gns.last_update_date BETWEEN p_from_date AND p_to_date;

Line: 215


  SELECT
   avg(nvl(vsize(gns.event_code),0))
  ,avg(nvl(vsize(hr_general.decode_lookup('HRI_GAIN_TYPES',gns.event_code)),0))
  ,avg(nvl(vsize(gns.event_id),0))
  FROM
   hri_edw_event_hrchys    gns
  WHERE gns.level_number = 3
  AND gns.hierarchy = 'Gain'
  AND gns.last_update_date BETWEEN p_from_date AND p_to_date;

Line: 228


  SELECT
   avg(nvl(vsize(lss.event_code),0))
  ,avg(nvl(vsize(hr_general.decode_lookup('HRI_LOSS_TYPES',lss.event_code)),0))
  ,avg(nvl(vsize(lss.event_id),0))
  FROM
   hri_edw_event_hrchys    lss
  WHERE lss.level_number = 1
  AND lss.hierarchy = 'Loss'
  AND lss.last_update_date BETWEEN p_from_date AND p_to_date;

Line: 239


  SELECT
   avg(nvl(vsize(lss.event_code),0))
  ,avg(nvl(vsize(hr_general.decode_lookup('HRI_LOSS_TYPES',lss.event_code)),0))
  ,avg(nvl(vsize(lss.event_id),0))
  FROM
   hri_edw_event_hrchys    lss
  WHERE lss.level_number = 2
  AND lss.hierarchy = 'Loss'
  AND lss.last_update_date BETWEEN p_from_date AND p_to_date;

Line: 250


  SELECT
   avg(nvl(vsize(lss.event_code),0))
  ,avg(nvl(vsize(hr_general.decode_lookup('HRI_LOSS_TYPES',lss.event_code)),0))
  ,avg(nvl(vsize(lss.event_id),0))
  FROM
   hri_edw_event_hrchys    lss
  WHERE lss.level_number = 3
  AND lss.hierarchy = 'Loss'
  AND lss.last_update_date BETWEEN p_from_date AND p_to_date;

Line: 263


  SELECT
   avg(nvl(vsize(rec.event_code),0))
  ,avg(nvl(vsize(hr_general.decode_lookup('HRI_RECRUITMENT_STAGES',rec.event_code)),0))
  ,avg(nvl(vsize(rec.event_id),0))
  FROM
    hri_edw_event_hrchys      rec
  WHERE rec.level_number = 1
  AND rec.hierarchy = 'Recruitment'
  AND rec.last_update_date BETWEEN p_from_date AND p_to_date;

Line: 274


  SELECT
   avg(nvl(vsize(rec.event_code),0))
  ,avg(nvl(vsize(hr_general.decode_lookup('HRI_RECRUITMENT_STAGES',rec.event_code)),0))
  ,avg(nvl(vsize(rec.event_id),0))
  FROM
    hri_edw_event_hrchys      rec
  WHERE rec.level_number = 2
  AND rec.hierarchy = 'Recruitment'
  AND rec.last_update_date BETWEEN p_from_date AND p_to_date;

Line: 285


  SELECT
   avg(nvl(vsize(rec.event_code),0))
  ,avg(nvl(vsize(hr_general.decode_lookup('HRI_RECRUITMENT_STAGES',rec.event_code)),0))
  ,avg(nvl(vsize(rec.event_id),0))
  FROM
    hri_edw_event_hrchys      rec
  WHERE rec.level_number = 3
  AND rec.hierarchy = 'Recruitment'
  AND rec.last_update_date BETWEEN p_from_date AND p_to_date;

Line: 298


  SELECT
   avg(nvl(vsize(spn.event_code),0))
  ,avg(nvl(vsize(hr_general.decode_lookup('HRI_SEPARATION_STAGES',spn.event_code)),0))
  ,avg(nvl(vsize(spn.event_id),0))
  FROM
   hri_edw_event_hrchys     spn
  WHERE spn.level_number = 1
  AND spn.hierarchy = 'Separations'
  AND spn.last_update_date BETWEEN p_from_date AND p_to_date;

Line: 309


  SELECT
   avg(nvl(vsize(spn.event_code),0))
  ,avg(nvl(vsize(hr_general.decode_lookup('HRI_SEPARATION_STAGES',spn.event_code)),0))
  ,avg(nvl(vsize(spn.event_id),0))
  FROM
   hri_edw_event_hrchys     spn
  WHERE spn.level_number = 2
  AND spn.hierarchy = 'Separations'
  AND spn.last_update_date BETWEEN p_from_date AND p_to_date;

Line: 320


  SELECT
   avg(nvl(vsize(spn.event_code),0))
  ,avg(nvl(vsize(hr_general.decode_lookup('HRI_SEPARATION_STAGES',spn.event_code)),0))
  ,avg(nvl(vsize(spn.event_id),0))
  FROM
   hri_edw_event_hrchys     spn
  WHERE spn.level_number = 3
  AND spn.hierarchy = 'Separations'
  AND spn.last_update_date BETWEEN p_from_date AND p_to_date;

Line: 356


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

Line: 376


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

Line: 396


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

Line: 417


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

Line: 437


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

Line: 457


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

Line: 478


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

Line: 498


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

Line: 518


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

Line: 539


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

Line: 559


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

Line: 579


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

Line: 607


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