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.BEN_CTY_SHD SQL Statements

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

Line: 47


    select
     comptncy_rt_id
    ,effective_start_date
    ,effective_end_date
    ,competence_id
    ,rating_level_id
    ,excld_flag
    ,business_group_id
    ,vrbl_rt_prfl_id
    ,object_version_number
    ,ordr_num
    ,cty_attribute_category
    ,cty_attribute1
    ,cty_attribute2
    ,cty_attribute3
    ,cty_attribute4
    ,cty_attribute5
    ,cty_attribute6
    ,cty_attribute7
    ,cty_attribute8
    ,cty_attribute9
    ,cty_attribute10
    ,cty_attribute11
    ,cty_attribute12
    ,cty_attribute13
    ,cty_attribute14
    ,cty_attribute15
    ,cty_attribute16
    ,cty_attribute17
    ,cty_attribute18
    ,cty_attribute19
    ,cty_attribute20
    ,cty_attribute21
    ,cty_attribute22
    ,cty_attribute23
    ,cty_attribute24
    ,cty_attribute25
    ,cty_attribute26
    ,cty_attribute27
    ,cty_attribute28
    ,cty_attribute29
    ,cty_attribute30
    from        ben_comptncy_rt_f
    where       comptncy_rt_id = p_comptncy_rt_id
    and         p_effective_date
    between     effective_start_date and effective_end_date;

Line: 151


  ,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: 169


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

Line: 184


  ,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: 194


    select t.vrbl_rt_prfl_id
    from   ben_comptncy_rt_f t
    where  t.comptncy_rt_id = p_base_key_value
    and    p_effective_date
    between t.effective_start_date and t.effective_end_date;

Line: 225


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

Line: 267


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

Line: 301


    select
     comptncy_rt_id
    ,effective_start_date
    ,effective_end_date
    ,competence_id
    ,rating_level_id
    ,excld_flag
    ,business_group_id
    ,vrbl_rt_prfl_id
    ,object_version_number
    ,ordr_num
    ,cty_attribute_category
    ,cty_attribute1
    ,cty_attribute2
    ,cty_attribute3
    ,cty_attribute4
    ,cty_attribute5
    ,cty_attribute6
    ,cty_attribute7
    ,cty_attribute8
    ,cty_attribute9
    ,cty_attribute10
    ,cty_attribute11
    ,cty_attribute12
    ,cty_attribute13
    ,cty_attribute14
    ,cty_attribute15
    ,cty_attribute16
    ,cty_attribute17
    ,cty_attribute18
    ,cty_attribute19
    ,cty_attribute20
    ,cty_attribute21
    ,cty_attribute22
    ,cty_attribute23
    ,cty_attribute24
    ,cty_attribute25
    ,cty_attribute26
    ,cty_attribute27
    ,cty_attribute28
    ,cty_attribute29
    ,cty_attribute30
    from    ben_comptncy_rt_f
    where   comptncy_rt_id = p_comptncy_rt_id
    and     p_effective_date
    between effective_start_date and effective_end_date
    for update nowait;

Line: 378


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