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

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

Line: 58


    select
     optip_id
    ,effective_start_date
    ,effective_end_date
    ,business_group_id
    ,pgm_id
    ,ptip_id
    ,pl_typ_id
    ,opt_id
    ,cmbn_ptip_opt_id
    ,legislation_code
    ,legislation_subgroup
    ,otp_attribute_category
    ,otp_attribute1
    ,otp_attribute2
    ,otp_attribute3
    ,otp_attribute4
    ,otp_attribute5
    ,otp_attribute6
    ,otp_attribute7
    ,otp_attribute8
    ,otp_attribute9
    ,otp_attribute10
    ,otp_attribute11
    ,otp_attribute12
    ,otp_attribute13
    ,otp_attribute14
    ,otp_attribute15
    ,otp_attribute16
    ,otp_attribute17
    ,otp_attribute18
    ,otp_attribute19
    ,otp_attribute20
    ,otp_attribute21
    ,otp_attribute22
    ,otp_attribute23
    ,otp_attribute24
    ,otp_attribute25
    ,otp_attribute26
    ,otp_attribute27
    ,otp_attribute28
    ,otp_attribute29
    ,otp_attribute30
    ,object_version_number
    from	ben_optip_f
    where	optip_id = p_optip_id
    and		p_effective_date
    between	effective_start_date and effective_end_date;

Line: 163


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


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

Line: 196


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


    select
     t.pgm_id
    ,t.ptip_id
    ,t.opt_id
    from   ben_optip_f t
    where  t.optip_id = p_base_key_value
    and    p_effective_date
    between t.effective_start_date and t.effective_end_date;

Line: 250


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

Line: 292


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

Line: 331


    select
     optip_id
    ,effective_start_date
    ,effective_end_date
    ,business_group_id
    ,pgm_id
    ,ptip_id
    ,pl_typ_id
    ,opt_id
    ,cmbn_ptip_opt_id
    ,legislation_code
    ,legislation_subgroup
    ,otp_attribute_category
    ,otp_attribute1
    ,otp_attribute2
    ,otp_attribute3
    ,otp_attribute4
    ,otp_attribute5
    ,otp_attribute6
    ,otp_attribute7
    ,otp_attribute8
    ,otp_attribute9
    ,otp_attribute10
    ,otp_attribute11
    ,otp_attribute12
    ,otp_attribute13
    ,otp_attribute14
    ,otp_attribute15
    ,otp_attribute16
    ,otp_attribute17
    ,otp_attribute18
    ,otp_attribute19
    ,otp_attribute20
    ,otp_attribute21
    ,otp_attribute22
    ,otp_attribute23
    ,otp_attribute24
    ,otp_attribute25
    ,otp_attribute26
    ,otp_attribute27
    ,otp_attribute28
    ,otp_attribute29
    ,otp_attribute30
    ,object_version_number
    from    ben_optip_f
    where   optip_id = p_optip_id
    and	    p_effective_date
    between effective_start_date and effective_end_date
    for update nowait;

Line: 410


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