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

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

Line: 134


    select
     element_link_id
    ,effective_start_date
    ,effective_end_date
    ,payroll_id
    ,job_id
    ,position_id
    ,people_group_id
    ,cost_allocation_keyflex_id
    ,organization_id
    ,element_type_id
    ,location_id
    ,grade_id
    ,balancing_keyflex_id
    ,business_group_id
    ,element_set_id
    ,pay_basis_id
    ,costable_type
    ,link_to_all_payrolls_flag
    ,multiply_value_flag
    ,standard_link_flag
    ,transfer_to_gl_flag
    ,comment_id
    ,null
    ,employment_category
    ,qualifying_age
    ,qualifying_length_of_service
    ,qualifying_units
    ,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
    from        pay_element_links_f
    where       element_link_id = p_element_link_id
    and         p_effective_date
    between     effective_start_date and effective_end_date;

Line: 246


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


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

Line: 279


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


    select
     t.payroll_id
    ,t.element_type_id
    from   pay_element_links_f t
    where  t.element_link_id = p_base_key_value
    and    p_effective_date
    between t.effective_start_date and t.effective_end_date;

Line: 327


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

Line: 369


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

Line: 409


    select
     element_link_id
    ,effective_start_date
    ,effective_end_date
    ,payroll_id
    ,job_id
    ,position_id
    ,people_group_id
    ,cost_allocation_keyflex_id
    ,organization_id
    ,element_type_id
    ,location_id
    ,grade_id
    ,balancing_keyflex_id
    ,business_group_id
    ,element_set_id
    ,pay_basis_id
    ,costable_type
    ,link_to_all_payrolls_flag
    ,multiply_value_flag
    ,standard_link_flag
    ,transfer_to_gl_flag
    ,comment_id
    ,null
    ,employment_category
    ,qualifying_age
    ,qualifying_length_of_service
    ,qualifying_units
    ,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
    from    pay_element_links_f
    where   element_link_id = p_element_link_id
    and     p_effective_date
    between effective_start_date and effective_end_date
    for update nowait;

Line: 468


    select hc.comment_text
    from   hr_comments hc
    where  hc.comment_id = pay_pel_shd.g_old_rec.comment_id;

Line: 499


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

Line: 524


        (p_datetrack_mode = hr_api.g_update             or
         p_datetrack_mode = hr_api.g_correction         or
         p_datetrack_mode = hr_api.g_update_override    or
         p_datetrack_mode = hr_api.g_update_change_insert)) then
       Open C_Sel3;