The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
pl_id
,effective_start_date
,effective_end_date
,name
,alws_qdro_flag
,alws_qmcso_flag
,alws_reimbmts_flag
,bnf_addl_instn_txt_alwd_flag
,bnf_adrs_rqd_flag
,bnf_cntngt_bnfs_alwd_flag
,bnf_ctfn_rqd_flag
,bnf_dob_rqd_flag
,bnf_dsge_mnr_ttee_rqd_flag
,bnf_incrmt_amt
,bnf_dflt_bnf_cd
,bnf_legv_id_rqd_flag
,bnf_may_dsgt_org_flag
,bnf_mn_dsgntbl_amt
,bnf_mn_dsgntbl_pct_val
,rqd_perd_enrt_nenrt_val
,ordr_num
,bnf_pct_incrmt_val
,bnf_pct_amt_alwd_cd
,bnf_qdro_rl_apls_flag
,dflt_to_asn_pndg_ctfn_cd
,dflt_to_asn_pndg_ctfn_rl
,drvbl_fctr_apls_rts_flag
,drvbl_fctr_prtn_elig_flag
,dpnt_dsgn_cd
,elig_apls_flag
,invk_dcln_prtn_pl_flag
,invk_flx_cr_pl_flag
,imptd_incm_calc_cd
,drvbl_dpnt_elig_flag
,trk_inelig_per_flag
,pl_cd
,auto_enrt_mthd_rl
,ivr_ident
,url_ref_name
,cmpr_clms_to_cvg_or_bal_cd
,cobra_pymt_due_dy_num
,dpnt_cvd_by_othr_apls_flag
,enrt_mthd_cd
,enrt_cd
,enrt_cvg_strt_dt_cd
,enrt_cvg_end_dt_cd
,frfs_aply_flag
,hc_pl_subj_hcfa_aprvl_flag
,hghly_cmpd_rl_apls_flag
,incptn_dt
,mn_cvg_rl
,mn_cvg_rqd_amt
,mn_opts_rqd_num
,mx_cvg_alwd_amt
,mx_cvg_rl
,mx_opts_alwd_num
,mx_cvg_wcfn_mlt_num
,mx_cvg_wcfn_amt
,mx_cvg_incr_alwd_amt
,mx_cvg_incr_wcf_alwd_amt
,mx_cvg_mlt_incr_num
,mx_cvg_mlt_incr_wcf_num
,mx_wtg_dt_to_use_cd
,mx_wtg_dt_to_use_rl
,mx_wtg_perd_prte_uom
,mx_wtg_perd_prte_val
,mx_wtg_perd_rl
,nip_dflt_enrt_cd
,nip_dflt_enrt_det_rl
,dpnt_adrs_rqd_flag
,dpnt_cvg_end_dt_cd
,dpnt_cvg_end_dt_rl
,dpnt_cvg_strt_dt_cd
,dpnt_cvg_strt_dt_rl
,dpnt_dob_rqd_flag
,dpnt_leg_id_rqd_flag
,dpnt_no_ctfn_rqd_flag
,no_mn_cvg_amt_apls_flag
,no_mn_cvg_incr_apls_flag
,no_mn_opts_num_apls_flag
,no_mx_cvg_amt_apls_flag
,no_mx_cvg_incr_apls_flag
,no_mx_opts_num_apls_flag
,nip_pl_uom
,rqd_perd_enrt_nenrt_uom
,nip_acty_ref_perd_cd
,nip_enrt_info_rt_freq_cd
,per_cvrd_cd
,enrt_cvg_end_dt_rl
,postelcn_edit_rl
,enrt_cvg_strt_dt_rl
,prort_prtl_yr_cvg_rstrn_cd
,prort_prtl_yr_cvg_rstrn_rl
,prtn_elig_ovrid_alwd_flag
,svgs_pl_flag
,subj_to_imptd_incm_typ_cd
,use_all_asnts_elig_flag
,use_all_asnts_for_rt_flag
,vstg_apls_flag
,wvbl_flag
,hc_svc_typ_cd
,pl_stat_cd
,prmry_fndg_mthd_cd
,rt_end_dt_cd
,rt_end_dt_rl
,rt_strt_dt_rl
,rt_strt_dt_cd
,bnf_dsgn_cd
,pl_typ_id
,business_group_id
,enrt_pl_opt_flag
,bnft_prvdr_pool_id
,may_enrl_pl_n_oipl_flag
,enrt_rl
,rqd_perd_enrt_nenrt_rl
,alws_unrstrctd_enrt_flag
,bnft_or_option_rstrctn_cd
,cvg_incr_r_decr_only_cd
,unsspnd_enrt_cd
,pln_attribute_category
,pln_attribute1
,pln_attribute2
,pln_attribute3
,pln_attribute4
,pln_attribute5
,pln_attribute6
,pln_attribute7
,pln_attribute8
,pln_attribute9
,pln_attribute10
,pln_attribute11
,pln_attribute12
,pln_attribute13
,pln_attribute14
,pln_attribute15
,pln_attribute16
,pln_attribute17
,pln_attribute18
,pln_attribute19
,pln_attribute20
,pln_attribute21
,pln_attribute22
,pln_attribute23
,pln_attribute24
,pln_attribute25
,pln_attribute26
,pln_attribute27
,pln_attribute28
,pln_attribute29
,pln_attribute30
,susp_if_ctfn_not_prvd_flag
,ctfn_determine_cd
,susp_if_dpnt_ssn_nt_prv_cd
,susp_if_dpnt_dob_nt_prv_cd
,susp_if_dpnt_adr_nt_prv_cd
,susp_if_ctfn_not_dpnt_flag
,susp_if_bnf_ssn_nt_prv_cd
,susp_if_bnf_dob_nt_prv_cd
,susp_if_bnf_adr_nt_prv_cd
,susp_if_ctfn_not_bnf_flag
,dpnt_ctfn_determine_cd
,bnf_ctfn_determine_cd
,last_update_date
,last_updated_by
,last_update_login
,created_by
,creation_date
,object_version_number
,actl_prem_id
,vrfy_fmly_mmbr_cd
,vrfy_fmly_mmbr_rl
,alws_tmpry_id_crd_flag
,nip_dflt_flag
,frfs_distr_mthd_cd
,frfs_distr_mthd_rl
,frfs_cntr_det_cd
,frfs_distr_det_cd
,cost_alloc_keyflex_1_id
,cost_alloc_keyflex_2_id
,post_to_gl_flag
,frfs_val_det_cd
,frfs_mx_cryfwd_val
,frfs_portion_det_cd
,bndry_perd_cd
,short_name
,short_code
,legislation_code
,legislation_subgroup
,group_pl_id
,mapping_table_name
,mapping_table_pk_id
,function_code
,pl_yr_not_applcbl_flag
,use_csd_rsd_prccng_cd
,all_inelig
,bnf_exl_participant_flag --Enh 16043887
from ben_pl_f
where pl_id = p_pl_id
and p_effective_date
between effective_start_date and effective_end_date;
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';
l_delete boolean;
l_delete1 boolean;
l_delete_next_change boolean;
l_delete_next_change1 boolean;
select t.dflt_to_asn_pndg_ctfn_rl,
t.auto_enrt_mthd_rl,
t.mn_cvg_rl,
t.mx_cvg_rl,
t.mx_wtg_dt_to_use_rl,
t.nip_dflt_enrt_det_rl,
t.dpnt_cvg_end_dt_rl,
t.dpnt_cvg_strt_dt_rl,
t.enrt_cvg_end_dt_rl,
t.postelcn_edit_rl,
t.enrt_cvg_strt_dt_rl,
t.prort_prtl_yr_cvg_rstrn_rl,
t.rt_end_dt_rl,
t.rt_strt_dt_rl,
t.pl_typ_id,
t.actl_prem_id
from ben_pl_f t
where t.pl_id = p_base_key_value
and p_effective_date
between t.effective_start_date and t.effective_end_date;
p_delete => l_delete,
p_future_change => l_future_change,
p_delete_next_change => l_delete_next_change);
p_delete => l_delete1,
p_future_change => l_future_change1,
p_delete_next_change => l_delete_next_change1);
if l_delete and l_delete1 then
--
p_delete := true;
p_delete := false;
if l_delete_next_change and l_delete_next_change1 then
--
p_delete_next_change := true;
p_delete_next_change := false;
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';
p_update => p_update,
p_update_override => p_update_override,
p_update_change_insert => p_update_change_insert);
update ben_pl_f t
set t.effective_end_date = p_new_effective_end_date,
t.object_version_number = l_object_version_number
where t.pl_id = p_base_key_value
and p_effective_date
between t.effective_start_date and t.effective_end_date;
select
pl_id
,effective_start_date
,effective_end_date
,name
,alws_qdro_flag
,alws_qmcso_flag
,alws_reimbmts_flag
,bnf_addl_instn_txt_alwd_flag
,bnf_adrs_rqd_flag
,bnf_cntngt_bnfs_alwd_flag
,bnf_ctfn_rqd_flag
,bnf_dob_rqd_flag
,bnf_dsge_mnr_ttee_rqd_flag
,bnf_incrmt_amt
,bnf_dflt_bnf_cd
,bnf_legv_id_rqd_flag
,bnf_may_dsgt_org_flag
,bnf_mn_dsgntbl_amt
,bnf_mn_dsgntbl_pct_val
,rqd_perd_enrt_nenrt_val
,ordr_num
,bnf_pct_incrmt_val
,bnf_pct_amt_alwd_cd
,bnf_qdro_rl_apls_flag
,dflt_to_asn_pndg_ctfn_cd
,dflt_to_asn_pndg_ctfn_rl
,drvbl_fctr_apls_rts_flag
,drvbl_fctr_prtn_elig_flag
,dpnt_dsgn_cd
,elig_apls_flag
,invk_dcln_prtn_pl_flag
,invk_flx_cr_pl_flag
,imptd_incm_calc_cd
,drvbl_dpnt_elig_flag
,trk_inelig_per_flag
,pl_cd
,auto_enrt_mthd_rl
,ivr_ident
,url_ref_name
,cmpr_clms_to_cvg_or_bal_cd
,cobra_pymt_due_dy_num
,dpnt_cvd_by_othr_apls_flag
,enrt_mthd_cd
,enrt_cd
,enrt_cvg_strt_dt_cd
,enrt_cvg_end_dt_cd
,frfs_aply_flag
,hc_pl_subj_hcfa_aprvl_flag
,hghly_cmpd_rl_apls_flag
,incptn_dt
,mn_cvg_rl
,mn_cvg_rqd_amt
,mn_opts_rqd_num
,mx_cvg_alwd_amt
,mx_cvg_rl
,mx_opts_alwd_num
,mx_cvg_wcfn_mlt_num
,mx_cvg_wcfn_amt
,mx_cvg_incr_alwd_amt
,mx_cvg_incr_wcf_alwd_amt
,mx_cvg_mlt_incr_num
,mx_cvg_mlt_incr_wcf_num
,mx_wtg_dt_to_use_cd
,mx_wtg_dt_to_use_rl
,mx_wtg_perd_prte_uom
,mx_wtg_perd_prte_val
,mx_wtg_perd_rl
,nip_dflt_enrt_cd
,nip_dflt_enrt_det_rl
,dpnt_adrs_rqd_flag
,dpnt_cvg_end_dt_cd
,dpnt_cvg_end_dt_rl
,dpnt_cvg_strt_dt_cd
,dpnt_cvg_strt_dt_rl
,dpnt_dob_rqd_flag
,dpnt_leg_id_rqd_flag
,dpnt_no_ctfn_rqd_flag
,no_mn_cvg_amt_apls_flag
,no_mn_cvg_incr_apls_flag
,no_mn_opts_num_apls_flag
,no_mx_cvg_amt_apls_flag
,no_mx_cvg_incr_apls_flag
,no_mx_opts_num_apls_flag
,nip_pl_uom
,rqd_perd_enrt_nenrt_uom
,nip_acty_ref_perd_cd
,nip_enrt_info_rt_freq_cd
,per_cvrd_cd
,enrt_cvg_end_dt_rl
,postelcn_edit_rl
,enrt_cvg_strt_dt_rl
,prort_prtl_yr_cvg_rstrn_cd
,prort_prtl_yr_cvg_rstrn_rl
,prtn_elig_ovrid_alwd_flag
,svgs_pl_flag
,subj_to_imptd_incm_typ_cd
,use_all_asnts_elig_flag
,use_all_asnts_for_rt_flag
,vstg_apls_flag
,wvbl_flag
,hc_svc_typ_cd
,pl_stat_cd
,prmry_fndg_mthd_cd
,rt_end_dt_cd
,rt_end_dt_rl
,rt_strt_dt_rl
,rt_strt_dt_cd
,bnf_dsgn_cd
,pl_typ_id
,business_group_id
,enrt_pl_opt_flag
,bnft_prvdr_pool_id
,may_enrl_pl_n_oipl_flag
,enrt_rl
,rqd_perd_enrt_nenrt_rl
,alws_unrstrctd_enrt_flag
,bnft_or_option_rstrctn_cd
,cvg_incr_r_decr_only_cd
,unsspnd_enrt_cd
,pln_attribute_category
,pln_attribute1
,pln_attribute2
,pln_attribute3
,pln_attribute4
,pln_attribute5
,pln_attribute6
,pln_attribute7
,pln_attribute8
,pln_attribute9
,pln_attribute10
,pln_attribute11
,pln_attribute12
,pln_attribute13
,pln_attribute14
,pln_attribute15
,pln_attribute16
,pln_attribute17
,pln_attribute18
,pln_attribute19
,pln_attribute20
,pln_attribute21
,pln_attribute22
,pln_attribute23
,pln_attribute24
,pln_attribute25
,pln_attribute26
,pln_attribute27
,pln_attribute28
,pln_attribute29
,pln_attribute30
,susp_if_ctfn_not_prvd_flag
,ctfn_determine_cd
,susp_if_dpnt_ssn_nt_prv_cd
,susp_if_dpnt_dob_nt_prv_cd
,susp_if_dpnt_adr_nt_prv_cd
,susp_if_ctfn_not_dpnt_flag
,susp_if_bnf_ssn_nt_prv_cd
,susp_if_bnf_dob_nt_prv_cd
,susp_if_bnf_adr_nt_prv_cd
,susp_if_ctfn_not_bnf_flag
,dpnt_ctfn_determine_cd
,bnf_ctfn_determine_cd
,last_update_date
,last_updated_by
,last_update_login
,created_by
,creation_date
,object_version_number
,actl_prem_id
,vrfy_fmly_mmbr_cd
,vrfy_fmly_mmbr_rl
,alws_tmpry_id_crd_flag
,nip_dflt_flag
,frfs_distr_mthd_cd
,frfs_distr_mthd_rl
,frfs_cntr_det_cd
,frfs_distr_det_cd
,cost_alloc_keyflex_1_id
,cost_alloc_keyflex_2_id
,post_to_gl_flag
,frfs_val_det_cd
,frfs_mx_cryfwd_val
,frfs_portion_det_cd
,bndry_perd_cd
,short_name
,short_code
,legislation_code
,legislation_subgroup
,group_pl_id
,mapping_table_name
,mapping_table_pk_id
,function_code
,pl_yr_not_applcbl_flag
,use_csd_rsd_prccng_cd
,all_inelig
,bnf_exl_participant_flag --Enh 16043887
from ben_pl_f
where pl_id = p_pl_id
and p_effective_date
between effective_start_date and effective_end_date ;
If (p_datetrack_mode <> 'INSERT') then
--
-- We must select and lock the current row.
--
Open C_Sel1;