APPS.BEN_PPR_SHD SQL Statements

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

Line: 69

    select
  prmry_care_prvdr_id,
  effective_start_date,
  effective_end_date,
  prmry_care_prvdr_typ_cd,
  name,
  ext_ident,
  prtt_enrt_rslt_id,
  elig_cvrd_dpnt_id,
  business_group_id,
  ppr_attribute_category,
  ppr_attribute1,
  ppr_attribute2,
  ppr_attribute3,
  ppr_attribute4,
  ppr_attribute5,
  ppr_attribute6,
  ppr_attribute7,
  ppr_attribute8,
  ppr_attribute9,
  ppr_attribute10,
  ppr_attribute11,
  ppr_attribute12,
  ppr_attribute13,
  ppr_attribute14,
  ppr_attribute15,
  ppr_attribute16,
  ppr_attribute17,
  ppr_attribute18,
  ppr_attribute19,
  ppr_attribute20,
  ppr_attribute21,
  ppr_attribute22,
  ppr_attribute23,
  ppr_attribute24,
  ppr_attribute25,
  ppr_attribute26,
  ppr_attribute27,
  ppr_attribute28,
  ppr_attribute29,
  ppr_attribute30,
  request_id,
  program_application_id,
  program_id,
  program_update_date,
  object_version_number
    from  ben_prmry_care_prvdr_f
    where prmry_care_prvdr_id = p_prmry_care_prvdr_id
    and   p_effective_date
    between effective_start_date and effective_end_date;

Line: 178

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

    select  t.elig_cvrd_dpnt_id,
      t.prtt_enrt_rslt_id
    from    ben_prmry_care_prvdr_f t
    where   t.prmry_care_prvdr_id = p_base_key_value
    and     p_effective_date
    between t.effective_start_date and t.effective_end_date;

Line: 223

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

Line: 237

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

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

Line: 293

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

Line: 331

    select
  prmry_care_prvdr_id,
  effective_start_date,
  effective_end_date,
  prmry_care_prvdr_typ_cd,
  name,
  ext_ident,
  prtt_enrt_rslt_id,
  elig_cvrd_dpnt_id,
  business_group_id,
  ppr_attribute_category,
  ppr_attribute1,
  ppr_attribute2,
  ppr_attribute3,
  ppr_attribute4,
  ppr_attribute5,
  ppr_attribute6,
  ppr_attribute7,
  ppr_attribute8,
  ppr_attribute9,
  ppr_attribute10,
  ppr_attribute11,
  ppr_attribute12,
  ppr_attribute13,
  ppr_attribute14,
  ppr_attribute15,
  ppr_attribute16,
  ppr_attribute17,
  ppr_attribute18,
  ppr_attribute19,
  ppr_attribute20,
  ppr_attribute21,
  ppr_attribute22,
  ppr_attribute23,
  ppr_attribute24,
  ppr_attribute25,
  ppr_attribute26,
  ppr_attribute27,
  ppr_attribute28,
  ppr_attribute29,
  ppr_attribute30,
  request_id,
  program_application_id,
  program_id,
  program_update_date,
  object_version_number
    from    ben_prmry_care_prvdr_f
    where   prmry_care_prvdr_id         = p_prmry_care_prvdr_id
    and     p_effective_date
    between effective_start_date and effective_end_date
    for update nowait;

Line: 408

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

Line: 535

  p_program_update_date           in date,
  p_object_version_number         in number
  )
  Return g_rec_type is
--
  l_rec   g_rec_type;

Line: 592

  l_rec.program_update_date              := p_program_update_date;