[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select vrp.vrbl_rt_prfl_id,
vrp.rt_hrly_slrd_flag,
vrp.rt_pstl_cd_flag,
vrp.rt_lbr_mmbr_flag,
vrp.rt_lgl_enty_flag,
vrp.rt_benfts_grp_flag,
vrp.rt_wk_loc_flag,
vrp.rt_brgng_unit_flag,
vrp.rt_age_flag,
vrp.rt_los_flag,
vrp.rt_per_typ_flag,
vrp.rt_fl_tm_pt_tm_flag,
vrp.rt_ee_stat_flag,
vrp.rt_grd_flag,
vrp.rt_pct_fl_tm_flag,
vrp.rt_asnt_set_flag,
vrp.rt_hrs_wkd_flag,
vrp.rt_comp_lvl_flag,
vrp.rt_org_unit_flag,
vrp.rt_loa_rsn_flag,
vrp.rt_pyrl_flag,
vrp.rt_schedd_hrs_flag,
vrp.rt_py_bss_flag,
vrp.rt_prfl_rl_flag,
vrp.rt_cmbn_age_los_flag,
vrp.rt_prtt_pl_flag,
vrp.rt_svc_area_flag,
vrp.rt_ppl_grp_flag,
vrp.rt_dsbld_flag,
vrp.rt_hlth_cvg_flag,
vrp.rt_poe_flag,
vrp.rt_ttl_cvg_vol_flag,
vrp.rt_ttl_prtt_flag,
vrp.rt_gndr_flag,
vrp.rt_tbco_use_flag ,
vrp.rt_cntng_prtn_prfl_flag ,
vrp.rt_cbr_quald_bnf_flag,
vrp.rt_optd_mdcr_flag,
vrp.rt_lvg_rsn_flag ,
vrp.rt_pstn_flag ,
vrp.rt_comptncy_flag ,
vrp.rt_job_flag ,
vrp.rt_qual_titl_flag ,
vrp.rt_dpnt_cvrd_pl_flag,
vrp.rt_dpnt_cvrd_plip_flag,
vrp.rt_dpnt_cvrd_ptip_flag,
vrp.rt_dpnt_cvrd_pgm_flag,
vrp.rt_enrld_oipl_flag,
vrp.rt_enrld_pl_flag,
vrp.rt_enrld_plip_flag,
vrp.rt_enrld_ptip_flag,
vrp.rt_enrld_pgm_flag,
vrp.rt_prtt_anthr_pl_flag,
vrp.rt_othr_ptip_flag,
vrp.rt_no_othr_cvg_flag,
vrp.rt_dpnt_othr_ptip_flag,
vrp.rt_qua_in_gr_flag,
vrp.rt_perf_rtng_flag,
vrp.asmt_to_use_cd,
bvr.ordr_num,
vrp.rt_elig_prfl_flag
from ben_vrbl_rt_prfl_f vrp,
ben_bnft_vrbl_rt_f bvr
where vrp.vrbl_rt_prfl_stat_cd = 'A'
and c_effective_date
between vrp.effective_start_date
and vrp.effective_end_date
and bvr.cvg_amt_calc_mthd_id = c_cvg_amt_calc_mthd_id
and vrp.vrbl_rt_prfl_id = bvr.vrbl_rt_prfl_id
and c_effective_date
between bvr.effective_start_date
and bvr.effective_end_date
order by bvr.ordr_num;
select vrp.vrbl_rt_prfl_id,
vrp.rt_hrly_slrd_flag,
vrp.rt_pstl_cd_flag,
vrp.rt_lbr_mmbr_flag,
vrp.rt_lgl_enty_flag,
vrp.rt_benfts_grp_flag,
vrp.rt_wk_loc_flag,
vrp.rt_brgng_unit_flag,
vrp.rt_age_flag,
vrp.rt_los_flag,
vrp.rt_per_typ_flag,
vrp.rt_fl_tm_pt_tm_flag,
vrp.rt_ee_stat_flag,
vrp.rt_grd_flag,
vrp.rt_pct_fl_tm_flag,
vrp.rt_asnt_set_flag,
vrp.rt_hrs_wkd_flag,
vrp.rt_comp_lvl_flag,
vrp.rt_org_unit_flag,
vrp.rt_loa_rsn_flag,
vrp.rt_pyrl_flag,
vrp.rt_schedd_hrs_flag,
vrp.rt_py_bss_flag,
vrp.rt_prfl_rl_flag,
vrp.rt_cmbn_age_los_flag,
vrp.rt_prtt_pl_flag,
vrp.rt_svc_area_flag,
vrp.rt_ppl_grp_flag,
vrp.rt_dsbld_flag,
vrp.rt_hlth_cvg_flag,
vrp.rt_poe_flag,
vrp.rt_ttl_cvg_vol_flag,
vrp.rt_ttl_prtt_flag,
vrp.rt_gndr_flag,
vrp.rt_tbco_use_flag,
vrp.rt_cntng_prtn_prfl_flag ,
vrp.rt_cbr_quald_bnf_flag,
vrp.rt_optd_mdcr_flag,
vrp.rt_lvg_rsn_flag ,
vrp.rt_pstn_flag ,
vrp.rt_comptncy_flag ,
vrp.rt_job_flag ,
vrp.rt_qual_titl_flag ,
vrp.rt_dpnt_cvrd_pl_flag,
vrp.rt_dpnt_cvrd_plip_flag,
vrp.rt_dpnt_cvrd_ptip_flag,
vrp.rt_dpnt_cvrd_pgm_flag,
vrp.rt_enrld_oipl_flag,
vrp.rt_enrld_pl_flag,
vrp.rt_enrld_plip_flag,
vrp.rt_enrld_ptip_flag,
vrp.rt_enrld_pgm_flag,
vrp.rt_prtt_anthr_pl_flag,
vrp.rt_othr_ptip_flag,
vrp.rt_no_othr_cvg_flag,
vrp.rt_dpnt_othr_ptip_flag,
vrp.rt_qua_in_gr_flag,
vrp.rt_perf_rtng_flag,
vrp.asmt_to_use_cd,
avr.ordr_num,
vrp.rt_elig_prfl_flag
from ben_acty_vrbl_rt_f avr,
ben_vrbl_rt_prfl_f vrp
where vrp.vrbl_rt_prfl_stat_cd = 'A'
and c_effective_date
between vrp.effective_start_date
and vrp.effective_end_date
and avr.acty_base_rt_id = c_acty_base_rt_id
and vrp.vrbl_rt_prfl_id = avr.vrbl_rt_prfl_id
and c_effective_date
between avr.effective_start_date
and avr.effective_end_date
order by avr.ordr_num;
select vrp.vrbl_rt_prfl_id,
vrp.rt_hrly_slrd_flag,
vrp.rt_pstl_cd_flag,
vrp.rt_lbr_mmbr_flag,
vrp.rt_lgl_enty_flag,
vrp.rt_benfts_grp_flag,
vrp.rt_wk_loc_flag,
vrp.rt_brgng_unit_flag,
vrp.rt_age_flag,
vrp.rt_los_flag,
vrp.rt_per_typ_flag,
vrp.rt_fl_tm_pt_tm_flag,
vrp.rt_ee_stat_flag,
vrp.rt_grd_flag,
vrp.rt_pct_fl_tm_flag,
vrp.rt_asnt_set_flag,
vrp.rt_hrs_wkd_flag,
vrp.rt_comp_lvl_flag,
vrp.rt_org_unit_flag,
vrp.rt_loa_rsn_flag,
vrp.rt_pyrl_flag,
vrp.rt_schedd_hrs_flag,
vrp.rt_py_bss_flag,
vrp.rt_prfl_rl_flag,
vrp.rt_cmbn_age_los_flag,
vrp.rt_prtt_pl_flag,
vrp.rt_svc_area_flag,
vrp.rt_ppl_grp_flag,
vrp.rt_dsbld_flag,
vrp.rt_hlth_cvg_flag,
vrp.rt_poe_flag,
vrp.rt_ttl_cvg_vol_flag,
vrp.rt_ttl_prtt_flag,
vrp.rt_gndr_flag,
vrp.rt_tbco_use_flag,
vrp.rt_cntng_prtn_prfl_flag ,
vrp.rt_cbr_quald_bnf_flag,
vrp.rt_optd_mdcr_flag,
vrp.rt_lvg_rsn_flag ,
vrp.rt_pstn_flag ,
vrp.rt_comptncy_flag ,
vrp.rt_job_flag ,
vrp.rt_qual_titl_flag ,
vrp.rt_dpnt_cvrd_pl_flag,
vrp.rt_dpnt_cvrd_plip_flag,
vrp.rt_dpnt_cvrd_ptip_flag,
vrp.rt_dpnt_cvrd_pgm_flag,
vrp.rt_enrld_oipl_flag,
vrp.rt_enrld_pl_flag,
vrp.rt_enrld_plip_flag,
vrp.rt_enrld_ptip_flag,
vrp.rt_enrld_pgm_flag,
vrp.rt_prtt_anthr_pl_flag,
vrp.rt_othr_ptip_flag,
vrp.rt_no_othr_cvg_flag,
vrp.rt_dpnt_othr_ptip_flag,
vrp.rt_qua_in_gr_flag,
vrp.rt_perf_rtng_flag,
vrp.asmt_to_use_cd,
apr.ordr_num,
vrp.rt_elig_prfl_flag
from ben_actl_prem_vrbl_rt_f apr,
ben_vrbl_rt_prfl_f vrp
where vrp.vrbl_rt_prfl_stat_cd = 'A'
and c_effective_date
between vrp.effective_start_date
and vrp.effective_end_date
and apr.actl_prem_id = c_actl_prem_id
and vrp.vrbl_rt_prfl_id = apr.vrbl_rt_prfl_id
and c_effective_date
between apr.effective_start_date
and apr.effective_end_date
order by apr.ordr_num;
g_copcep_odlookup.delete(l_hv);