APPS.BEN_COP_SHD SQL Statements

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

Line: 69

    select
	oipl_id,
	effective_start_date,
	effective_end_date,
	ivr_ident,
        url_ref_name,
	opt_id,
	business_group_id,
	pl_id,
	ordr_num,
	rqd_perd_enrt_nenrt_val,
	actl_prem_id,
	dflt_flag,
	mndtry_flag,
	oipl_stat_cd,
      pcp_dsgn_cd,
      pcp_dpnt_dsgn_cd,
	rqd_perd_enrt_nenrt_uom,
	elig_apls_flag,
	dflt_enrt_det_rl,
	trk_inelig_per_flag,
	drvbl_fctr_prtn_elig_flag,
	mndtry_rl,
	rqd_perd_enrt_nenrt_rl,
	dflt_enrt_cd,
	prtn_elig_ovrid_alwd_flag,
	drvbl_fctr_apls_rts_flag,
      per_cvrd_cd,
      postelcn_edit_rl,
      vrfy_fmly_mmbr_cd,
      vrfy_fmly_mmbr_rl,
      enrt_cd,
      enrt_rl,
      auto_enrt_flag,
      auto_enrt_mthd_rl,
      short_name,	/*FHR*/
      short_code,	/*FHR*/
            legislation_code,	/*FHR*/
            legislation_subgroup,	/*FHR*/
      hidden_flag,
      susp_if_ctfn_not_prvd_flag,
      ctfn_determine_cd,
	cop_attribute_category,
	cop_attribute1,
	cop_attribute2,
	cop_attribute3,
	cop_attribute4,
	cop_attribute5,
	cop_attribute6,
	cop_attribute7,
	cop_attribute8,
	cop_attribute9,
	cop_attribute10,
	cop_attribute11,
	cop_attribute12,
	cop_attribute13,
	cop_attribute14,
	cop_attribute15,
	cop_attribute16,
	cop_attribute17,
	cop_attribute18,
	cop_attribute19,
	cop_attribute20,
	cop_attribute21,
	cop_attribute22,
	cop_attribute23,
	cop_attribute24,
	cop_attribute25,
	cop_attribute26,
	cop_attribute27,
	cop_attribute28,
	cop_attribute29,
	cop_attribute30,
	object_version_number
    from	ben_oipl_f
    where	oipl_id = p_oipl_id
    and		p_effective_date
    between	effective_start_date and effective_end_date;

Line: 206

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

    select  t.dflt_enrt_det_rl,
	    t.mndtry_rl,
            t.postelcn_edit_rl,
            t.vrfy_fmly_mmbr_rl,
	    t.actl_prem_id,
	    t.pl_id,
	    t.opt_id
    from    ben_oipl_f t
    where   t.oipl_id = p_base_key_value
    and     p_effective_date
    between t.effective_start_date and t.effective_end_date;

Line: 281

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

Line: 295

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

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

Line: 351

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

Line: 389

    select
	oipl_id,
	effective_start_date,
	effective_end_date,
	ivr_ident,
        url_ref_name,
	opt_id,
	business_group_id,
	pl_id,
	ordr_num,
	rqd_perd_enrt_nenrt_val,
	dflt_flag,
	actl_prem_id,
	mndtry_flag,
	oipl_stat_cd,
      pcp_dsgn_cd,
      pcp_dpnt_dsgn_cd,
	rqd_perd_enrt_nenrt_uom,
	elig_apls_flag,
	dflt_enrt_det_rl,
	trk_inelig_per_flag,
	drvbl_fctr_prtn_elig_flag,
	mndtry_rl,
	rqd_perd_enrt_nenrt_rl,
	dflt_enrt_cd,
	prtn_elig_ovrid_alwd_flag,
	drvbl_fctr_apls_rts_flag,
      per_cvrd_cd,
      postelcn_edit_rl,
      vrfy_fmly_mmbr_cd,
      vrfy_fmly_mmbr_rl,
      enrt_cd,
      enrt_rl,
      auto_enrt_flag,
      auto_enrt_mthd_rl,
      short_name,	/*FHR*/
      short_code,	/*FHR*/
            legislation_code,	/*FHR*/
            legislation_subgroup,	/*FHR*/
      hidden_flag,
      susp_if_ctfn_not_prvd_flag,
      ctfn_determine_cd,
	cop_attribute_category,
	cop_attribute1,
	cop_attribute2,
	cop_attribute3,
	cop_attribute4,
	cop_attribute5,
	cop_attribute6,
	cop_attribute7,
	cop_attribute8,
	cop_attribute9,
	cop_attribute10,
	cop_attribute11,
	cop_attribute12,
	cop_attribute13,
	cop_attribute14,
	cop_attribute15,
	cop_attribute16,
	cop_attribute17,
	cop_attribute18,
	cop_attribute19,
	cop_attribute20,
	cop_attribute21,
	cop_attribute22,
	cop_attribute23,
	cop_attribute24,
	cop_attribute25,
	cop_attribute26,
	cop_attribute27,
	cop_attribute28,
	cop_attribute29,
	cop_attribute30,
	object_version_number
    from    ben_oipl_f
    where   oipl_id         = p_oipl_id
    and	    p_effective_date
    between effective_start_date and effective_end_date
    for update nowait;

Line: 494

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