APPS.HRI_OPL_PERIOD_OF_WORK SQL Statements

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

Line: 157

  SELECT
   bkt.bucket_id          bucket_id
  ,bbc.id                 bucket_custom_id
  ,bkt.short_name         short_name
  ,bbc.range1_low         range1_low
  ,bbc.range1_high        range1_high
  ,bbc.range2_low         range2_low
  ,bbc.range2_high        range2_high
  ,bbc.range3_low         range3_low
  ,bbc.range3_high        range3_high
  ,bbc.range4_low         range4_low
  ,bbc.range4_high        range4_high
  ,bbc.range5_low         range5_low
  ,bbc.range5_high        range5_high
  ,bbc.range6_low         range6_low
  ,bbc.range6_high        range6_high
  ,bbc.range7_low         range7_low
  ,bbc.range7_high        range7_high
  ,bbc.range8_low         range8_low
  ,bbc.range8_high        range8_high
  ,bbc.range9_low         range9_low
  ,bbc.range9_high        range9_high
  ,bbc.range10_low        range10_low
  ,bbc.range10_high       range10_high
  ,bkt.uom                uom
  ,CASE
     WHEN bkt.short_name = 'HRI_DBI_LOW_BAND_CURRENT' THEN
       'EMP'
     WHEN bkt.short_name = 'HRI_DBI_POW_PLCMNT_BAND' THEN
       'CWK'
     ELSE
       NULL
   END                    wkth_wktyp_sk_fk
  FROM bis_bucket bkt,
       bis_bucket_customizations bbc
  WHERE bkt.bucket_id = bbc.bucket_id
  AND bkt.short_name IN ('HRI_DBI_LOW_BAND_CURRENT','HRI_DBI_POW_PLCMNT_BAND');

Line: 300

PROCEDURE insert_records(p_pow_band_tab_type IN g_pow_band_tab_type) IS
  --
  l_current_time           DATE   := SYSDATE;

Line: 309

    INSERT INTO HRI_CS_POW_BAND_CT
      (
       pow_band_sk_pk
      ,set_bucket_id
      ,set_bucket_custom_id
      ,set_short_name
      ,set_uom
      ,band_sequence
      ,band_range_low
      ,band_range_high
      ,wkth_wktyp_sk_fk
      ,created_by
      ,creation_date
      ,last_update_date
      ,last_updated_by
      ,last_update_login
     )
    VALUES
     (hri_cs_pow_band_ct_s.nextval
     ,p_pow_band_tab_type(i).set_bucket_id
     ,p_pow_band_tab_type(i).set_bucket_custom_id
     ,p_pow_band_tab_type(i).set_short_name
     ,p_pow_band_tab_type(i).set_uom
     ,p_pow_band_tab_type(i).band_sequence
     ,p_pow_band_tab_type(i).band_range_low
     ,p_pow_band_tab_type(i).band_range_high
     ,p_pow_band_tab_type(i).wkth_wktyp_sk_fk
     ,l_user_id
     ,l_current_time
     ,l_current_time
     ,l_user_id
     ,l_user_id
     );

Line: 345

 END insert_records;

Line: 372

   insert_records(l_pow_band_tab_type);