2305: --
2306: --
2307: -- Check if the epe context global is set
2308: --
2309: elsif ben_epe_cache.g_currepe_row.elig_per_elctbl_chc_id is not null
2310: then
2311: --
2312: l_elig_per_elctbl_chc_id := ben_epe_cache.g_currepe_row.elig_per_elctbl_chc_id;
2313: l_acty_ref_perd_cd := ben_epe_cache.g_currepe_row.acty_ref_perd_cd;
2308: --
2309: elsif ben_epe_cache.g_currepe_row.elig_per_elctbl_chc_id is not null
2310: then
2311: --
2312: l_elig_per_elctbl_chc_id := ben_epe_cache.g_currepe_row.elig_per_elctbl_chc_id;
2313: l_acty_ref_perd_cd := ben_epe_cache.g_currepe_row.acty_ref_perd_cd;
2314: l_start_date := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt;
2315: l_start_date_cd := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_cd;
2316: l_start_date_rl := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_rl;
2309: elsif ben_epe_cache.g_currepe_row.elig_per_elctbl_chc_id is not null
2310: then
2311: --
2312: l_elig_per_elctbl_chc_id := ben_epe_cache.g_currepe_row.elig_per_elctbl_chc_id;
2313: l_acty_ref_perd_cd := ben_epe_cache.g_currepe_row.acty_ref_perd_cd;
2314: l_start_date := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt;
2315: l_start_date_cd := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_cd;
2316: l_start_date_rl := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_rl;
2317: l_enrt_perd_start_dt := ben_epe_cache.g_currepe_row.enrt_perd_strt_dt;
2310: then
2311: --
2312: l_elig_per_elctbl_chc_id := ben_epe_cache.g_currepe_row.elig_per_elctbl_chc_id;
2313: l_acty_ref_perd_cd := ben_epe_cache.g_currepe_row.acty_ref_perd_cd;
2314: l_start_date := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt;
2315: l_start_date_cd := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_cd;
2316: l_start_date_rl := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_rl;
2317: l_enrt_perd_start_dt := ben_epe_cache.g_currepe_row.enrt_perd_strt_dt;
2318: l_yr_perd_id := ben_epe_cache.g_currepe_row.yr_perd_id;
2311: --
2312: l_elig_per_elctbl_chc_id := ben_epe_cache.g_currepe_row.elig_per_elctbl_chc_id;
2313: l_acty_ref_perd_cd := ben_epe_cache.g_currepe_row.acty_ref_perd_cd;
2314: l_start_date := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt;
2315: l_start_date_cd := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_cd;
2316: l_start_date_rl := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_rl;
2317: l_enrt_perd_start_dt := ben_epe_cache.g_currepe_row.enrt_perd_strt_dt;
2318: l_yr_perd_id := ben_epe_cache.g_currepe_row.yr_perd_id;
2319: --
2312: l_elig_per_elctbl_chc_id := ben_epe_cache.g_currepe_row.elig_per_elctbl_chc_id;
2313: l_acty_ref_perd_cd := ben_epe_cache.g_currepe_row.acty_ref_perd_cd;
2314: l_start_date := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt;
2315: l_start_date_cd := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_cd;
2316: l_start_date_rl := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_rl;
2317: l_enrt_perd_start_dt := ben_epe_cache.g_currepe_row.enrt_perd_strt_dt;
2318: l_yr_perd_id := ben_epe_cache.g_currepe_row.yr_perd_id;
2319: --
2320: l_per_in_ler_id := ben_epe_cache.g_currepe_row.per_in_ler_id;
2313: l_acty_ref_perd_cd := ben_epe_cache.g_currepe_row.acty_ref_perd_cd;
2314: l_start_date := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt;
2315: l_start_date_cd := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_cd;
2316: l_start_date_rl := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_rl;
2317: l_enrt_perd_start_dt := ben_epe_cache.g_currepe_row.enrt_perd_strt_dt;
2318: l_yr_perd_id := ben_epe_cache.g_currepe_row.yr_perd_id;
2319: --
2320: l_per_in_ler_id := ben_epe_cache.g_currepe_row.per_in_ler_id;
2321: l_pgm_id := ben_epe_cache.g_currepe_row.pgm_id;
2314: l_start_date := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt;
2315: l_start_date_cd := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_cd;
2316: l_start_date_rl := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_rl;
2317: l_enrt_perd_start_dt := ben_epe_cache.g_currepe_row.enrt_perd_strt_dt;
2318: l_yr_perd_id := ben_epe_cache.g_currepe_row.yr_perd_id;
2319: --
2320: l_per_in_ler_id := ben_epe_cache.g_currepe_row.per_in_ler_id;
2321: l_pgm_id := ben_epe_cache.g_currepe_row.pgm_id;
2322: l_pl_id := ben_epe_cache.g_currepe_row.pl_id;
2316: l_start_date_rl := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_rl;
2317: l_enrt_perd_start_dt := ben_epe_cache.g_currepe_row.enrt_perd_strt_dt;
2318: l_yr_perd_id := ben_epe_cache.g_currepe_row.yr_perd_id;
2319: --
2320: l_per_in_ler_id := ben_epe_cache.g_currepe_row.per_in_ler_id;
2321: l_pgm_id := ben_epe_cache.g_currepe_row.pgm_id;
2322: l_pl_id := ben_epe_cache.g_currepe_row.pl_id;
2323: l_oipl_id := ben_epe_cache.g_currepe_row.oipl_id;
2324: l_lee_rsn_id := ben_epe_cache.g_currepe_row.lee_rsn_id;
2317: l_enrt_perd_start_dt := ben_epe_cache.g_currepe_row.enrt_perd_strt_dt;
2318: l_yr_perd_id := ben_epe_cache.g_currepe_row.yr_perd_id;
2319: --
2320: l_per_in_ler_id := ben_epe_cache.g_currepe_row.per_in_ler_id;
2321: l_pgm_id := ben_epe_cache.g_currepe_row.pgm_id;
2322: l_pl_id := ben_epe_cache.g_currepe_row.pl_id;
2323: l_oipl_id := ben_epe_cache.g_currepe_row.oipl_id;
2324: l_lee_rsn_id := ben_epe_cache.g_currepe_row.lee_rsn_id;
2325: l_enrt_perd_id := ben_epe_cache.g_currepe_row.enrt_perd_id;
2318: l_yr_perd_id := ben_epe_cache.g_currepe_row.yr_perd_id;
2319: --
2320: l_per_in_ler_id := ben_epe_cache.g_currepe_row.per_in_ler_id;
2321: l_pgm_id := ben_epe_cache.g_currepe_row.pgm_id;
2322: l_pl_id := ben_epe_cache.g_currepe_row.pl_id;
2323: l_oipl_id := ben_epe_cache.g_currepe_row.oipl_id;
2324: l_lee_rsn_id := ben_epe_cache.g_currepe_row.lee_rsn_id;
2325: l_enrt_perd_id := ben_epe_cache.g_currepe_row.enrt_perd_id;
2326: l_person_id := ben_epe_cache.g_currepe_row.person_id;
2319: --
2320: l_per_in_ler_id := ben_epe_cache.g_currepe_row.per_in_ler_id;
2321: l_pgm_id := ben_epe_cache.g_currepe_row.pgm_id;
2322: l_pl_id := ben_epe_cache.g_currepe_row.pl_id;
2323: l_oipl_id := ben_epe_cache.g_currepe_row.oipl_id;
2324: l_lee_rsn_id := ben_epe_cache.g_currepe_row.lee_rsn_id;
2325: l_enrt_perd_id := ben_epe_cache.g_currepe_row.enrt_perd_id;
2326: l_person_id := ben_epe_cache.g_currepe_row.person_id;
2327: l_lf_evt_ocrd_dt := ben_epe_cache.g_currepe_row.lf_evt_ocrd_dt;
2320: l_per_in_ler_id := ben_epe_cache.g_currepe_row.per_in_ler_id;
2321: l_pgm_id := ben_epe_cache.g_currepe_row.pgm_id;
2322: l_pl_id := ben_epe_cache.g_currepe_row.pl_id;
2323: l_oipl_id := ben_epe_cache.g_currepe_row.oipl_id;
2324: l_lee_rsn_id := ben_epe_cache.g_currepe_row.lee_rsn_id;
2325: l_enrt_perd_id := ben_epe_cache.g_currepe_row.enrt_perd_id;
2326: l_person_id := ben_epe_cache.g_currepe_row.person_id;
2327: l_lf_evt_ocrd_dt := ben_epe_cache.g_currepe_row.lf_evt_ocrd_dt;
2328: --
2321: l_pgm_id := ben_epe_cache.g_currepe_row.pgm_id;
2322: l_pl_id := ben_epe_cache.g_currepe_row.pl_id;
2323: l_oipl_id := ben_epe_cache.g_currepe_row.oipl_id;
2324: l_lee_rsn_id := ben_epe_cache.g_currepe_row.lee_rsn_id;
2325: l_enrt_perd_id := ben_epe_cache.g_currepe_row.enrt_perd_id;
2326: l_person_id := ben_epe_cache.g_currepe_row.person_id;
2327: l_lf_evt_ocrd_dt := ben_epe_cache.g_currepe_row.lf_evt_ocrd_dt;
2328: --
2329: elsif p_elig_per_elctbl_chc_id is not null then
2322: l_pl_id := ben_epe_cache.g_currepe_row.pl_id;
2323: l_oipl_id := ben_epe_cache.g_currepe_row.oipl_id;
2324: l_lee_rsn_id := ben_epe_cache.g_currepe_row.lee_rsn_id;
2325: l_enrt_perd_id := ben_epe_cache.g_currepe_row.enrt_perd_id;
2326: l_person_id := ben_epe_cache.g_currepe_row.person_id;
2327: l_lf_evt_ocrd_dt := ben_epe_cache.g_currepe_row.lf_evt_ocrd_dt;
2328: --
2329: elsif p_elig_per_elctbl_chc_id is not null then
2330: --
2323: l_oipl_id := ben_epe_cache.g_currepe_row.oipl_id;
2324: l_lee_rsn_id := ben_epe_cache.g_currepe_row.lee_rsn_id;
2325: l_enrt_perd_id := ben_epe_cache.g_currepe_row.enrt_perd_id;
2326: l_person_id := ben_epe_cache.g_currepe_row.person_id;
2327: l_lf_evt_ocrd_dt := ben_epe_cache.g_currepe_row.lf_evt_ocrd_dt;
2328: --
2329: elsif p_elig_per_elctbl_chc_id is not null then
2330: --
2331: open c_epe;