2430: --
2431: --
2432: -- Check if the epe context global is set
2433: --
2434: elsif ben_epe_cache.g_currepe_row.elig_per_elctbl_chc_id is not null
2435: then
2436: --
2437: l_elig_per_elctbl_chc_id := ben_epe_cache.g_currepe_row.elig_per_elctbl_chc_id;
2438: l_acty_ref_perd_cd := ben_epe_cache.g_currepe_row.acty_ref_perd_cd;
2433: --
2434: elsif ben_epe_cache.g_currepe_row.elig_per_elctbl_chc_id is not null
2435: then
2436: --
2437: l_elig_per_elctbl_chc_id := ben_epe_cache.g_currepe_row.elig_per_elctbl_chc_id;
2438: l_acty_ref_perd_cd := ben_epe_cache.g_currepe_row.acty_ref_perd_cd;
2439: l_start_date := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt;
2440: l_start_date_cd := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_cd;
2441: l_start_date_rl := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_rl;
2434: elsif ben_epe_cache.g_currepe_row.elig_per_elctbl_chc_id is not null
2435: then
2436: --
2437: l_elig_per_elctbl_chc_id := ben_epe_cache.g_currepe_row.elig_per_elctbl_chc_id;
2438: l_acty_ref_perd_cd := ben_epe_cache.g_currepe_row.acty_ref_perd_cd;
2439: l_start_date := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt;
2440: l_start_date_cd := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_cd;
2441: l_start_date_rl := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_rl;
2442: l_enrt_perd_start_dt := ben_epe_cache.g_currepe_row.enrt_perd_strt_dt;
2435: then
2436: --
2437: l_elig_per_elctbl_chc_id := ben_epe_cache.g_currepe_row.elig_per_elctbl_chc_id;
2438: l_acty_ref_perd_cd := ben_epe_cache.g_currepe_row.acty_ref_perd_cd;
2439: l_start_date := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt;
2440: l_start_date_cd := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_cd;
2441: l_start_date_rl := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_rl;
2442: l_enrt_perd_start_dt := ben_epe_cache.g_currepe_row.enrt_perd_strt_dt;
2443: l_yr_perd_id := ben_epe_cache.g_currepe_row.yr_perd_id;
2436: --
2437: l_elig_per_elctbl_chc_id := ben_epe_cache.g_currepe_row.elig_per_elctbl_chc_id;
2438: l_acty_ref_perd_cd := ben_epe_cache.g_currepe_row.acty_ref_perd_cd;
2439: l_start_date := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt;
2440: l_start_date_cd := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_cd;
2441: l_start_date_rl := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_rl;
2442: l_enrt_perd_start_dt := ben_epe_cache.g_currepe_row.enrt_perd_strt_dt;
2443: l_yr_perd_id := ben_epe_cache.g_currepe_row.yr_perd_id;
2444: --
2437: l_elig_per_elctbl_chc_id := ben_epe_cache.g_currepe_row.elig_per_elctbl_chc_id;
2438: l_acty_ref_perd_cd := ben_epe_cache.g_currepe_row.acty_ref_perd_cd;
2439: l_start_date := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt;
2440: l_start_date_cd := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_cd;
2441: l_start_date_rl := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_rl;
2442: l_enrt_perd_start_dt := ben_epe_cache.g_currepe_row.enrt_perd_strt_dt;
2443: l_yr_perd_id := ben_epe_cache.g_currepe_row.yr_perd_id;
2444: --
2445: l_per_in_ler_id := ben_epe_cache.g_currepe_row.per_in_ler_id;
2438: l_acty_ref_perd_cd := ben_epe_cache.g_currepe_row.acty_ref_perd_cd;
2439: l_start_date := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt;
2440: l_start_date_cd := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_cd;
2441: l_start_date_rl := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_rl;
2442: l_enrt_perd_start_dt := ben_epe_cache.g_currepe_row.enrt_perd_strt_dt;
2443: l_yr_perd_id := ben_epe_cache.g_currepe_row.yr_perd_id;
2444: --
2445: l_per_in_ler_id := ben_epe_cache.g_currepe_row.per_in_ler_id;
2446: l_pgm_id := ben_epe_cache.g_currepe_row.pgm_id;
2439: l_start_date := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt;
2440: l_start_date_cd := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_cd;
2441: l_start_date_rl := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_rl;
2442: l_enrt_perd_start_dt := ben_epe_cache.g_currepe_row.enrt_perd_strt_dt;
2443: l_yr_perd_id := ben_epe_cache.g_currepe_row.yr_perd_id;
2444: --
2445: l_per_in_ler_id := ben_epe_cache.g_currepe_row.per_in_ler_id;
2446: l_pgm_id := ben_epe_cache.g_currepe_row.pgm_id;
2447: l_pl_id := ben_epe_cache.g_currepe_row.pl_id;
2441: l_start_date_rl := ben_epe_cache.g_currepe_row.enrt_cvg_strt_dt_rl;
2442: l_enrt_perd_start_dt := ben_epe_cache.g_currepe_row.enrt_perd_strt_dt;
2443: l_yr_perd_id := ben_epe_cache.g_currepe_row.yr_perd_id;
2444: --
2445: l_per_in_ler_id := ben_epe_cache.g_currepe_row.per_in_ler_id;
2446: l_pgm_id := ben_epe_cache.g_currepe_row.pgm_id;
2447: l_pl_id := ben_epe_cache.g_currepe_row.pl_id;
2448: l_oipl_id := ben_epe_cache.g_currepe_row.oipl_id;
2449: l_lee_rsn_id := ben_epe_cache.g_currepe_row.lee_rsn_id;
2442: l_enrt_perd_start_dt := ben_epe_cache.g_currepe_row.enrt_perd_strt_dt;
2443: l_yr_perd_id := ben_epe_cache.g_currepe_row.yr_perd_id;
2444: --
2445: l_per_in_ler_id := ben_epe_cache.g_currepe_row.per_in_ler_id;
2446: l_pgm_id := ben_epe_cache.g_currepe_row.pgm_id;
2447: l_pl_id := ben_epe_cache.g_currepe_row.pl_id;
2448: l_oipl_id := ben_epe_cache.g_currepe_row.oipl_id;
2449: l_lee_rsn_id := ben_epe_cache.g_currepe_row.lee_rsn_id;
2450: l_enrt_perd_id := ben_epe_cache.g_currepe_row.enrt_perd_id;
2443: l_yr_perd_id := ben_epe_cache.g_currepe_row.yr_perd_id;
2444: --
2445: l_per_in_ler_id := ben_epe_cache.g_currepe_row.per_in_ler_id;
2446: l_pgm_id := ben_epe_cache.g_currepe_row.pgm_id;
2447: l_pl_id := ben_epe_cache.g_currepe_row.pl_id;
2448: l_oipl_id := ben_epe_cache.g_currepe_row.oipl_id;
2449: l_lee_rsn_id := ben_epe_cache.g_currepe_row.lee_rsn_id;
2450: l_enrt_perd_id := ben_epe_cache.g_currepe_row.enrt_perd_id;
2451: l_person_id := ben_epe_cache.g_currepe_row.person_id;
2444: --
2445: l_per_in_ler_id := ben_epe_cache.g_currepe_row.per_in_ler_id;
2446: l_pgm_id := ben_epe_cache.g_currepe_row.pgm_id;
2447: l_pl_id := ben_epe_cache.g_currepe_row.pl_id;
2448: l_oipl_id := ben_epe_cache.g_currepe_row.oipl_id;
2449: l_lee_rsn_id := ben_epe_cache.g_currepe_row.lee_rsn_id;
2450: l_enrt_perd_id := ben_epe_cache.g_currepe_row.enrt_perd_id;
2451: l_person_id := ben_epe_cache.g_currepe_row.person_id;
2452: l_lf_evt_ocrd_dt := ben_epe_cache.g_currepe_row.lf_evt_ocrd_dt;
2445: l_per_in_ler_id := ben_epe_cache.g_currepe_row.per_in_ler_id;
2446: l_pgm_id := ben_epe_cache.g_currepe_row.pgm_id;
2447: l_pl_id := ben_epe_cache.g_currepe_row.pl_id;
2448: l_oipl_id := ben_epe_cache.g_currepe_row.oipl_id;
2449: l_lee_rsn_id := ben_epe_cache.g_currepe_row.lee_rsn_id;
2450: l_enrt_perd_id := ben_epe_cache.g_currepe_row.enrt_perd_id;
2451: l_person_id := ben_epe_cache.g_currepe_row.person_id;
2452: l_lf_evt_ocrd_dt := ben_epe_cache.g_currepe_row.lf_evt_ocrd_dt;
2453: --
2446: l_pgm_id := ben_epe_cache.g_currepe_row.pgm_id;
2447: l_pl_id := ben_epe_cache.g_currepe_row.pl_id;
2448: l_oipl_id := ben_epe_cache.g_currepe_row.oipl_id;
2449: l_lee_rsn_id := ben_epe_cache.g_currepe_row.lee_rsn_id;
2450: l_enrt_perd_id := ben_epe_cache.g_currepe_row.enrt_perd_id;
2451: l_person_id := ben_epe_cache.g_currepe_row.person_id;
2452: l_lf_evt_ocrd_dt := ben_epe_cache.g_currepe_row.lf_evt_ocrd_dt;
2453: --
2454: elsif p_elig_per_elctbl_chc_id is not null then
2447: l_pl_id := ben_epe_cache.g_currepe_row.pl_id;
2448: l_oipl_id := ben_epe_cache.g_currepe_row.oipl_id;
2449: l_lee_rsn_id := ben_epe_cache.g_currepe_row.lee_rsn_id;
2450: l_enrt_perd_id := ben_epe_cache.g_currepe_row.enrt_perd_id;
2451: l_person_id := ben_epe_cache.g_currepe_row.person_id;
2452: l_lf_evt_ocrd_dt := ben_epe_cache.g_currepe_row.lf_evt_ocrd_dt;
2453: --
2454: elsif p_elig_per_elctbl_chc_id is not null then
2455: --
2448: l_oipl_id := ben_epe_cache.g_currepe_row.oipl_id;
2449: l_lee_rsn_id := ben_epe_cache.g_currepe_row.lee_rsn_id;
2450: l_enrt_perd_id := ben_epe_cache.g_currepe_row.enrt_perd_id;
2451: l_person_id := ben_epe_cache.g_currepe_row.person_id;
2452: l_lf_evt_ocrd_dt := ben_epe_cache.g_currepe_row.lf_evt_ocrd_dt;
2453: --
2454: elsif p_elig_per_elctbl_chc_id is not null then
2455: --
2456: open c_epe;