APPS.HR_CLE_SHD SQL Statements

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

Line: 47

    select
     soc_ins_contr_lvls_id
    ,organization_id
    ,normal_percentage
    ,normal_amount
    ,increased_percentage
    ,increased_amount
    ,reduced_percentage
    ,reduced_amount
    ,effective_start_date
    ,effective_end_date
    ,attribute_category
    ,attribute1
    ,attribute2
    ,attribute3
    ,attribute4
    ,attribute5
    ,attribute6
    ,attribute7
    ,attribute8
    ,attribute9
    ,attribute10
    ,attribute11
    ,attribute12
    ,attribute13
    ,attribute14
    ,attribute15
    ,attribute16
    ,attribute17
    ,attribute18
    ,attribute19
    ,attribute20
    ,object_version_number
    ,attribute21
    ,attribute22
    ,attribute23
    ,attribute24
    ,attribute25
    ,attribute26
    ,attribute27
    ,attribute28
    ,attribute29
    ,attribute30
    ,flat_tax_limit_per_month
    ,flat_tax_limit_per_year
    ,min_increased_contribution
    ,max_increased_contribution
    ,month1
    ,month1_min_contribution
    ,month1_max_contribution
    ,month2
    ,month2_min_contribution
    ,month2_max_contribution
    ,employee_contribution
    ,contribution_level_type
    from        hr_de_soc_ins_contr_lvls_f
    where       soc_ins_contr_lvls_id = p_soc_ins_contr_lvls_id
    and         p_effective_date
    between     effective_start_date and effective_end_date;

Line: 164

  ,p_update                 out nocopy boolean
  ,p_update_override        out nocopy boolean
  ,p_update_change_insert   out nocopy boolean
  ) is
--
  l_proc        varchar2(72) := g_package||'find_dt_upd_modes';

Line: 182

    ,p_update                => p_update
    ,p_update_override       => p_update_override
    ,p_update_change_insert  => p_update_change_insert
    );

Line: 197

  ,p_delete                out nocopy boolean
  ,p_future_change         out nocopy boolean
  ,p_delete_next_change    out nocopy boolean
  ) is
  --
  l_proc                varchar2(72)    := g_package||'find_dt_del_modes';

Line: 216

   ,p_delete                        => p_delete
   ,p_future_change                 => p_future_change
   ,p_delete_next_change            => p_delete_next_change
   );

Line: 258

  update  hr_de_soc_ins_contr_lvls_f t
  set     t.effective_end_date    = p_new_effective_end_date
    ,     t.object_version_number = l_object_version_number
  where   t.soc_ins_contr_lvls_id        = p_base_key_value
  and     p_effective_date
  between t.effective_start_date and t.effective_end_date;

Line: 292

    select
     soc_ins_contr_lvls_id
    ,organization_id
    ,normal_percentage
    ,normal_amount
    ,increased_percentage
    ,increased_amount
    ,reduced_percentage
    ,reduced_amount
    ,effective_start_date
    ,effective_end_date
    ,attribute_category
    ,attribute1
    ,attribute2
    ,attribute3
    ,attribute4
    ,attribute5
    ,attribute6
    ,attribute7
    ,attribute8
    ,attribute9
    ,attribute10
    ,attribute11
    ,attribute12
    ,attribute13
    ,attribute14
    ,attribute15
    ,attribute16
    ,attribute17
    ,attribute18
    ,attribute19
    ,attribute20
    ,object_version_number
    ,attribute21
    ,attribute22
    ,attribute23
    ,attribute24
    ,attribute25
    ,attribute26
    ,attribute27
    ,attribute28
    ,attribute29
    ,attribute30
    ,flat_tax_limit_per_month
    ,flat_tax_limit_per_year
    ,min_increased_contribution
    ,max_increased_contribution
    ,month1
    ,month1_min_contribution
    ,month1_max_contribution
    ,month2
    ,month2_min_contribution
    ,month2_max_contribution
    ,employee_contribution
    ,contribution_level_type
    from    hr_de_soc_ins_contr_lvls_f
    where   soc_ins_contr_lvls_id = p_soc_ins_contr_lvls_id
    and     p_effective_date
    between effective_start_date and effective_end_date
    for update nowait;

Line: 387

  If (p_datetrack_mode <> hr_api.g_insert) then
    --
    -- We must select and lock the current row.
    --
    Open  C_Sel1;