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_JRT_SHD SQL Statements

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

Line: 47


    select
     job_rt_id
    ,effective_start_date
    ,effective_end_date
    ,job_id
    ,excld_flag
    ,business_group_id
    ,vrbl_rt_prfl_id
    ,object_version_number
    ,ordr_num
    ,jrt_attribute_category
    ,jrt_attribute1
    ,jrt_attribute2
    ,jrt_attribute3
    ,jrt_attribute4
    ,jrt_attribute5
    ,jrt_attribute6
    ,jrt_attribute7
    ,jrt_attribute8
    ,jrt_attribute9
    ,jrt_attribute10
    ,jrt_attribute11
    ,jrt_attribute12
    ,jrt_attribute13
    ,jrt_attribute14
    ,jrt_attribute15
    ,jrt_attribute16
    ,jrt_attribute17
    ,jrt_attribute18
    ,jrt_attribute19
    ,jrt_attribute20
    ,jrt_attribute21
    ,jrt_attribute22
    ,jrt_attribute23
    ,jrt_attribute24
    ,jrt_attribute25
    ,jrt_attribute26
    ,jrt_attribute27
    ,jrt_attribute28
    ,jrt_attribute29
    ,jrt_attribute30
    from        ben_job_rt_f
    where       job_rt_id = p_job_rt_id
    and         p_effective_date
    between     effective_start_date and effective_end_date;

Line: 150


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


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

Line: 183


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


    select
     t.vrbl_rt_prfl_id
    from   ben_job_rt_f t
    where  t.job_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_job_rt_f t
  set     t.effective_end_date    = p_new_effective_end_date
    ,     t.object_version_number = l_object_version_number
  where   t.job_rt_id        = p_base_key_value
  and     p_effective_date
  between t.effective_start_date and t.effective_end_date;

Line: 301


    select
     job_rt_id
    ,effective_start_date
    ,effective_end_date
    ,job_id
    ,excld_flag
    ,business_group_id
    ,vrbl_rt_prfl_id
    ,object_version_number
    ,ordr_num
    ,jrt_attribute_category
    ,jrt_attribute1
    ,jrt_attribute2
    ,jrt_attribute3
    ,jrt_attribute4
    ,jrt_attribute5
    ,jrt_attribute6
    ,jrt_attribute7
    ,jrt_attribute8
    ,jrt_attribute9
    ,jrt_attribute10
    ,jrt_attribute11
    ,jrt_attribute12
    ,jrt_attribute13
    ,jrt_attribute14
    ,jrt_attribute15
    ,jrt_attribute16
    ,jrt_attribute17
    ,jrt_attribute18
    ,jrt_attribute19
    ,jrt_attribute20
    ,jrt_attribute21
    ,jrt_attribute22
    ,jrt_attribute23
    ,jrt_attribute24
    ,jrt_attribute25
    ,jrt_attribute26
    ,jrt_attribute27
    ,jrt_attribute28
    ,jrt_attribute29
    ,jrt_attribute30
    from    ben_job_rt_f
    where   job_rt_id = p_job_rt_id
    and     p_effective_date
    between effective_start_date and effective_end_date
    for update nowait;

Line: 377


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