APPS.PAY_PSD_SHD SQL Statements

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

Line: 47

    select
     sii_details_id
    ,effective_start_date
    ,effective_end_date
    ,per_or_asg_id
    ,business_group_id
    ,contract_category
    ,object_version_number
    ,emp_social_security_info
    ,old_age_contribution
    ,pension_contribution
    ,sickness_contribution
    ,work_injury_contribution
    ,labor_contribution
    ,health_contribution
    ,unemployment_contribution
    ,old_age_cont_end_reason
    ,pension_cont_end_reason
    ,sickness_cont_end_reason
    ,work_injury_cont_end_reason
    ,labor_fund_cont_end_reason
    ,health_cont_end_reason
    ,unemployment_cont_end_reason
    ,program_id
    ,program_login_id
    ,program_application_id
    ,request_id
    from        pay_pl_sii_details_f
    where       sii_details_id = p_sii_details_id
    and         p_effective_date
    between     effective_start_date and effective_end_date;

Line: 136

  ,p_update                 out nocopy boolean
  ,p_update_override        out nocopy boolean
  ,p_update_change_insert   out nocopy boolean
  ,p_correction_start_date	OUT NOCOPY DATE
  ,p_correction_end_date	OUT NOCOPY DATE
  ,p_update_start_date		OUT NOCOPY DATE
  ,p_update_end_date		OUT NOCOPY DATE
  ,p_override_start_date	OUT NOCOPY DATE
  ,p_override_end_date		OUT NOCOPY DATE
  ,p_upd_chg_start_date		OUT NOCOPY DATE
  ,p_upd_chg_end_date		OUT NOCOPY DATE
  ) is
--
  l_proc        varchar2(72) := g_package||'find_dt_upd_modes';

Line: 162

    ,p_update                => p_update
    ,p_update_override       => p_update_override
    ,p_update_change_insert  => p_update_change_insert
    ,p_correction_start_date	=> p_correction_start_date
    ,p_correction_end_date		=> p_correction_end_date
    ,p_update_start_date		=> p_update_start_date
    ,p_update_end_date		=> p_update_end_date
    ,p_override_start_date		=> p_override_start_date
    ,p_override_end_date		=> p_override_end_date
    ,p_upd_chg_start_date		=> p_upd_chg_start_date
    ,p_upd_chg_end_date		=> p_upd_chg_end_date
    );

Line: 185

  ,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

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

Line: 246

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

Line: 280

    select
     sii_details_id
    ,effective_start_date
    ,effective_end_date
    ,per_or_asg_id
    ,business_group_id
    ,contract_category
    ,object_version_number
    ,emp_social_security_info
    ,old_age_contribution
    ,pension_contribution
    ,sickness_contribution
    ,work_injury_contribution
    ,labor_contribution
    ,health_contribution
    ,unemployment_contribution
    ,old_age_cont_end_reason
    ,pension_cont_end_reason
    ,sickness_cont_end_reason
    ,work_injury_cont_end_reason
    ,labor_fund_cont_end_reason
    ,health_cont_end_reason
    ,unemployment_cont_end_reason
    ,program_id
    ,program_login_id
    ,program_application_id
    ,request_id
    from    pay_pl_sii_details_f
    where   sii_details_id = p_sii_details_id
    and     p_effective_date
    between effective_start_date and effective_end_date
    for update nowait;

Line: 342

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