The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
acty_base_rt_id,
effective_start_date,
effective_end_date,
ordr_num,
acty_typ_cd,
sub_acty_typ_cd,
name,
rt_typ_cd,
bnft_rt_typ_cd,
tx_typ_cd,
use_to_calc_net_flx_cr_flag,
asn_on_enrt_flag,
abv_mx_elcn_val_alwd_flag,
blw_mn_elcn_alwd_flag,
dsply_on_enrt_flag,
parnt_chld_cd,
use_calc_acty_bs_rt_flag,
uses_ded_sched_flag,
uses_varbl_rt_flag,
vstg_sched_apls_flag,
rt_mlt_cd,
proc_each_pp_dflt_flag,
prdct_flx_cr_when_elig_flag,
no_std_rt_used_flag,
rcrrg_cd,
mn_elcn_val,
mx_elcn_val,
lwr_lmt_val,
lwr_lmt_calc_rl,
upr_lmt_val,
upr_lmt_calc_rl,
ptd_comp_lvl_fctr_id,
clm_comp_lvl_fctr_id,
entr_ann_val_flag,
ann_mn_elcn_val,
ann_mx_elcn_val,
wsh_rl_dy_mo_num,
uses_pymt_sched_flag,
nnmntry_uom,
val,
incrmt_elcn_val,
rndg_cd,
val_ovrid_alwd_flag,
prtl_mo_det_mthd_cd,
acty_base_rt_stat_cd,
procg_src_cd,
dflt_val,
dflt_flag,
frgn_erg_ded_typ_cd,
frgn_erg_ded_name,
frgn_erg_ded_ident,
no_mx_elcn_val_dfnd_flag,
prtl_mo_det_mthd_rl,
entr_val_at_enrt_flag,
prtl_mo_eff_dt_det_rl,
rndg_rl,
val_calc_rl,
no_mn_elcn_val_dfnd_flag,
prtl_mo_eff_dt_det_cd,
only_one_bal_typ_alwd_flag,
rt_usg_cd,
prort_mn_ann_elcn_val_cd,
prort_mn_ann_elcn_val_rl,
prort_mx_ann_elcn_val_cd,
prort_mx_ann_elcn_val_rl,
one_ann_pymt_cd,
det_pl_ytd_cntrs_cd,
asmt_to_use_cd,
ele_rqd_flag,
subj_to_imptd_incm_flag,
element_type_id,
input_value_id,
input_va_calc_rl,
comp_lvl_fctr_id,
parnt_acty_base_rt_id,
pgm_id,
pl_id,
oipl_id,
opt_id,
oiplip_id,
plip_id,
ptip_id,
cmbn_plip_id,
cmbn_ptip_id,
cmbn_ptip_opt_id,
vstg_for_acty_rt_id,
actl_prem_id,
ALWS_CHG_CD ,
ele_entry_val_cd ,
TTL_COMP_LVL_FCTR_ID ,
COST_ALLOCATION_KEYFLEX_ID,
pay_rate_grade_rule_id ,
rate_periodization_cd,
rate_periodization_rl,
mn_mx_elcn_rl,
mapping_table_name,
mapping_table_pk_id,
business_group_id,
context_pgm_id,
context_pl_id ,
context_opt_id,
element_det_rl,
currency_det_cd ,
abr_attribute_category,
abr_attribute1,
abr_attribute2,
abr_attribute3,
abr_attribute4,
abr_attribute5,
abr_attribute6,
abr_attribute7,
abr_attribute8,
abr_attribute9,
abr_attribute10,
abr_attribute11,
abr_attribute12,
abr_attribute13,
abr_attribute14,
abr_attribute15,
abr_attribute16,
abr_attribute17,
abr_attribute18,
abr_attribute19,
abr_attribute20,
abr_attribute21,
abr_attribute22,
abr_attribute23,
abr_attribute24,
abr_attribute25,
abr_attribute26,
abr_attribute27,
abr_attribute28,
abr_attribute29,
abr_attribute30,
abr_seq_num,
object_version_number
from ben_acty_base_rt_f
where acty_base_rt_id = p_acty_base_rt_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.prtl_mo_det_mthd_rl,
t.prtl_mo_eff_dt_det_rl,
t.rndg_rl,
t.val_calc_rl,
t.vstg_for_acty_rt_id,
t.pgm_id,
t.ptip_id,
t.oipl_id,
t.plip_id,
t.pl_id,
t.parnt_acty_base_rt_id,
t.lwr_lmt_calc_rl,
t.upr_lmt_calc_rl,
t.oiplip_id,
t.actl_prem_id,
t.opt_id
from ben_acty_base_rt_f t
where t.acty_base_rt_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_acty_base_rt_f t
set t.effective_end_date = p_new_effective_end_date,
t.object_version_number = l_object_version_number
where t.acty_base_rt_id = p_base_key_value
and p_effective_date
between t.effective_start_date and t.effective_end_date;
select
acty_base_rt_id,
effective_start_date,
effective_end_date,
ordr_num,
acty_typ_cd,
sub_acty_typ_cd,
name,
rt_typ_cd,
bnft_rt_typ_cd,
tx_typ_cd,
use_to_calc_net_flx_cr_flag,
asn_on_enrt_flag,
abv_mx_elcn_val_alwd_flag,
blw_mn_elcn_alwd_flag,
dsply_on_enrt_flag,
parnt_chld_cd,
use_calc_acty_bs_rt_flag,
uses_ded_sched_flag,
uses_varbl_rt_flag,
vstg_sched_apls_flag,
rt_mlt_cd,
proc_each_pp_dflt_flag,
prdct_flx_cr_when_elig_flag,
no_std_rt_used_flag,
rcrrg_cd,
mn_elcn_val,
mx_elcn_val,
lwr_lmt_val,
lwr_lmt_calc_rl,
upr_lmt_val,
upr_lmt_calc_rl,
ptd_comp_lvl_fctr_id,
clm_comp_lvl_fctr_id,
entr_ann_val_flag,
ann_mn_elcn_val,
ann_mx_elcn_val,
wsh_rl_dy_mo_num,
uses_pymt_sched_flag,
nnmntry_uom,
val,
incrmt_elcn_val,
rndg_cd,
val_ovrid_alwd_flag,
prtl_mo_det_mthd_cd,
acty_base_rt_stat_cd,
procg_src_cd,
dflt_val,
dflt_flag,
frgn_erg_ded_typ_cd,
frgn_erg_ded_name,
frgn_erg_ded_ident,
no_mx_elcn_val_dfnd_flag,
prtl_mo_det_mthd_rl,
entr_val_at_enrt_flag,
prtl_mo_eff_dt_det_rl,
rndg_rl,
val_calc_rl,
no_mn_elcn_val_dfnd_flag,
prtl_mo_eff_dt_det_cd,
only_one_bal_typ_alwd_flag,
rt_usg_cd,
prort_mn_ann_elcn_val_cd,
prort_mn_ann_elcn_val_rl,
prort_mx_ann_elcn_val_cd,
prort_mx_ann_elcn_val_rl,
one_ann_pymt_cd,
det_pl_ytd_cntrs_cd,
asmt_to_use_cd,
ele_rqd_flag,
subj_to_imptd_incm_flag,
element_type_id,
input_value_id,
input_va_calc_rl,
comp_lvl_fctr_id,
parnt_acty_base_rt_id,
pgm_id,
pl_id,
oipl_id,
opt_id,
oiplip_id,
plip_id,
ptip_id,
cmbn_plip_id,
cmbn_ptip_id,
cmbn_ptip_opt_id,
vstg_for_acty_rt_id,
actl_prem_id,
TTL_COMP_LVL_FCTR_ID ,
COST_ALLOCATION_KEYFLEX_ID,
ALWS_CHG_CD ,
ele_entry_val_cd ,
rate_periodization_cd,
rate_periodization_rl,
pay_rate_grade_rule_id ,
mn_mx_elcn_rl,
mapping_table_name,
mapping_table_pk_id,
business_group_id,
context_pgm_id ,
context_pl_id ,
context_opt_id ,
element_det_rl,
currency_det_cd,
abr_attribute_category,
abr_attribute1,
abr_attribute2,
abr_attribute3,
abr_attribute4,
abr_attribute5,
abr_attribute6,
abr_attribute7,
abr_attribute8,
abr_attribute9,
abr_attribute10,
abr_attribute11,
abr_attribute12,
abr_attribute13,
abr_attribute14,
abr_attribute15,
abr_attribute16,
abr_attribute17,
abr_attribute18,
abr_attribute19,
abr_attribute20,
abr_attribute21,
abr_attribute22,
abr_attribute23,
abr_attribute24,
abr_attribute25,
abr_attribute26,
abr_attribute27,
abr_attribute28,
abr_attribute29,
abr_attribute30,
abr_seq_num,
object_version_number
from ben_acty_base_rt_f
where acty_base_rt_id = p_acty_base_rt_id
and p_effective_date
between effective_start_date and effective_end_date
for update nowait;
If (p_datetrack_mode <> 'INSERT') then
--
-- We must select and lock the current row.
--
Open C_Sel1;