[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select cvg.cvg_amt_calc_mthd_id,
cvg.comp_lvl_fctr_id,
cvg.cvg_mlt_cd,
cvg.bndry_perd_cd,
cvg.bnft_typ_cd,
cvg.val,
cvg.nnmntry_uom,
cvg.mx_val,
cvg.mn_val,
cvg.incrmt_val,
cvg.rt_typ_cd,
cvg.business_group_id,
cvg.rndg_cd,
cvg.rndg_rl,
cvg.val_calc_rl,
cvg.dflt_val,
cvg.entr_val_at_enrt_flag,
cvg.lwr_lmt_val,
cvg.lwr_lmt_calc_rl,
cvg.upr_lmt_val,
cvg.upr_lmt_calc_rl,
pln.cvg_incr_r_decr_only_cd,
pln.bnft_or_option_rstrctn_cd,
pln.mx_cvg_rl,
pln.mn_cvg_rl
from ben_cvg_amt_calc_mthd_f cvg,
ben_pl_f pln
where pln.pl_id = c_pln_id
and cvg.pl_id = pln.pl_id
and c_effective_date
between pln.effective_start_date
and pln.effective_end_date
and c_effective_date
between cvg.effective_start_date
and cvg.effective_end_date;
select cvg.cvg_amt_calc_mthd_id,
cvg.comp_lvl_fctr_id,
cvg.cvg_mlt_cd,
cvg.bndry_perd_cd,
cvg.bnft_typ_cd,
cvg.val,
cvg.nnmntry_uom,
cvg.mx_val,
cvg.mn_val,
cvg.incrmt_val,
cvg.rt_typ_cd,
cvg.business_group_id,
cvg.rndg_cd,
cvg.rndg_rl,
cvg.val_calc_rl,
cvg.dflt_val,
cvg.entr_val_at_enrt_flag,
cvg.lwr_lmt_val,
cvg.lwr_lmt_calc_rl,
cvg.upr_lmt_val,
cvg.upr_lmt_calc_rl,
pln.cvg_incr_r_decr_only_cd,
pln.bnft_or_option_rstrctn_cd,
pln.mx_cvg_rl,
pln.mn_cvg_rl
from ben_cvg_amt_calc_mthd_f cvg,
ben_plip_f cpp,
ben_pl_f pln
where cpp.plip_id = c_plip_id
and cvg.plip_id = cpp.plip_id
and cpp.pl_id = pln.pl_id
and c_effective_date
between cpp.effective_start_date
and cpp.effective_end_date
and c_effective_date
between pln.effective_start_date
and pln.effective_end_date
and c_effective_date
between cvg.effective_start_date
and cvg.effective_end_date;
select cvg.cvg_amt_calc_mthd_id,
cvg.comp_lvl_fctr_id,
cvg.cvg_mlt_cd,
cvg.bndry_perd_cd,
cvg.bnft_typ_cd,
cvg.val,
cvg.nnmntry_uom,
cvg.mx_val,
cvg.mn_val,
cvg.incrmt_val,
cvg.rt_typ_cd,
cvg.business_group_id,
cvg.rndg_cd,
cvg.rndg_rl,
cvg.val_calc_rl,
cvg.dflt_val,
cvg.entr_val_at_enrt_flag,
cvg.lwr_lmt_val,
cvg.lwr_lmt_calc_rl,
cvg.upr_lmt_val,
cvg.upr_lmt_calc_rl,
pln.cvg_incr_r_decr_only_cd,
pln.bnft_or_option_rstrctn_cd,
pln.mx_cvg_rl,
pln.mn_cvg_rl
from ben_cvg_amt_calc_mthd_f cvg,
ben_oipl_f cop,
ben_pl_f pln
where cop.oipl_id = c_oipl_id
and cvg.oipl_id = cop.oipl_id
and cop.pl_id = pln.pl_id
and c_effective_date
between cop.effective_start_date
and cop.effective_end_date
and c_effective_date
between pln.effective_start_date
and pln.effective_end_date
and c_effective_date
between cvg.effective_start_date
and cvg.effective_end_date;