APPS.BEN_PEI_SHD SQL Statements

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

Line: 64

    select
    pl_extract_identifier_id
    ,pl_id
    ,plip_id
    ,oipl_id
    ,third_party_identifier
    ,organization_id
    ,job_id
    ,position_id
    ,people_group_id
    ,grade_id
    ,payroll_id
    ,home_state
    ,home_zip
    ,effective_start_date
    ,effective_end_date
    ,created_by
    ,creation_date
    ,last_update_date
    ,last_updated_by
    ,last_update_login
    ,object_version_number
    ,business_group_id
    from    ben_pl_extract_identifier_f
    where    pl_extract_identifier_id = p_pl_extract_identifier_id
    and        p_effective_date
    between    effective_start_date and effective_end_date;

Line: 151

     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: 170

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

Line: 185

     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: 202

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

Line: 242

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

Line: 284

    select
    pl_extract_identifier_id
    ,pl_id
    ,plip_id
    ,oipl_id
    ,third_party_identifier
    ,organization_id
    ,job_id
    ,position_id
    ,people_group_id
    ,grade_id
    ,payroll_id
    ,home_state
    ,home_zip
    ,effective_start_date
    ,effective_end_date
    ,created_by
    ,creation_date
    ,last_update_date
    ,last_updated_by
    ,last_update_login
    ,object_version_number
    ,business_group_id
    from    ben_pl_extract_identifier_f
    where   pl_extract_identifier_id = p_pl_extract_identifier_id
    and     p_effective_date between effective_start_date and effective_end_date
    for update nowait;

Line: 337

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