APPS.BEN_PRY_SHD SQL Statements

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

Line: 58

    select
     prtt_rmt_aprvd_fr_pymt_id
    ,prtt_reimbmt_rqst_id
    ,effective_start_date
    ,effective_end_date
    ,apprvd_fr_pymt_num
    ,adjmt_flag
    ,aprvd_fr_pymt_amt
    ,pymt_stat_cd
    ,pymt_stat_rsn_cd
    ,pymt_stat_ovrdn_rsn_cd
    ,pymt_stat_prr_to_ovrd_cd
    ,business_group_id
    ,element_entry_value_id
    ,pry_attribute_category
    ,pry_attribute1
    ,pry_attribute2
    ,pry_attribute3
    ,pry_attribute4
    ,pry_attribute5
    ,pry_attribute6
    ,pry_attribute7
    ,pry_attribute8
    ,pry_attribute9
    ,pry_attribute10
    ,pry_attribute11
    ,pry_attribute12
    ,pry_attribute13
    ,pry_attribute14
    ,pry_attribute15
    ,pry_attribute16
    ,pry_attribute17
    ,pry_attribute18
    ,pry_attribute19
    ,pry_attribute20
    ,pry_attribute21
    ,pry_attribute22
    ,pry_attribute23
    ,pry_attribute24
    ,pry_attribute25
    ,pry_attribute26
    ,pry_attribute27
    ,pry_attribute28
    ,pry_attribute29
    ,pry_attribute30
    ,object_version_number
    from        ben_prtt_rmt_aprvd_fr_pymt_f
    where       prtt_rmt_aprvd_fr_pymt_id = p_prtt_rmt_aprvd_fr_pymt_id
    and         p_effective_date
    between     effective_start_date and effective_end_date;

Line: 166

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

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

Line: 193

    p_update              := FALSE;

Line: 194

    p_update_override     := FALSE;

Line: 195

    p_update_change_insert := FALSE;

Line: 209

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

    select
     t.prtt_reimbmt_rqst_id
    from   ben_prtt_rmt_aprvd_fr_pymt_f t
    where  t.prtt_rmt_aprvd_fr_pymt_id = p_base_key_value
    and    p_effective_date
    between t.effective_start_date and t.effective_end_date;

Line: 251

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

Line: 262

p_delete                     := FALSE;

Line: 264

p_delete_next_change          := FALSE;

Line: 307

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

Line: 346

    select
     prtt_rmt_aprvd_fr_pymt_id
    ,prtt_reimbmt_rqst_id
    ,effective_start_date
    ,effective_end_date
    ,apprvd_fr_pymt_num
    ,adjmt_flag
    ,aprvd_fr_pymt_amt
    ,pymt_stat_cd
    ,pymt_stat_rsn_cd
    ,pymt_stat_ovrdn_rsn_cd
    ,pymt_stat_prr_to_ovrd_cd
    ,business_group_id
    ,element_entry_value_id
    ,pry_attribute_category
    ,pry_attribute1
    ,pry_attribute2
    ,pry_attribute3
    ,pry_attribute4
    ,pry_attribute5
    ,pry_attribute6
    ,pry_attribute7
    ,pry_attribute8
    ,pry_attribute9
    ,pry_attribute10
    ,pry_attribute11
    ,pry_attribute12
    ,pry_attribute13
    ,pry_attribute14
    ,pry_attribute15
    ,pry_attribute16
    ,pry_attribute17
    ,pry_attribute18
    ,pry_attribute19
    ,pry_attribute20
    ,pry_attribute21
    ,pry_attribute22
    ,pry_attribute23
    ,pry_attribute24
    ,pry_attribute25
    ,pry_attribute26
    ,pry_attribute27
    ,pry_attribute28
    ,pry_attribute29
    ,pry_attribute30
    ,object_version_number
    from    ben_prtt_rmt_aprvd_fr_pymt_f
    where   prtt_rmt_aprvd_fr_pymt_id = p_prtt_rmt_aprvd_fr_pymt_id
    and     p_effective_date
    between effective_start_date and effective_end_date
    for update nowait;

Line: 427

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