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

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

Line: 58


    select
     vrbl_rt_elig_prfl_id
    ,effective_start_date
    ,effective_end_date
    ,business_group_id
    ,vrbl_rt_prfl_id
    ,eligy_prfl_id
    ,mndtry_flag
    ,vep_attribute_category
    ,vep_attribute1
    ,vep_attribute2
    ,vep_attribute3
    ,vep_attribute4
    ,vep_attribute5
    ,vep_attribute6
    ,vep_attribute7
    ,vep_attribute8
    ,vep_attribute9
    ,vep_attribute10
    ,vep_attribute11
    ,vep_attribute12
    ,vep_attribute13
    ,vep_attribute14
    ,vep_attribute15
    ,vep_attribute16
    ,vep_attribute17
    ,vep_attribute18
    ,vep_attribute19
    ,vep_attribute20
    ,vep_attribute21
    ,vep_attribute22
    ,vep_attribute23
    ,vep_attribute24
    ,vep_attribute25
    ,vep_attribute26
    ,vep_attribute27
    ,vep_attribute28
    ,vep_attribute29
    ,vep_attribute30
    ,object_version_number
    from	BEN_VRBL_RT_ELIG_PRFL_f
    where	vrbl_rt_elig_prfl_id = p_vrbl_rt_elig_prfl_id
    and		p_effective_date
    between	effective_start_date and effective_end_date;

Line: 159


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


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

Line: 192


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


    select
    t.vrbl_rt_prfl_id
    ,t.eligy_prfl_id
    from   BEN_VRBL_RT_ELIG_PRFL_f t
    where  t.vrbl_rt_elig_prfl_id = p_base_key_value
    and    p_effective_date
    between t.effective_start_date and t.effective_end_date;

Line: 241


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

Line: 283


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

Line: 322


    select
     vrbl_rt_elig_prfl_id
    ,effective_start_date
    ,effective_end_date
    ,business_group_id
    ,vrbl_rt_prfl_id
    ,eligy_prfl_id
    ,mndtry_flag
    ,vep_attribute_category
    ,vep_attribute1
    ,vep_attribute2
    ,vep_attribute3
    ,vep_attribute4
    ,vep_attribute5
    ,vep_attribute6
    ,vep_attribute7
    ,vep_attribute8
    ,vep_attribute9
    ,vep_attribute10
    ,vep_attribute11
    ,vep_attribute12
    ,vep_attribute13
    ,vep_attribute14
    ,vep_attribute15
    ,vep_attribute16
    ,vep_attribute17
    ,vep_attribute18
    ,vep_attribute19
    ,vep_attribute20
    ,vep_attribute21
    ,vep_attribute22
    ,vep_attribute23
    ,vep_attribute24
    ,vep_attribute25
    ,vep_attribute26
    ,vep_attribute27
    ,vep_attribute28
    ,vep_attribute29
    ,vep_attribute30
    ,object_version_number
    from    BEN_VRBL_RT_ELIG_PRFL_f
    where   vrbl_rt_elig_prfl_id = p_vrbl_rt_elig_prfl_id
    and	    p_effective_date
    between effective_start_date and effective_end_date
    for update nowait;

Line: 397


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