The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT MAS1.PGM_ID,
MAS1.PTIP_ID,
MAS1.PLIP_ID,
MAS1.PL_ID,
MAS1.OIPL_ID
FROM BEN_PRTN_ELIG_F MAS1
WHERE MAS1.BUSINESS_GROUP_ID = c_business_group_id
AND c_effective_date
BETWEEN MAS1.EFFECTIVE_START_DATE AND MAS1.EFFECTIVE_END_DATE
and exists(select null
from ben_prtn_elig_prfl_f mas2
where mas1.prtn_elig_id = mas2.prtn_elig_id
AND c_effective_date
BETWEEN MAS2.EFFECTIVE_START_DATE AND MAS2.EFFECTIVE_END_DATE
)
ORDER BY MAS1.PGM_ID,
MAS1.PTIP_ID,
MAS1.PLIP_ID,
MAS1.PL_ID,
MAS1.OIPL_ID;
select tab1.pgm_id,
tab1.ptip_id,
tab1.plip_id,
tab1.pl_id,
tab1.oipl_id,
tab1.prtn_elig_id,
tab2.mndtry_flag,
tab3.eligy_prfl_id,
tab3.asmt_to_use_cd,
tab3.elig_enrld_plip_flag,
tab3.elig_cbr_quald_bnf_flag,
tab3.elig_enrld_ptip_flag,
tab3.elig_dpnt_cvrd_plip_flag,
tab3.elig_dpnt_cvrd_ptip_flag,
tab3.elig_dpnt_cvrd_pgm_flag,
tab3.elig_job_flag,
tab3.elig_hrly_slrd_flag,
tab3.elig_pstl_cd_flag,
tab3.elig_lbr_mmbr_flag,
tab3.elig_lgl_enty_flag,
tab3.elig_benfts_grp_flag,
tab3.elig_wk_loc_flag,
tab3.elig_brgng_unit_flag,
tab3.elig_age_flag,
tab3.elig_los_flag,
tab3.elig_per_typ_flag,
tab3.elig_fl_tm_pt_tm_flag,
tab3.elig_ee_stat_flag,
tab3.elig_grd_flag,
tab3.elig_pct_fl_tm_flag,
tab3.elig_asnt_set_flag,
tab3.elig_hrs_wkd_flag,
tab3.elig_comp_lvl_flag,
tab3.elig_org_unit_flag,
tab3.elig_loa_rsn_flag,
tab3.elig_pyrl_flag,
tab3.elig_schedd_hrs_flag,
tab3.elig_py_bss_flag,
tab3.eligy_prfl_rl_flag,
tab3.elig_cmbn_age_los_flag,
tab3.cntng_prtn_elig_prfl_flag,
tab3.elig_prtt_pl_flag,
tab3.elig_ppl_grp_flag,
tab3.elig_svc_area_flag,
tab3.elig_ptip_prte_flag,
tab3.elig_no_othr_cvg_flag,
tab3.elig_enrld_pl_flag,
tab3.elig_enrld_oipl_flag,
tab3.elig_enrld_pgm_flag,
tab3.elig_dpnt_cvrd_pl_flag,
tab3.elig_lvg_rsn_flag,
tab3.elig_optd_mdcr_flag,
tab3.elig_tbco_use_flag,
tab3.elig_dpnt_othr_ptip_flag,
tab3.ELIG_GNDR_FLAG,
tab3.ELIG_MRTL_STS_FLAG,
tab3.ELIG_DSBLTY_CTG_FLAG,
tab3.ELIG_DSBLTY_RSN_FLAG,
tab3.ELIG_DSBLTY_DGR_FLAG,
tab3.ELIG_SUPPL_ROLE_FLAG,
tab3.ELIG_QUAL_TITL_FLAG,
tab3.ELIG_PSTN_FLAG,
tab3.ELIG_PRBTN_PERD_FLAG,
tab3.ELIG_SP_CLNG_PRG_PT_FLAG,
tab3.BNFT_CAGR_PRTN_CD,
tab3.ELIG_DSBLD_FLAG,
tab3.ELIG_TTL_CVG_VOL_FLAG,
tab3.ELIG_TTL_PRTT_FLAG,
tab3.ELIG_COMPTNCY_FLAG,
tab3.ELIG_HLTH_CVG_FLAG,
tab3.ELIG_ANTHR_PL_FLAG
from ben_prtn_elig_f tab1,
ben_prtn_elig_prfl_f tab2,
ben_eligy_prfl_f tab3
where tab1.business_group_id = c_business_group_id
and tab1.prtn_elig_id = tab2.prtn_elig_id
and c_effective_date
between tab1.effective_start_date
and tab1.effective_end_date
and tab2.eligy_prfl_id = tab3.eligy_prfl_id
and c_effective_date
between tab2.effective_start_date
and tab2.effective_end_date
and c_effective_date
between tab3.effective_start_date
and tab3.effective_end_date
order by tab1.pgm_id,
tab1.ptip_id,
tab1.plip_id,
tab1.pl_id,
tab1.oipl_id,
decode(tab2.mndtry_flag,'Y',1,2);
select tab1.pgm_id,
tab1.ptip_id,
tab1.plip_id,
tab1.pl_id,
tab1.oipl_id,
tab1.prtn_elig_id,
tab2.mndtry_flag,
tab3.eligy_prfl_id,
tab3.asmt_to_use_cd,
tab3.elig_enrld_plip_flag,
tab3.elig_cbr_quald_bnf_flag,
tab3.elig_enrld_ptip_flag,
tab3.elig_dpnt_cvrd_plip_flag,
tab3.elig_dpnt_cvrd_ptip_flag,
tab3.elig_dpnt_cvrd_pgm_flag,
tab3.elig_job_flag,
tab3.elig_hrly_slrd_flag,
tab3.elig_pstl_cd_flag,
tab3.elig_lbr_mmbr_flag,
tab3.elig_lgl_enty_flag,
tab3.elig_benfts_grp_flag,
tab3.elig_wk_loc_flag,
tab3.elig_brgng_unit_flag,
tab3.elig_age_flag,
tab3.elig_los_flag,
tab3.elig_per_typ_flag,
tab3.elig_fl_tm_pt_tm_flag,
tab3.elig_ee_stat_flag,
tab3.elig_grd_flag,
tab3.elig_pct_fl_tm_flag,
tab3.elig_asnt_set_flag,
tab3.elig_hrs_wkd_flag,
tab3.elig_comp_lvl_flag,
tab3.elig_org_unit_flag,
tab3.elig_loa_rsn_flag,
tab3.elig_pyrl_flag,
tab3.elig_schedd_hrs_flag,
tab3.elig_py_bss_flag,
tab3.eligy_prfl_rl_flag,
tab3.elig_cmbn_age_los_flag,
tab3.cntng_prtn_elig_prfl_flag,
tab3.elig_prtt_pl_flag,
tab3.elig_ppl_grp_flag,
tab3.elig_svc_area_flag,
tab3.elig_ptip_prte_flag,
tab3.elig_no_othr_cvg_flag,
tab3.elig_enrld_pl_flag,
tab3.elig_enrld_oipl_flag,
tab3.elig_enrld_pgm_flag,
tab3.elig_dpnt_cvrd_pl_flag,
tab3.elig_lvg_rsn_flag,
tab3.elig_optd_mdcr_flag,
tab3.elig_tbco_use_flag,
tab3.elig_dpnt_othr_ptip_flag,
tab3.ELIG_DSBLD_FLAG,
tab3.ELIG_TTL_CVG_VOL_FLAG,
tab3.ELIG_TTL_PRTT_FLAG,
tab3.ELIG_COMPTNCY_FLAG,
tab3.ELIG_HLTH_CVG_FLAG,
tab3.ELIG_ANTHR_PL_FLAG
from ben_prtn_elig_f tab1,
ben_prtn_elig_prfl_f tab2,
ben_eligy_prfl_f tab3
where tab1.pgm_id = c_pgm_id
and tab1.prtn_elig_id = tab2.prtn_elig_id
and c_effective_date
between tab1.effective_start_date and tab1.effective_end_date
and tab2.eligy_prfl_id = tab3.eligy_prfl_id
and c_effective_date
between tab2.effective_start_date and tab2.effective_end_date
and c_effective_date
between tab3.effective_start_date and tab3.effective_end_date
order by tab1.pgm_id,
tab1.ptip_id,
tab1.plip_id,
tab1.pl_id,
tab1.oipl_id,
decode(tab2.mndtry_flag,'Y',1,2);
select tab1.pgm_id,
tab1.ptip_id,
tab1.plip_id,
tab1.pl_id,
tab1.oipl_id,
tab1.prtn_elig_id,
tab2.mndtry_flag,
tab3.eligy_prfl_id,
tab3.asmt_to_use_cd,
tab3.elig_enrld_plip_flag,
tab3.elig_cbr_quald_bnf_flag,
tab3.elig_enrld_ptip_flag,
tab3.elig_dpnt_cvrd_plip_flag,
tab3.elig_dpnt_cvrd_ptip_flag,
tab3.elig_dpnt_cvrd_pgm_flag,
tab3.elig_job_flag,
tab3.elig_hrly_slrd_flag,
tab3.elig_pstl_cd_flag,
tab3.elig_lbr_mmbr_flag,
tab3.elig_lgl_enty_flag,
tab3.elig_benfts_grp_flag,
tab3.elig_wk_loc_flag,
tab3.elig_brgng_unit_flag,
tab3.elig_age_flag,
tab3.elig_los_flag,
tab3.elig_per_typ_flag,
tab3.elig_fl_tm_pt_tm_flag,
tab3.elig_ee_stat_flag,
tab3.elig_grd_flag,
tab3.elig_pct_fl_tm_flag,
tab3.elig_asnt_set_flag,
tab3.elig_hrs_wkd_flag,
tab3.elig_comp_lvl_flag,
tab3.elig_org_unit_flag,
tab3.elig_loa_rsn_flag,
tab3.elig_pyrl_flag,
tab3.elig_schedd_hrs_flag,
tab3.elig_py_bss_flag,
tab3.eligy_prfl_rl_flag,
tab3.elig_cmbn_age_los_flag,
tab3.cntng_prtn_elig_prfl_flag,
tab3.elig_prtt_pl_flag,
tab3.elig_ppl_grp_flag,
tab3.elig_svc_area_flag,
tab3.elig_ptip_prte_flag,
tab3.elig_no_othr_cvg_flag,
tab3.elig_enrld_pl_flag,
tab3.elig_enrld_oipl_flag,
tab3.elig_enrld_pgm_flag,
tab3.elig_dpnt_cvrd_pl_flag,
tab3.elig_lvg_rsn_flag,
tab3.elig_optd_mdcr_flag,
tab3.elig_tbco_use_flag,
tab3.elig_dpnt_othr_ptip_flag,
tab3.ELIG_DSBLD_FLAG,
tab3.ELIG_TTL_CVG_VOL_FLAG,
tab3.ELIG_TTL_PRTT_FLAG,
tab3.ELIG_COMPTNCY_FLAG,
tab3.ELIG_HLTH_CVG_FLAG,
tab3.ELIG_ANTHR_PL_FLAG
from ben_prtn_elig_f tab1,
ben_prtn_elig_prfl_f tab2,
ben_eligy_prfl_f tab3
where tab1.ptip_id = c_ptip_id
and tab1.prtn_elig_id = tab2.prtn_elig_id
and c_effective_date
between tab1.effective_start_date and tab1.effective_end_date
and tab2.eligy_prfl_id = tab3.eligy_prfl_id
and c_effective_date
between tab2.effective_start_date and tab2.effective_end_date
and c_effective_date
between tab3.effective_start_date and tab3.effective_end_date
order by tab1.pgm_id,
tab1.ptip_id,
tab1.plip_id,
tab1.pl_id,
tab1.oipl_id,
decode(tab2.mndtry_flag,'Y',1,2);
select tab1.pgm_id,
tab1.ptip_id,
tab1.plip_id,
tab1.pl_id,
tab1.oipl_id,
tab1.prtn_elig_id,
tab2.mndtry_flag,
tab3.eligy_prfl_id,
tab3.asmt_to_use_cd,
tab3.elig_enrld_plip_flag,
tab3.elig_cbr_quald_bnf_flag,
tab3.elig_enrld_ptip_flag,
tab3.elig_dpnt_cvrd_plip_flag,
tab3.elig_dpnt_cvrd_ptip_flag,
tab3.elig_dpnt_cvrd_pgm_flag,
tab3.elig_job_flag,
tab3.elig_hrly_slrd_flag,
tab3.elig_pstl_cd_flag,
tab3.elig_lbr_mmbr_flag,
tab3.elig_lgl_enty_flag,
tab3.elig_benfts_grp_flag,
tab3.elig_wk_loc_flag,
tab3.elig_brgng_unit_flag,
tab3.elig_age_flag,
tab3.elig_los_flag,
tab3.elig_per_typ_flag,
tab3.elig_fl_tm_pt_tm_flag,
tab3.elig_ee_stat_flag,
tab3.elig_grd_flag,
tab3.elig_pct_fl_tm_flag,
tab3.elig_asnt_set_flag,
tab3.elig_hrs_wkd_flag,
tab3.elig_comp_lvl_flag,
tab3.elig_org_unit_flag,
tab3.elig_loa_rsn_flag,
tab3.elig_pyrl_flag,
tab3.elig_schedd_hrs_flag,
tab3.elig_py_bss_flag,
tab3.eligy_prfl_rl_flag,
tab3.elig_cmbn_age_los_flag,
tab3.cntng_prtn_elig_prfl_flag,
tab3.elig_prtt_pl_flag,
tab3.elig_ppl_grp_flag,
tab3.elig_svc_area_flag,
tab3.elig_ptip_prte_flag,
tab3.elig_no_othr_cvg_flag,
tab3.elig_enrld_pl_flag,
tab3.elig_enrld_oipl_flag,
tab3.elig_enrld_pgm_flag,
tab3.elig_dpnt_cvrd_pl_flag,
tab3.elig_lvg_rsn_flag,
tab3.elig_optd_mdcr_flag,
tab3.elig_tbco_use_flag,
tab3.elig_dpnt_othr_ptip_flag,
tab3.ELIG_DSBLD_FLAG,
tab3.ELIG_TTL_CVG_VOL_FLAG,
tab3.ELIG_TTL_PRTT_FLAG,
tab3.ELIG_COMPTNCY_FLAG,
tab3.ELIG_HLTH_CVG_FLAG,
tab3.ELIG_ANTHR_PL_FLAG
from ben_prtn_elig_f tab1,
ben_prtn_elig_prfl_f tab2,
ben_eligy_prfl_f tab3
where tab1.plip_id = c_plip_id
and tab1.prtn_elig_id = tab2.prtn_elig_id
and c_effective_date
between tab1.effective_start_date and tab1.effective_end_date
and tab2.eligy_prfl_id = tab3.eligy_prfl_id
and c_effective_date
between tab2.effective_start_date and tab2.effective_end_date
and c_effective_date
between tab3.effective_start_date and tab3.effective_end_date
order by tab1.pgm_id,
tab1.ptip_id,
tab1.plip_id,
tab1.pl_id,
tab1.oipl_id,
decode(tab2.mndtry_flag,'Y',1,2);
select tab1.pgm_id,
tab1.ptip_id,
tab1.plip_id,
tab1.pl_id,
tab1.oipl_id,
tab1.prtn_elig_id,
tab2.mndtry_flag,
tab3.eligy_prfl_id,
tab3.asmt_to_use_cd,
tab3.elig_enrld_plip_flag,
tab3.elig_cbr_quald_bnf_flag,
tab3.elig_enrld_ptip_flag,
tab3.elig_dpnt_cvrd_plip_flag,
tab3.elig_dpnt_cvrd_ptip_flag,
tab3.elig_dpnt_cvrd_pgm_flag,
tab3.elig_job_flag,
tab3.elig_hrly_slrd_flag,
tab3.elig_pstl_cd_flag,
tab3.elig_lbr_mmbr_flag,
tab3.elig_lgl_enty_flag,
tab3.elig_benfts_grp_flag,
tab3.elig_wk_loc_flag,
tab3.elig_brgng_unit_flag,
tab3.elig_age_flag,
tab3.elig_los_flag,
tab3.elig_per_typ_flag,
tab3.elig_fl_tm_pt_tm_flag,
tab3.elig_ee_stat_flag,
tab3.elig_grd_flag,
tab3.elig_pct_fl_tm_flag,
tab3.elig_asnt_set_flag,
tab3.elig_hrs_wkd_flag,
tab3.elig_comp_lvl_flag,
tab3.elig_org_unit_flag,
tab3.elig_loa_rsn_flag,
tab3.elig_pyrl_flag,
tab3.elig_schedd_hrs_flag,
tab3.elig_py_bss_flag,
tab3.eligy_prfl_rl_flag,
tab3.elig_cmbn_age_los_flag,
tab3.cntng_prtn_elig_prfl_flag,
tab3.elig_prtt_pl_flag,
tab3.elig_ppl_grp_flag,
tab3.elig_svc_area_flag,
tab3.elig_ptip_prte_flag,
tab3.elig_no_othr_cvg_flag,
tab3.elig_enrld_pl_flag,
tab3.elig_enrld_oipl_flag,
tab3.elig_enrld_pgm_flag,
tab3.elig_dpnt_cvrd_pl_flag,
tab3.elig_lvg_rsn_flag,
tab3.elig_optd_mdcr_flag,
tab3.elig_tbco_use_flag,
tab3.elig_dpnt_othr_ptip_flag,
tab3.ELIG_DSBLD_FLAG,
tab3.ELIG_TTL_CVG_VOL_FLAG,
tab3.ELIG_TTL_PRTT_FLAG,
tab3.ELIG_COMPTNCY_FLAG,
tab3.ELIG_HLTH_CVG_FLAG,
tab3.ELIG_ANTHR_PL_FLAG
from ben_prtn_elig_f tab1,
ben_prtn_elig_prfl_f tab2,
ben_eligy_prfl_f tab3
where tab1.pl_id = c_pl_id
and tab1.prtn_elig_id = tab2.prtn_elig_id
and c_effective_date
between tab1.effective_start_date and tab1.effective_end_date
and tab2.eligy_prfl_id = tab3.eligy_prfl_id
and c_effective_date
between tab2.effective_start_date and tab2.effective_end_date
and c_effective_date
between tab3.effective_start_date and tab3.effective_end_date
order by tab1.pgm_id,
tab1.ptip_id,
tab1.plip_id,
tab1.pl_id,
tab1.oipl_id,
decode(tab2.mndtry_flag,'Y',1,2);
select tab1.pgm_id,
tab1.ptip_id,
tab1.plip_id,
tab1.pl_id,
tab1.oipl_id,
tab1.prtn_elig_id,
tab2.mndtry_flag,
tab3.eligy_prfl_id,
tab3.asmt_to_use_cd,
tab3.elig_enrld_plip_flag,
tab3.elig_cbr_quald_bnf_flag,
tab3.elig_enrld_ptip_flag,
tab3.elig_dpnt_cvrd_plip_flag,
tab3.elig_dpnt_cvrd_ptip_flag,
tab3.elig_dpnt_cvrd_pgm_flag,
tab3.elig_job_flag,
tab3.elig_hrly_slrd_flag,
tab3.elig_pstl_cd_flag,
tab3.elig_lbr_mmbr_flag,
tab3.elig_lgl_enty_flag,
tab3.elig_benfts_grp_flag,
tab3.elig_wk_loc_flag,
tab3.elig_brgng_unit_flag,
tab3.elig_age_flag,
tab3.elig_los_flag,
tab3.elig_per_typ_flag,
tab3.elig_fl_tm_pt_tm_flag,
tab3.elig_ee_stat_flag,
tab3.elig_grd_flag,
tab3.elig_pct_fl_tm_flag,
tab3.elig_asnt_set_flag,
tab3.elig_hrs_wkd_flag,
tab3.elig_comp_lvl_flag,
tab3.elig_org_unit_flag,
tab3.elig_loa_rsn_flag,
tab3.elig_pyrl_flag,
tab3.elig_schedd_hrs_flag,
tab3.elig_py_bss_flag,
tab3.eligy_prfl_rl_flag,
tab3.elig_cmbn_age_los_flag,
tab3.cntng_prtn_elig_prfl_flag,
tab3.elig_prtt_pl_flag,
tab3.elig_ppl_grp_flag,
tab3.elig_svc_area_flag,
tab3.elig_ptip_prte_flag,
tab3.elig_no_othr_cvg_flag,
tab3.elig_enrld_pl_flag,
tab3.elig_enrld_oipl_flag,
tab3.elig_enrld_pgm_flag,
tab3.elig_dpnt_cvrd_pl_flag,
tab3.elig_lvg_rsn_flag,
tab3.elig_optd_mdcr_flag,
tab3.elig_tbco_use_flag,
tab3.elig_dpnt_othr_ptip_flag,
tab3.ELIG_DSBLD_FLAG,
tab3.ELIG_TTL_CVG_VOL_FLAG,
tab3.ELIG_TTL_PRTT_FLAG,
tab3.ELIG_COMPTNCY_FLAG,
tab3.ELIG_HLTH_CVG_FLAG,
tab3.ELIG_ANTHR_PL_FLAG
from ben_prtn_elig_f tab1,
ben_prtn_elig_prfl_f tab2,
ben_eligy_prfl_f tab3
where tab1.oipl_id = c_oipl_id
and tab1.prtn_elig_id = tab2.prtn_elig_id
and c_effective_date
between tab1.effective_start_date and tab1.effective_end_date
and tab2.eligy_prfl_id = tab3.eligy_prfl_id
and c_effective_date
between tab2.effective_start_date and tab2.effective_end_date
and c_effective_date
between tab3.effective_start_date and tab3.effective_end_date
order by tab1.pgm_id,
tab1.ptip_id,
tab1.plip_id,
tab1.pl_id,
tab1.oipl_id,
decode(tab2.mndtry_flag,'Y',1,2);
l_instcolnm_set(l_instcolnm_num).col_type := 'SELECT';
l_instcolnm_set(l_instcolnm_num).col_type := 'SELECT';
l_instcolnm_set(l_instcolnm_num).col_type := 'SELECT';
l_instcolnm_set(l_instcolnm_num).col_type := 'SELECT';
l_instcolnm_set(l_instcolnm_num).col_type := 'SELECT';
l_instcolnm_set(l_instcolnm_num).col_type := 'SELECT';
l_instcolnm_set(l_instcolnm_num).col_type := 'SELECT';
l_instcolnm_set(l_instcolnm_num).col_type := 'SELECT';
l_instcolnm_set(l_instcolnm_num).col_type := 'SELECT';
l_instcolnm_set(l_instcolnm_num).col_type := 'SELECT';
l_instcolnm_set(l_instcolnm_num).col_type := 'SELECT';
l_instcolnm_set(l_instcolnm_num).col_type := 'SELECT';
l_instcolnm_set(l_instcolnm_num).col_type := 'SELECT';
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_ppl_grp_prte_f epg
where p_effective_date
between epg.effective_start_date
and epg.effective_end_date
and epg.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select epg.eligy_prfl_id,
epg.elig_ppl_grp_prte_id pk_id,
'EPG' short_code,
epg.people_group_id,
epg.excld_flag,
epg.criteria_score,
epg.criteria_weight,
ppg.segment1 ,
ppg.segment2 ,
ppg.segment3 ,
ppg.segment4 ,
ppg.segment5 ,
ppg.segment6 ,
ppg.segment7 ,
ppg.segment8 ,
ppg.segment9 ,
ppg.segment10,
ppg.segment11,
ppg.segment12,
ppg.segment13,
ppg.segment14,
ppg.segment15,
ppg.segment16,
ppg.segment17,
ppg.segment18,
ppg.segment19,
ppg.segment20,
ppg.segment21,
ppg.segment22,
ppg.segment23,
ppg.segment24,
ppg.segment25,
ppg.segment26,
ppg.segment27,
ppg.segment28,
ppg.segment29,
ppg.segment30
from ben_elig_ppl_grp_prte_f epg
,pay_people_groups ppg
where p_effective_date
between epg.effective_start_date
and epg.effective_end_date
and epg.people_group_id = ppg.people_group_id
order by epg.eligy_prfl_id,
decode(epg.excld_flag,'Y',1,2),
epg.ordr_num;
g_cache_elpepg_lookup.delete;
g_cache_elpepg_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_per_typ_prte_f ept
where p_effective_date
between ept.effective_start_date
and ept.effective_end_date
and ept.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select ept.eligy_prfl_id,
ept.elig_per_typ_prte_id pk_id,
'EPT' short_code,
--ept.per_typ_cd,
ept.person_type_id,
ept.excld_flag,
ept.criteria_score,
ept.criteria_weight
from ben_elig_per_typ_prte_f ept
where p_effective_date
between ept.effective_start_date
and ept.effective_end_date
order by ept.eligy_prfl_id,
decode(ept.excld_flag,'Y',1,2),
ept.ordr_num;
g_cache_elpept_lookup.delete;
g_cache_elpept_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_asnt_set_prte_f ean
where p_effective_date
between ean.effective_start_date
and ean.effective_end_date
and ean.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select ean.eligy_prfl_id,
ean.elig_asnt_set_prte_id pk_id,
'EAN' short_code,
ass.formula_id,
ean.excld_flag,
ean.criteria_score,
ean.criteria_weight
from ben_elig_asnt_set_prte_f ean,
hr_assignment_sets ass
where p_effective_date
between ean.effective_start_date
and ean.effective_end_date
and ean.assignment_set_id = ass.assignment_set_id
order by ean.eligy_prfl_id,
decode(ean.excld_flag,'Y',1,2),
ean.ordr_num;
g_cache_elpean_lookup.delete;
g_cache_elpean_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_eligy_prfl_rl_f erl
where p_effective_date
between erl.effective_start_date
and erl.effective_end_date
and erl.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select erl.eligy_prfl_id,
erl.eligy_prfl_rl_id pk_id,
'ERL' short_code,
erl.formula_id,
erl.criteria_score,
erl.criteria_weight
from ben_eligy_prfl_rl_f erl
where p_effective_date
between erl.effective_start_date
and erl.effective_end_date
order by erl.eligy_prfl_id,
erl.ordr_to_aply_num;
g_cache_elperl_lookup.delete;
g_cache_elperl_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_ee_stat_prte_f ees
where p_effective_date
between ees.effective_start_date
and ees.effective_end_date
and ees.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select ees.eligy_prfl_id,
ees.elig_ee_stat_prte_id pk_id,
'EES' short_code,
ees.assignment_status_type_id,
ees.excld_flag,
ees.criteria_score,
ees.criteria_weight
from ben_elig_ee_stat_prte_f ees
where p_effective_date
between ees.effective_start_date
and ees.effective_end_date
order by ees.eligy_prfl_id,
decode(ees.excld_flag,'Y',1,2),
ees.ordr_num;
g_cache_elpees_lookup.delete;
g_cache_elpees_inst.delete;
select elp.eligy_prfl_id, elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists (select null
from ben_elig_svc_area_prte_f esa,
ben_svc_area_pstl_zip_rng_f saz,
ben_pstl_zip_rng_f rzr
where p_effective_date
between esa.effective_start_date
and esa.effective_end_date
and esa.svc_area_id = saz.svc_area_id
and esa.business_group_id = saz.business_group_id
and p_effective_date
between rzr.effective_start_date
and rzr.effective_end_date
and saz.pstl_zip_rng_id = rzr.pstl_zip_rng_id
and esa.business_group_id = rzr.business_group_id
and esa.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select esa.eligy_prfl_id,
esa.elig_svc_area_prte_id pk_id,
'ESA' short_code,
esa.excld_flag,
esa.criteria_score,
esa.criteria_weight,
rzr.from_value,
rzr.to_value
from ben_elig_svc_area_prte_f esa,
ben_svc_area_pstl_zip_rng_f saz,
ben_pstl_zip_rng_f rzr
where p_effective_date
between esa.effective_start_date
and esa.effective_end_date
and esa.svc_area_id = saz.svc_area_id
and esa.business_group_id = saz.business_group_id
and p_effective_date
between rzr.effective_start_date
and rzr.effective_end_date
and saz.pstl_zip_rng_id = rzr.pstl_zip_rng_id
and saz.business_group_id = rzr.business_group_id
order by esa.eligy_prfl_id,
decode(esa.excld_flag,'Y',1,2),
esa.ordr_num;
g_cache_elpesa_lookup.delete;
g_cache_elpesa_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_los_prte_f els,
ben_los_fctr lsf
where p_effective_date
between els.effective_start_date
and els.effective_end_date
and els.los_fctr_id = lsf.los_fctr_id
and els.business_group_id = lsf.business_group_id
and els.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select els.eligy_prfl_id,
els.elig_los_prte_id pk_id,
'ELS' short_code,
els.los_fctr_id,
els.excld_flag,
els.criteria_score,
els.criteria_weight,
lsf.mx_los_num,
lsf.mn_los_num,
lsf.no_mx_los_num_apls_flag,
lsf.no_mn_los_num_apls_flag
from ben_elig_los_prte_f els,
ben_los_fctr lsf
where p_effective_date
between els.effective_start_date
and els.effective_end_date
and els.los_fctr_id = lsf.los_fctr_id
and els.business_group_id = lsf.business_group_id
order by els.eligy_prfl_id,
decode(els.excld_flag,'Y',1,2),
els.ordr_num;
g_cache_elpels_lookup.delete;
g_cache_elpels_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_cmbn_age_los_prte_f ecp,
ben_cmbn_age_los_fctr cla
where ecp.cmbn_age_los_fctr_id = cla.cmbn_age_los_fctr_id
and ecp.business_group_id = cla.business_group_id
and p_effective_date
between ecp.effective_start_date
and ecp.effective_end_date
and ecp.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select ecp.eligy_prfl_id,
ecp.elig_cmbn_age_los_prte_id pk_id,
'ECP' short_code,
ecp.cmbn_age_los_fctr_id,
ecp.excld_flag,
ecp.criteria_score,
ecp.criteria_weight,
cla.cmbnd_min_val,
cla.cmbnd_max_val,
cla.los_fctr_id,
cla.age_fctr_id
from ben_elig_cmbn_age_los_prte_f ecp,
ben_cmbn_age_los_fctr cla
where ecp.cmbn_age_los_fctr_id = cla.cmbn_age_los_fctr_id
and ecp.business_group_id = cla.business_group_id
and p_effective_date
between ecp.effective_start_date
and ecp.effective_end_date
order by ecp.eligy_prfl_id,
decode(ecp.excld_flag,'Y',1,2),
ecp.ordr_num;
g_cache_elpecp_lookup.delete;
g_cache_elpecp_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_wk_loc_prte_f ewl
where p_effective_date
between ewl.effective_start_date
and ewl.effective_end_date
and ewl.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select ewl.eligy_prfl_id,
ewl.elig_wk_loc_prte_id pk_id,
'EWL' short_code,
ewl.location_id,
ewl.excld_flag,
ewl.criteria_score,
ewl.criteria_weight
from ben_elig_wk_loc_prte_f ewl
where p_effective_date
between ewl.effective_start_date
and ewl.effective_end_date
order by ewl.eligy_prfl_id,
decode(ewl.excld_flag,'Y',1,2),
ewl.ordr_num;
g_cache_elpewl_lookup.delete;
g_cache_elpewl_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_org_unit_prte_f eou
where p_effective_date
between eou.effective_start_date
and eou.effective_end_date
and eou.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select eou.eligy_prfl_id,
eou.elig_org_unit_prte_id pk_id,
'EOU' short_code,
eou.organization_id,
eou.excld_flag,
eou.criteria_score,
eou.criteria_weight
from ben_elig_org_unit_prte_f eou
where p_effective_date
between eou.effective_start_date
and eou.effective_end_date
order by eou.eligy_prfl_id,
decode(eou.excld_flag,'Y',1,2),
eou.ordr_num;
g_cache_elpeou_lookup.delete;
g_cache_elpeou_inst.delete;
select elp.eligy_prfl_id, elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_hrly_slrd_prte_f ehs
where p_effective_date
between ehs.effective_start_date
and ehs.effective_end_date
and ehs.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select ehs.eligy_prfl_id,
ehs.elig_hrly_slrd_prte_id pk_id,
'EHS' short_code,
ehs.hrly_slrd_cd,
ehs.excld_flag,
ehs.criteria_score,
ehs.criteria_weight
from ben_elig_hrly_slrd_prte_f ehs
where p_effective_date
between ehs.effective_start_date
and ehs.effective_end_date
order by ehs.eligy_prfl_id,
decode(ehs.excld_flag,'Y',1,2),
ehs.ordr_num;
g_cache_elpehs_lookup.delete;
g_cache_elpehs_inst.delete;
select elp.eligy_prfl_id, elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_fl_tm_pt_tm_prte_f efp
where p_effective_date
between efp.effective_start_date
and efp.effective_end_date
and efp.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select efp.eligy_prfl_id,
efp.elig_fl_tm_pt_tm_prte_id pk_id,
'EFP' short_code,
efp.fl_tm_pt_tm_cd,
efp.excld_flag,
efp.criteria_score,
efp.criteria_weight
from ben_elig_fl_tm_pt_tm_prte_f efp
where p_effective_date
between efp.effective_start_date
and efp.effective_end_date
order by efp.eligy_prfl_id,
decode(efp.excld_flag,'Y',1,2),
efp.ordr_num;
g_cache_elpefp_lookup.delete;
g_cache_elpefp_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_schedd_hrs_prte_f esh
where p_effective_date
between esh.effective_start_date
and esh.effective_end_date
and esh.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select esh.eligy_prfl_id,
esh.elig_schedd_hrs_prte_id pk_id,
'ESH' short_code,
esh.hrs_num,
esh.determination_cd,
esh.determination_rl,
esh.rounding_cd,
esh.rounding_rl,
esh.max_hrs_num,
esh.schedd_hrs_rl,
esh.freq_cd,
esh.excld_flag,
esh.criteria_score,
esh.criteria_weight
from ben_elig_schedd_hrs_prte_f esh
where p_effective_date
between esh.effective_start_date
and esh.effective_end_date
order by esh.eligy_prfl_id,
decode(esh.excld_flag,'Y',1,2),
esh.ordr_num;
g_cache_elpesh_lookup.delete;
g_cache_elpesh_inst.delete;
select elp.eligy_prfl_id, elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_hrs_wkd_prte_f ecl,
ben_hrs_wkd_in_perd_fctr clf
where ecl.hrs_wkd_in_perd_fctr_id =
clf.hrs_wkd_in_perd_fctr_id
and ecl.business_group_id = clf.business_group_id
and p_effective_date
between ecl.effective_start_date
and ecl.effective_end_date
and ecl.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select ecl.eligy_prfl_id,
ecl.elig_hrs_wkd_prte_id pk_id,
'EHW' short_code,
ecl.hrs_wkd_in_perd_fctr_id,
ecl.excld_flag,
ecl.criteria_score,
ecl.criteria_weight,
clf.mn_hrs_num,
clf.mx_hrs_num,
clf.no_mn_hrs_wkd_flag,
clf.no_mx_hrs_wkd_flag,
clf.hrs_src_cd
from ben_elig_hrs_wkd_prte_f ecl,
ben_hrs_wkd_in_perd_fctr clf
where ecl.hrs_wkd_in_perd_fctr_id = clf.hrs_wkd_in_perd_fctr_id
and ecl.business_group_id = clf.business_group_id
and p_effective_date
between ecl.effective_start_date
and ecl.effective_end_date
order by ecl.eligy_prfl_id,
decode(ecl.excld_flag,'Y',1,2),
ecl.ordr_num;
g_cache_elpehw_lookup.delete;
g_cache_elpehw_inst.delete;
select elp.eligy_prfl_id, elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_comp_lvl_prte_f ecl,
ben_comp_lvl_fctr clf
where ecl.comp_lvl_fctr_id = clf.comp_lvl_fctr_id
and ecl.business_group_id = clf.business_group_id
and p_effective_date
between ecl.effective_start_date
and ecl.effective_end_date
and ecl.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select ecl.eligy_prfl_id,
ecl.elig_comp_lvl_prte_id pk_id,
'ECL' short_code,
ecl.excld_flag,
ecl.criteria_score,
ecl.criteria_weight,
clf.mn_comp_val,
clf.mx_comp_val,
clf.no_mn_comp_flag,
clf.no_mx_comp_flag,
clf.comp_src_cd,
clf.comp_lvl_fctr_id
from ben_elig_comp_lvl_prte_f ecl,
ben_comp_lvl_fctr clf
where ecl.comp_lvl_fctr_id = clf.comp_lvl_fctr_id
and ecl.business_group_id = clf.business_group_id
and p_effective_date
between ecl.effective_start_date
and ecl.effective_end_date
order by ecl.eligy_prfl_id,
decode(ecl.excld_flag,'Y',1,2),
ecl.ordr_num;
g_cache_elpecl_lookup.delete;
g_cache_elpecl_inst.delete;
select epl.eligy_prfl_id,
epl.business_group_id
from ben_eligy_prfl_f epl
where p_effective_date
between epl.effective_start_date
and epl.effective_end_date
and exists(select null
from ben_elig_pct_fl_tm_prte_f epf,
ben_pct_fl_tm_fctr pff
where epf.pct_fl_tm_fctr_id = pff.pct_fl_tm_fctr_id
and epf.business_group_id = pff.business_group_id
and p_effective_date
between epf.effective_start_date
and epf.effective_end_date
and epf.eligy_prfl_id = epl.eligy_prfl_id)
order by epl.eligy_prfl_id;
select epf.eligy_prfl_id,
epf.elig_pct_fl_tm_prte_id pk_id,
'EPF' short_code,
epf.pct_fl_tm_fctr_id,
epf.excld_flag,
epf.criteria_score,
epf.criteria_weight,
pff.mx_pct_val,
pff.mn_pct_val,
pff.no_mn_pct_val_flag,
pff.no_mx_pct_val_flag
from ben_elig_pct_fl_tm_prte_f epf,
ben_pct_fl_tm_fctr pff
where epf.pct_fl_tm_fctr_id = pff.pct_fl_tm_fctr_id
and epf.business_group_id = pff.business_group_id
and p_effective_date
between epf.effective_start_date
and epf.effective_end_date
order by epf.eligy_prfl_id,
decode(epf.excld_flag,'Y',1,2),
epf.ordr_num;
g_cache_elpepf_lookup.delete;
g_cache_elpepf_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_grd_prte_f egr
where p_effective_date
between egr.effective_start_date
and egr.effective_end_date
and egr.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select egr.eligy_prfl_id,
egr.elig_grd_prte_id pk_id,
'EGR' short_code,
egr.grade_id,
egr.excld_flag,
egr.criteria_score,
egr.criteria_weight
from ben_elig_grd_prte_f egr
where p_effective_date
between egr.effective_start_date
and egr.effective_end_date
order by egr.eligy_prfl_id,
decode(egr.excld_flag,'Y',1,2),
egr.ordr_num;
g_cache_elpegr_lookup.delete;
g_cache_elpegr_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_grd_prte_f egn
where p_effective_date
between egn.effective_start_date
and egn.effective_end_date
and egn.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select egn.eligy_prfl_id,
egn.elig_gndr_prte_id pk_id,
'EGN' short_code,
egn.sex,
egn.excld_flag,
egn.criteria_score,
egn.criteria_weight
from ben_elig_gndr_prte_f egn
where p_effective_date
between egn.effective_start_date
and egn.effective_end_date
order by egn.eligy_prfl_id,
decode(egn.excld_flag,'Y',1,2),
egn.ordr_num;
g_cache_elpegn_lookup.delete;
g_cache_elpegn_inst.delete;
select elp.eligy_prfl_id, elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_job_prte_f ejp
where p_effective_date
between ejp.effective_start_date
and ejp.effective_end_date
and ejp.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select ejp.eligy_prfl_id,
ejp.elig_job_prte_id pk_id,
'EJP' short_code,
ejp.job_id,
ejp.excld_flag,
ejp.criteria_score,
ejp.criteria_weight
from ben_elig_job_prte_f ejp
where p_effective_date
between ejp.effective_start_date
and ejp.effective_end_date
order by ejp.eligy_prfl_id,
decode(ejp.excld_flag,'Y',1,2),
ejp.ordr_num;
g_cache_elpejp_lookup.delete;
g_cache_elpejp_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_py_bss_prte_f epb
where p_effective_date
between epb.effective_start_date
and epb.effective_end_date
and epb.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select epb.eligy_prfl_id,
epb.elig_py_bss_prte_id pk_id,
'EPB' short_code,
epb.pay_basis_id,
epb.excld_flag,
epb.criteria_score,
epb.criteria_weight
from ben_elig_py_bss_prte_f epb
where p_effective_date
between epb.effective_start_date
and epb.effective_end_date
order by epb.eligy_prfl_id,
decode(epb.excld_flag,'Y',1,2),
epb.ordr_num;
g_cache_elpepb_lookup.delete;
g_cache_elpepb_inst.delete;
select elp.eligy_prfl_id, elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_pyrl_prte_f epy
where p_effective_date
between epy.effective_start_date
and epy.effective_end_date
and epy.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select epy.eligy_prfl_id,
epy.elig_pyrl_prte_id pk_id,
'EPY' short_code,
epy.payroll_id,
epy.excld_flag,
epy.criteria_score,
epy.criteria_weight
from ben_elig_pyrl_prte_f epy
where p_effective_date
between epy.effective_start_date
and epy.effective_end_date
order by epy.eligy_prfl_id,
decode(epy.excld_flag,'Y',1,2),
epy.ordr_num;
g_cache_elpepy_lookup.delete;
g_cache_elpepy_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_brgng_unit_prte_f ebu
where p_effective_date
between ebu.effective_start_date
and ebu.effective_end_date
and ebu.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select ebu.eligy_prfl_id,
ebu.elig_brgng_unit_prte_id pk_id,
'EBU' short_code,
ebu.brgng_unit_cd,
ebu.excld_flag,
ebu.criteria_score,
ebu.criteria_weight
from ben_elig_brgng_unit_prte_f ebu
where p_effective_date
between ebu.effective_start_date
and ebu.effective_end_date
order by ebu.eligy_prfl_id,
decode(ebu.excld_flag,'Y',1,2),
ebu.ordr_num;
g_cache_elpebu_lookup.delete;
g_cache_elpebu_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_lbr_mmbr_prte_f elu
where p_effective_date
between elu.effective_start_date
and elu.effective_end_date
and elu.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select elu.eligy_prfl_id,
elu.elig_lbr_mmbr_prte_id pk_id,
'ELU' short_code,
elu.lbr_mmbr_flag,
elu.excld_flag,
elu.criteria_score,
elu.criteria_weight
from ben_elig_lbr_mmbr_prte_f elu
where p_effective_date
between elu.effective_start_date
and elu.effective_end_date
order by elu.eligy_prfl_id,
decode(elu.excld_flag,'Y',1,2),
elu.ordr_num;
g_cache_elpelu_lookup.delete;
g_cache_elpelu_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_loa_rsn_prte_f elr
where p_effective_date
between elr.effective_start_date
and elr.effective_end_date
and elr.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select elr.eligy_prfl_id,
elr.elig_loa_rsn_prte_id pk_id,
'ELR' short_code,
elr.absence_attendance_type_id,
elr.abs_attendance_reason_id,
elr.excld_flag,
elr.criteria_score,
elr.criteria_weight
from ben_elig_loa_rsn_prte_f elr
where p_effective_date
between elr.effective_start_date
and elr.effective_end_date
order by elr.eligy_prfl_id,
decode(elr.excld_flag,'Y',1,2),
elr.ordr_num;
g_cache_elpelr_lookup.delete;
g_cache_elpelr_inst.delete;
select elp.eligy_prfl_id, elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_age_prte_f eap,
ben_age_fctr agf
where eap.age_fctr_id = agf.age_fctr_id
and eap.business_group_id = agf.business_group_id
and p_effective_date
between eap.effective_start_date
and eap.effective_end_date
and eap.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select eap.eligy_prfl_id,
eap.elig_age_prte_id pk_id,
'EAP' short_code,
eap.age_fctr_id,
eap.excld_flag,
eap.criteria_score,
eap.criteria_weight,
agf.mx_age_num,
agf.mn_age_num,
agf.no_mn_age_flag,
agf.no_mx_age_flag
from ben_elig_age_prte_f eap,
ben_age_fctr agf
where eap.age_fctr_id = agf.age_fctr_id
and eap.business_group_id = agf.business_group_id
and p_effective_date
between eap.effective_start_date
and eap.effective_end_date
order by eap.eligy_prfl_id,
decode(eap.excld_flag,'Y',1,2),
eap.ordr_num;
g_cache_elpeap_lookup.delete;
g_cache_elpeap_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_pstl_cd_r_rng_prte_f epz,
ben_pstl_zip_rng_f rzr
where epz.pstl_zip_rng_id = rzr.pstl_zip_rng_id
and epz.business_group_id = rzr.business_group_id
and p_effective_date
between rzr.effective_start_date
and rzr.effective_end_date
and p_effective_date
between epz.effective_start_date
and epz.effective_end_date
and epz.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select epz.eligy_prfl_id,
epz.elig_pstl_cd_r_rng_prte_id pk_id,
'EPZ' short_code,
epz.excld_flag,
epz.criteria_score,
epz.criteria_weight,
rzr.from_value,
rzr.to_value
from ben_elig_pstl_cd_r_rng_prte_f epz,
ben_pstl_zip_rng_f rzr
where epz.pstl_zip_rng_id = rzr.pstl_zip_rng_id
and epz.business_group_id = rzr.business_group_id
and p_effective_date
between rzr.effective_start_date
and rzr.effective_end_date
and p_effective_date
between epz.effective_start_date
and epz.effective_end_date
order by epz.eligy_prfl_id,
decode(epz.excld_flag,'Y',1,2),
epz.ordr_num;
g_cache_elpepz_lookup.delete;
g_cache_elpepz_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_benfts_grp_prte_f ebn
where p_effective_date
between ebn.effective_start_date
and ebn.effective_end_date
and ebn.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select ebn.eligy_prfl_id,
ebn.elig_benfts_grp_prte_id pk_id,
'EBN' short_code,
ebn.benfts_grp_id,
ebn.excld_flag,
ebn.criteria_score,
ebn.criteria_weight
from ben_elig_benfts_grp_prte_f ebn
where p_effective_date
between ebn.effective_start_date
and ebn.effective_end_date
order by ebn.eligy_prfl_id,
decode(ebn.excld_flag,'Y',1,2),
ebn.ordr_num;
g_cache_elpebn_lookup.delete;
g_cache_elpebn_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_lgl_enty_prte_f eln,
hr_all_organization_units hao
where eln.organization_id = hao.organization_id
and eln.business_group_id = hao.business_group_id
and p_effective_date
between eln.effective_start_date
and eln.effective_end_date
and eln.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select eln.eligy_prfl_id,
eln.elig_lgl_enty_prte_id pk_id,
'ELN' short_code,
eln.excld_flag,
eln.criteria_score,
eln.criteria_weight,
hao.name
from ben_elig_lgl_enty_prte_f eln,
hr_all_organization_units hao
where eln.organization_id = hao.organization_id
and eln.business_group_id = hao.business_group_id
and p_effective_date
between eln.effective_start_date
and eln.effective_end_date
order by eln.eligy_prfl_id,
decode(eln.excld_flag,'Y',1,2),
eln.ordr_num;
g_cache_elpeln_lookup.delete;
g_cache_elpeln_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_prtt_anthr_pl_prte_f epp
where p_effective_date
between epp.effective_start_date
and epp.effective_end_date
and epp.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select epp.eligy_prfl_id,
epp.pl_id,
epp.excld_flag
from ben_elig_prtt_anthr_pl_prte_f epp
where p_effective_date
between epp.effective_start_date
and epp.effective_end_date
order by epp.eligy_prfl_id,
decode(epp.excld_flag,'Y',1,2),
epp.ordr_num;
g_cache_elpepp_lookup.delete;
g_cache_elpepp_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_othr_ptip_prte_f eoy
where p_effective_date
between eoy.effective_start_date
and eoy.effective_end_date
and eoy.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select eoy.eligy_prfl_id,
eoy.ptip_id,
eoy.only_pls_subj_cobra_flag,
eoy.excld_flag
from ben_elig_othr_ptip_prte_f eoy
where p_effective_date
between eoy.effective_start_date
and eoy.effective_end_date
order by eoy.eligy_prfl_id,
decode(eoy.excld_flag,'Y',1,2),
eoy.ordr_num;
g_cache_elpeoy_lookup.delete;
g_cache_elpeoy_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_dpnt_othr_ptip_f etd
where p_effective_date
between etd.effective_start_date
and etd.effective_end_date
and etd.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select etd.eligy_prfl_id,
etd.ptip_id,
--etd.only_pls_subj_cobra_flag,
etd.excld_flag
from ben_elig_dpnt_othr_ptip_f etd
where p_effective_date
between etd.effective_start_date
and etd.effective_end_date
order by etd.eligy_prfl_id,
decode(etd.excld_flag,'Y',1,2),
etd.ordr_num;
g_cache_elpetd_lookup.delete;
g_cache_elpetd_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_no_othr_cvg_prte_f eno
where p_effective_date
between eno.effective_start_date
and eno.effective_end_date
and eno.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select eno.eligy_prfl_id,
eno.coord_ben_no_cvg_flag
from ben_elig_no_othr_cvg_prte_f eno
where p_effective_date
between eno.effective_start_date
and eno.effective_end_date
order by eno.eligy_prfl_id;
g_cache_elpeno_lookup.delete;
g_cache_elpeno_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_enrld_anthr_pl_f eep
where p_effective_date
between eep.effective_start_date
and eep.effective_end_date
and eep.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select eep.eligy_prfl_id,
eep.pl_id,
eep.enrl_det_dt_cd,
eep.excld_flag
from ben_elig_enrld_anthr_pl_f eep
where p_effective_date
between eep.effective_start_date
and eep.effective_end_date
order by eep.eligy_prfl_id,
decode(eep.excld_flag,'Y',1,2),
eep.ordr_num;
g_cache_elpeep_lookup.delete;
g_cache_elpeep_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_enrld_anthr_oipl_f eei
where p_effective_date
between eei.effective_start_date
and eei.effective_end_date
and eei.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select eei.eligy_prfl_id,
eei.oipl_id,
eei.enrl_det_dt_cd,
eei.excld_flag
from ben_elig_enrld_anthr_oipl_f eei
where p_effective_date
between eei.effective_start_date
and eei.effective_end_date
order by eei.eligy_prfl_id,
decode(eei.excld_flag,'Y',1,2),
eei.ordr_num;
g_cache_elpeei_lookup.delete;
g_cache_elpeei_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_enrld_anthr_pgm_f eeg
where p_effective_date
between eeg.effective_start_date
and eeg.effective_end_date
and eeg.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select eeg.eligy_prfl_id,
eeg.pgm_id,
eeg.enrl_det_dt_cd,
eeg.excld_flag
from ben_elig_enrld_anthr_pgm_f eeg
where p_effective_date
between eeg.effective_start_date
and eeg.effective_end_date
order by eeg.eligy_prfl_id,
decode(eeg.excld_flag,'Y',1,2),
eeg.ordr_num;
g_cache_elpeeg_lookup.delete;
g_cache_elpeeg_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_dpnt_cvrd_othr_pl_f edp
where p_effective_date
between edp.effective_start_date
and edp.effective_end_date
and edp.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select edp.eligy_prfl_id,
edp.pl_id,
edp.cvg_det_dt_cd,
edp.excld_flag
from ben_elig_dpnt_cvrd_othr_pl_f edp
where p_effective_date
between edp.effective_start_date
and edp.effective_end_date
order by edp.eligy_prfl_id,
decode(edp.excld_flag,'Y',1,2),
edp.ordr_num;
g_cache_elpedp_lookup.delete;
g_cache_elpedp_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_lvg_rsn_prte_f elv
where p_effective_date
between elv.effective_start_date
and elv.effective_end_date
and elv.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select elv.eligy_prfl_id,
elv.elig_lvg_rsn_prte_id pk_id,
'ELV' short_code,
elv.lvg_rsn_cd,
elv.excld_flag,
elv.criteria_score,
elv.criteria_weight
from ben_elig_lvg_rsn_prte_f elv
where p_effective_date
between elv.effective_start_date
and elv.effective_end_date
order by elv.eligy_prfl_id,
decode(elv.excld_flag,'Y',1,2),
elv.ordr_num;
g_cache_elpelv_lookup.delete;
g_cache_elpelv_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_optd_mdcr_prte_f eom
where p_effective_date
between eom.effective_start_date
and eom.effective_end_date
and eom.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select eom.eligy_prfl_id,
eom.optd_mdcr_flag,
eom.exlcd_flag
from ben_elig_optd_mdcr_prte_f eom
where p_effective_date
between eom.effective_start_date
and eom.effective_end_date
order by eom.eligy_prfl_id,
decode(eom.exlcd_flag,'Y',1,2);
g_cache_elpeom_lookup.delete;
g_cache_elpeom_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_enrld_anthr_plip_f eai
where p_effective_date
between eai.effective_start_date
and eai.effective_end_date
and eai.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select eai.eligy_prfl_id,
eai.enrl_det_dt_cd,
eai.plip_id,
eai.excld_flag
from ben_elig_enrld_anthr_plip_f eai
where p_effective_date
between eai.effective_start_date
and eai.effective_end_date
order by eai.eligy_prfl_id,
decode(eai.excld_flag,'Y',1,2);
g_cache_elpeai_lookup.delete;
g_cache_elpeai_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_dpnt_cvrd_plip_f edi
where p_effective_date
between edi.effective_start_date
and edi.effective_end_date
and edi.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select edi.eligy_prfl_id,
edi.enrl_det_dt_cd,
edi.plip_id,
edi.excld_flag
from ben_elig_dpnt_cvrd_plip_f edi
where p_effective_date
between edi.effective_start_date
and edi.effective_end_date
order by edi.eligy_prfl_id,
decode(edi.excld_flag,'Y',1,2);
g_cache_elpedi_lookup.delete;
g_cache_elpedi_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_enrld_anthr_ptip_f eet
where p_effective_date
between eet.effective_start_date
and eet.effective_end_date
and eet.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select eet.eligy_prfl_id,
eet.excld_flag,
eet.enrl_det_dt_cd,
eet.only_pls_subj_cobra_flag,
eet.ptip_id
from ben_elig_enrld_anthr_ptip_f eet
where p_effective_date
between eet.effective_start_date
and eet.effective_end_date
order by eet.eligy_prfl_id,
decode(eet.excld_flag,'Y',1,2);
g_cache_elpeet_lookup.delete;
g_cache_elpeet_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_dpnt_cvrd_othr_ptip_f edt
where p_effective_date
between edt.effective_start_date
and edt.effective_end_date
and edt.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select edt.eligy_prfl_id,
edt.excld_flag,
edt.enrl_det_dt_cd,
edt.only_pls_subj_cobra_flag,
edt.ptip_id
from ben_elig_dpnt_cvrd_othr_ptip_f edt
where p_effective_date
between edt.effective_start_date
and edt.effective_end_date
order by edt.eligy_prfl_id,
decode(edt.excld_flag,'Y',1,2);
g_cache_elpedt_lookup.delete;
g_cache_elpedt_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_dpnt_cvrd_othr_pgm_f edg
where p_effective_date
between edg.effective_start_date
and edg.effective_end_date
and edg.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select edg.eligy_prfl_id,
edg.excld_flag,
edg.enrl_det_dt_cd,
edg.pgm_id
from ben_elig_dpnt_cvrd_othr_pgm_f edg
where p_effective_date
between edg.effective_start_date
and edg.effective_end_date
order by edg.eligy_prfl_id,
decode(edg.excld_flag,'Y',1,2);
g_cache_elpedg_lookup.delete;
g_cache_elpedg_inst.delete;
select elp.eligy_prfl_id,
elp.business_group_id
from ben_eligy_prfl_f elp
where p_effective_date
between elp.effective_start_date
and elp.effective_end_date
and exists(select null
from ben_elig_cbr_quald_bnf_f ecq
where p_effective_date
between ecq.effective_start_date
and ecq.effective_end_date
and ecq.eligy_prfl_id = elp.eligy_prfl_id)
order by elp.eligy_prfl_id;
select ecq.eligy_prfl_id,
ecq.elig_cbr_quald_bnf_id pk_id,
'ECQ' short_code,
ecq.quald_bnf_flag,
ecq.pgm_id, -- lamc added 2 fields
ecq.ptip_id,
ecq.criteria_score,
ecq.criteria_weight
from ben_elig_cbr_quald_bnf_f ecq
where p_effective_date
between ecq.effective_start_date
and ecq.effective_end_date
order by ecq.eligy_prfl_id;
g_cache_elpecq_lookup.delete;
g_cache_elpecq_inst.delete;
select tab.eligy_prfl_id,
tab.elig_dsbld_prte_id pk_id,
'EDB' short_code,
tab.dsbld_cd,
tab.excld_flag,
tab.criteria_score,
tab.criteria_weight
from ben_elig_dsbld_prte_f tab
where tab.eligy_prfl_id = c_eligy_prfl_id
and c_effective_date
between tab.effective_start_date and tab.effective_end_date
order by tab.eligy_prfl_id,
decode(tab.excld_flag,'Y',1,2);
select tab.eligy_prfl_id,
tab.elig_tbco_use_prte_id pk_id,
'ETU' short_code,
tab.uses_tbco_flag,
tab.excld_flag,
tab.criteria_score,
tab.criteria_weight
from ben_elig_tbco_use_prte_f tab
where tab.eligy_prfl_id = c_eligy_prfl_id
and c_effective_date
between tab.effective_start_date and tab.effective_end_date
order by tab.eligy_prfl_id,
decode(tab.excld_flag,'Y',1,2);
select etc.eligy_prfl_id
, etc.mn_cvg_vol_amt
, etc.mx_cvg_vol_amt
, etc.no_mn_cvg_vol_amt_apls_flag
, etc.no_mx_cvg_vol_amt_apls_flag
from ben_elig_ttl_cvg_vol_prte_f etc
where etc.eligy_prfl_id = c_eligy_prfl_id
and c_effective_date
between etc.effective_start_date and etc.effective_end_date
order by etc.eligy_prfl_id;
select etp.eligy_prfl_id
, etp.mn_prtt_num
, etp.mx_prtt_num
, etp.no_mn_prtt_num_apls_flag
, etp.no_mx_prtt_num_apls_flag
from ben_elig_ttl_prtt_prte_f etp
where etp.eligy_prfl_id = c_eligy_prfl_id
and c_effective_date
between etp.effective_start_date and etp.effective_end_date
order by etp.eligy_prfl_id;
select tab.eligy_prfl_id,
tab.pl_id,
tab.excld_flag
from ben_elig_anthr_pl_prte_f tab
where tab.eligy_prfl_id = c_eligy_prfl_id
and c_effective_date
between tab.effective_start_date and tab.effective_end_date
order by tab.eligy_prfl_id,
decode(tab.excld_flag,'Y',1,2);
select tab.eligy_prfl_id,
tab.pl_typ_opt_typ_id,
tab.oipl_id,
tab.excld_flag
from ben_elig_hlth_cvg_prte_f tab
where tab.eligy_prfl_id = c_eligy_prfl_id
and c_effective_date
between tab.effective_start_date and tab.effective_end_date
order by tab.eligy_prfl_id,
decode(tab.excld_flag,'Y',1,2);
select tab.eligy_prfl_id,
tab.elig_comptncy_prte_id pk_id,
'ECY' short_code,
tab.competence_id,
tab.rating_level_id,
tab.excld_flag,
tab.criteria_score,
tab.criteria_weight
from ben_elig_comptncy_prte_f tab
where tab.eligy_prfl_id = c_eligy_prfl_id
and c_effective_date
between tab.effective_start_date and tab.effective_end_date
order by tab.eligy_prfl_id,
decode(tab.excld_flag,'Y',1,2);
select tab.eligy_prfl_id,
tab.elig_qua_in_gr_prte_id pk_id,
'EQG' short_code,
tab.quar_in_grade_cd,
tab.excld_flag,
tab.criteria_score,
tab.criteria_weight
from ben_elig_qua_in_gr_prte_f tab
where tab.eligy_prfl_id = c_eligy_prfl_id
and c_effective_date
between tab.effective_start_date and tab.effective_end_date
order by tab.eligy_prfl_id,
decode(tab.excld_flag,'Y',1,2);
select tab.eligy_prfl_id,
tab.elig_perf_rtng_prte_id pk_id,
'ERG' short_code,
tab.perf_rtng_cd,
tab.event_type,
tab.excld_flag,
tab.criteria_score,
tab.criteria_weight
from ben_elig_perf_rtng_prte_f tab
where tab.eligy_prfl_id = c_eligy_prfl_id
and c_effective_date
between tab.effective_start_date and tab.effective_end_date
order by tab.eligy_prfl_id,
decode(tab.excld_flag,'Y',1,2);
g_copcep_odlookup.delete;
g_copcep_odinst.delete;
g_cobcep_lookup.delete;
g_cobcep_inst.delete;
g_elpept_lookup.delete;
g_elpept_inst.delete;
g_elpees_lookup.delete;
g_elpees_inst.delete;
g_elpesa_lookup.delete;
g_elpesa_inst.delete;
g_elpehs_lookup.delete;
g_elpehs_inst.delete;
g_elpels_lookup.delete;
g_elpels_inst.delete;
g_elpecp_lookup.delete;
g_elpecp_inst.delete;
g_cache_elpept_lookup.delete;
g_cache_elpept_inst.delete;
g_cache_elpepg_lookup.delete;
g_cache_elpepg_inst.delete;
g_cache_elpees_lookup.delete;
g_cache_elpees_inst.delete;
g_cache_elpels_lookup.delete;
g_cache_elpels_inst.delete;
g_cache_elpecp_lookup.delete;
g_cache_elpecp_inst.delete;
g_cache_elpewl_lookup.delete;
g_cache_elpewl_inst.delete;
g_cache_elpeou_lookup.delete;
g_cache_elpeou_inst.delete;
g_cache_elpehs_lookup.delete;
g_cache_elpehs_inst.delete;
g_cache_elpefp_lookup.delete;
g_cache_elpefp_inst.delete;
g_cache_elpesh_lookup.delete;
g_cache_elpesh_inst.delete;
g_cache_elpecl_lookup.delete;
g_cache_elpecl_inst.delete;
g_cache_elpehw_lookup.delete;
g_cache_elpehw_inst.delete;
g_cache_elpepf_lookup.delete;
g_cache_elpepf_inst.delete;
g_cache_elpegr_lookup.delete;
g_cache_elpegr_inst.delete;
g_cache_elpejp_lookup.delete;
g_cache_elpejp_inst.delete;
g_cache_elpepb_lookup.delete;
g_cache_elpepb_inst.delete;
g_cache_elpepy_lookup.delete;
g_cache_elpepy_inst.delete;
g_cache_elpebu_lookup.delete;
g_cache_elpebu_inst.delete;
g_cache_elpelu_lookup.delete;
g_cache_elpelu_inst.delete;
g_cache_elpelr_lookup.delete;
g_cache_elpelr_inst.delete;
g_cache_elpeap_lookup.delete;
g_cache_elpeap_inst.delete;
g_cache_elpepz_lookup.delete;
g_cache_elpepz_inst.delete;
g_cache_elpebn_lookup.delete;
g_cache_elpebn_inst.delete;
g_cache_elpeln_lookup.delete;
g_cache_elpeln_inst.delete;
g_cache_elpepp_lookup.delete;
g_cache_elpepp_inst.delete;
g_cache_elpesa_lookup.delete;
g_cache_elpesa_inst.delete;
g_cache_elpeoy_lookup.delete;
g_cache_elpeoy_inst.delete;
g_cache_elpetd_lookup.delete;
g_cache_elpetd_inst.delete;
g_cache_elpeno_lookup.delete;
g_cache_elpeno_inst.delete;
g_cache_elpeep_lookup.delete;
g_cache_elpeep_inst.delete;
g_cache_elpeei_lookup.delete;
g_cache_elpeei_inst.delete;
g_cache_elpeeg_lookup.delete;
g_cache_elpeeg_inst.delete;
g_cache_elpedp_lookup.delete;
g_cache_elpedp_inst.delete;
g_cache_elpelv_lookup.delete;
g_cache_elpelv_inst.delete;
g_cache_elpeom_lookup.delete;
g_cache_elpeom_inst.delete;
g_cache_elpeai_lookup.delete;
g_cache_elpeai_inst.delete;
g_cache_elpedi_lookup.delete;
g_cache_elpedi_inst.delete;
g_cache_elpeet_lookup.delete;
g_cache_elpeet_inst.delete;
g_cache_elpedt_lookup.delete;
g_cache_elpedt_inst.delete;
g_cache_elpedg_lookup.delete;
g_cache_elpedg_inst.delete;
g_cache_elpecq_lookup.delete;
g_cache_elpecq_inst.delete;