APPS.BEN_COBRA_REQUIREMENTS dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 419: l_enrt_cvg_strt_dt ben_elig_per_elctbl_chc.enrt_cvg_strt_dt%type;

415: --
416: -- Declare cursors and local variables
417: --
418: l_det_end_date boolean := false;
419: l_enrt_cvg_strt_dt ben_elig_per_elctbl_chc.enrt_cvg_strt_dt%type;
420: l_dsblty_elig_perd_end_dt date;
421: l_cbr_elig_perd_end_dt date;
422: l_eligible boolean := false;
423: l_exists varchar2(1);

Line 471: from ben_elig_per_elctbl_chc epe

467: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');
468: --
469: cursor c_get_enrt_cvg_strt_dt is
470: select min(epe.enrt_cvg_strt_dt)
471: from ben_elig_per_elctbl_chc epe
472: where epe.per_in_ler_id = p_per_in_ler_id
473: and epe.ptip_id = nvl(p_ptip_id, epe.ptip_id)
474: and epe.pgm_id = nvl(p_pgm_id, epe.pgm_id)
475: and epe.enrt_cvg_strt_dt is not null

Line 1377: from ben_elig_per_elctbl_chc epe

1373: l_update boolean;
1374: --
1375: cursor c_get_epe is
1376: select epe.*, pgm.poe_lvl_cd
1377: from ben_elig_per_elctbl_chc epe
1378: ,ben_pgm_f pgm
1379: where epe.per_in_ler_id = p_per_in_ler_id
1380: and epe.business_group_id = p_business_group_id
1381: and epe.pgm_id = pgm.pgm_id

Line 2844: from ben_elig_per_elctbl_chc chc

2840: cursor c_chk_elctbl_chc(p_pgm_id in number
2841: ,p_ptip_id in number
2842: ) is
2843: select null
2844: from ben_elig_per_elctbl_chc chc
2845: where chc.pgm_id = p_pgm_id
2846: and chc.ptip_id = nvl(p_ptip_id, chc.ptip_id)
2847: and chc.elctbl_flag = 'Y'
2848: and chc.per_in_ler_id = p_per_in_ler_id