APPS.BEN_COBRA_REQUIREMENTS dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 436: l_enrt_cvg_strt_dt ben_elig_per_elctbl_chc.enrt_cvg_strt_dt%type;

432: --
433: -- Declare cursors and local variables
434: --
435: l_det_end_date boolean := false;
436: l_enrt_cvg_strt_dt ben_elig_per_elctbl_chc.enrt_cvg_strt_dt%type;
437: l_dsblty_elig_perd_end_dt date;
438: l_cbr_elig_perd_end_dt date;
439: l_eligible boolean := false;
440: l_exists varchar2(1);

Line 489: from ben_elig_per_elctbl_chc epe

485: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');
486: --
487: cursor c_get_enrt_cvg_strt_dt is
488: select min(epe.enrt_cvg_strt_dt)
489: from ben_elig_per_elctbl_chc epe
490: where epe.per_in_ler_id = p_per_in_ler_id
491: and epe.ptip_id = nvl(p_ptip_id, epe.ptip_id)
492: and epe.pgm_id = nvl(p_pgm_id, epe.pgm_id)
493: and epe.enrt_cvg_strt_dt is not null

Line 1396: from ben_elig_per_elctbl_chc epe

1392: l_arra_event boolean;
1393: --
1394: cursor c_get_epe is
1395: select epe.*, pgm.poe_lvl_cd
1396: from ben_elig_per_elctbl_chc epe
1397: ,ben_pgm_f pgm
1398: where epe.per_in_ler_id = p_per_in_ler_id
1399: and epe.business_group_id = p_business_group_id
1400: and epe.pgm_id = pgm.pgm_id

Line 3134: from ben_elig_per_elctbl_chc chc

3130: cursor c_chk_elctbl_chc(p_pgm_id in number
3131: ,p_ptip_id in number
3132: ) is
3133: select null
3134: from ben_elig_per_elctbl_chc chc
3135: where chc.pgm_id = p_pgm_id
3136: and chc.ptip_id = nvl(p_ptip_id, chc.ptip_id)
3137: and chc.elctbl_flag = 'Y'
3138: and chc.per_in_ler_id = p_per_in_ler_id