[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select /*+ bencepch.write_cobcep_odcache.c_pgminstance */
tab1.pgm_id,
tab1.ptip_id,
tab1.plip_id,
tab1.pl_id,
tab1.oipl_id,
-- Grade/Step
to_number(null) vrbl_rt_prfl_id,
-- Grade/Step
tab1.prtn_elig_id,
tab1.trk_scr_for_inelg_flag,
tab2.compute_score_flag,
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,
tab3.elig_qua_in_gr_flag,
tab3.elig_perf_rtng_flag,
tab3.elig_crit_values_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 tab3.stat_cd = 'A' -- bug 2431753 -- consider only active profiles
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 /*+ bencepch.write_cobcep_odcache.c_ptipinstance */
tab1.pgm_id,
tab1.ptip_id,
tab1.plip_id,
tab1.pl_id,
tab1.oipl_id,
-- Grade/Step
null vrbl_rt_prfl_id,
-- Grade/Step
tab1.prtn_elig_id,
tab1.trk_scr_for_inelg_flag,
tab2.compute_score_flag,
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,
tab3.elig_qua_in_gr_flag,
tab3.elig_perf_rtng_flag,
tab3.elig_crit_values_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 tab3.stat_cd = 'A' -- bug 2431753 -- consider only active profiles
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 /*+ bencepch.write_cobcep_odcache.c_plipinstance */
tab1.pgm_id,
tab1.ptip_id,
tab1.plip_id,
tab1.pl_id,
tab1.oipl_id,
-- Grade/Step
null vrbl_rt_prfl_id,
-- Grade/Step
tab1.prtn_elig_id,
tab1.trk_scr_for_inelg_flag,
tab2.compute_score_flag,
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,
tab3.elig_qua_in_gr_flag,
tab3.elig_perf_rtng_flag,
tab3.elig_crit_values_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 tab3.stat_cd = 'A' -- bug 2431753 -- consider only active profiles
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 /*+ bencepch.write_cobcep_odcache.c_plinstance */
tab1.pgm_id,
tab1.ptip_id,
tab1.plip_id,
tab1.pl_id,
tab1.oipl_id,
-- Grade/Step
null vrbl_rt_prfl_id,
-- Grade/Step
tab1.prtn_elig_id,
tab1.trk_scr_for_inelg_flag,
tab2.compute_score_flag,
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,
tab3.elig_qua_in_gr_flag,
tab3.elig_perf_rtng_flag,
tab3.elig_crit_values_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 tab3.stat_cd = 'A' -- bug 2431753 -- consider only active profiles
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 /*+ bencepch.write_cobcep_odcache.c_oiplinstance */
tab1.pgm_id,
tab1.ptip_id,
tab1.plip_id,
tab1.pl_id,
tab1.oipl_id,
-- Grade/Step
null vrbl_rt_prfl_id,
-- Grade/Step
tab1.prtn_elig_id,
tab1.trk_scr_for_inelg_flag,
tab2.compute_score_flag,
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,
tab3.elig_qua_in_gr_flag,
tab3.elig_perf_rtng_flag,
tab3.elig_crit_values_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 tab3.stat_cd = 'A' -- bug 2431753 -- consider only active profiles
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 /*+ bencepch.write_cobcep_odcache.c_vpfinstance */
null pgm_id,
null ptip_id,
null plip_id,
null pl_id,
null oipl_id,
tab1.vrbl_rt_prfl_id, -- 9999 Needs to be added as null to other cursors
null prtn_elig_id, -- Modified 9999 check how it is used?
'N' trk_scr_for_inelg_flag,
'N' compute_score_flag,
tab2.mndtry_flag, -- comes from ben_vrbl_rt_eligy_prfl_f
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,
tab3.elig_qua_in_gr_flag,
tab3.elig_perf_rtng_flag,
tab3.elig_crit_values_flag
from ben_vrbl_rt_prfl_f tab1,
ben_vrbl_rt_elig_prfl_f tab2,
ben_eligy_prfl_f tab3
where tab1.vrbl_rt_prfl_id = c_vrbl_rt_prfl_id
and tab1.vrbl_rt_prfl_id = tab2.vrbl_rt_prfl_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 tab3.stat_cd = 'A'
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 1, -- tab1.pgm_id, -- 9999 Add similar kind of order by clause to other cursors
2, -- tab1.ptip_id,
3, -- tab1.plip_id,
4, -- tab1.pl_id,
5, -- tab1.oipl_id,
6, -- tab1.vrbl_rt_prfl_id,
decode(tab2.mndtry_flag,'Y',1,2);
ben_cep_cache.g_copcep_odlookup.delete(l_hv);