APPS.BEN_DETERMINE_RATE_CHG dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 296: from ben_elig_per_elctbl_chc epe,

292: epe.yr_perd_id, -- 12417510
293: pel.enrt_perd_id,
294: pel.lee_rsn_id,
295: pel.enrt_perd_strt_dt
296: from ben_elig_per_elctbl_chc epe,
297: ben_pil_elctbl_chc_popl pel
298: where epe.per_in_ler_id = l_per_in_ler_id
299: and epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
300: and epe.per_in_ler_id = pel.per_in_ler_id

Line 316: from ben_elig_per_elctbl_chc epe,

312: epe.yr_perd_id, -- 12417510
313: pel.enrt_perd_id,
314: pel.lee_rsn_id,
315: pel.enrt_perd_strt_dt
316: from ben_elig_per_elctbl_chc epe,
317: ben_pil_elctbl_chc_popl pel
318: where epe.per_in_ler_id = l_per_in_ler_id
319: and epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
320: and epe.per_in_ler_id = pel.per_in_ler_id

Line 343: from ben_elig_per_elctbl_chc epe,

339: epe.yr_perd_id, -- 12417510
340: pel.enrt_perd_id,
341: pel.lee_rsn_id,
342: pel.enrt_perd_strt_dt
343: from ben_elig_per_elctbl_chc epe,
344: ben_pil_elctbl_chc_popl pel
345: where epe.per_in_ler_id = l_per_in_ler_id
346: and epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
347: and epe.per_in_ler_id = pel.per_in_ler_id

Line 704: from ben_elig_per_elctbl_chc epe1,

700: epe.per_in_ler_id,
701: ecr.enrt_rt_id,
702: ecr.acty_base_rt_id,
703: nvl(ecr.dflt_val, ecr.val) val
704: from ben_elig_per_elctbl_chc epe1,
705: ben_elig_per_elctbl_chc epe,
706: ben_enrt_rt ecr
707: where epe1.elig_per_elctbl_chc_id=l_epe.elig_per_elctbl_chc_id and
708: epe1.business_group_id=p_business_group_id and

Line 705: ben_elig_per_elctbl_chc epe,

701: ecr.enrt_rt_id,
702: ecr.acty_base_rt_id,
703: nvl(ecr.dflt_val, ecr.val) val
704: from ben_elig_per_elctbl_chc epe1,
705: ben_elig_per_elctbl_chc epe,
706: ben_enrt_rt ecr
707: where epe1.elig_per_elctbl_chc_id=l_epe.elig_per_elctbl_chc_id and
708: epe1.business_group_id=p_business_group_id and
709: epe1.pgm_id = epe.pgm_id and

Line 740: ,ben_elig_per_elctbl_chc epe

736: /* Start of Changes for WWBUG: 1646442: added cursor and variable */
737: cursor c_pel (p_elig_pe_elctbl_chc_id number) is
738: select pel.enrt_perd_id,pel.lee_rsn_id
739: from ben_pil_elctbl_chc_popl pel
740: ,ben_elig_per_elctbl_chc epe
741: where pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
742: and epe.elig_per_elctbl_chc_id = p_elig_pe_elctbl_chc_id;
743: --
744: l_pelrec c_pel%rowtype;

Line 751: ben_elig_per_elctbl_chc epe

747: --Bug 3044116
748: cursor c_prtt_enrt (p_pgm_id number) is
749: select epe.prtt_enrt_rslt_id,pel.enrt_perd_strt_dt
750: from ben_pil_elctbl_chc_popl pel,
751: ben_elig_per_elctbl_chc epe
752: where pel.per_in_ler_id = p_per_in_ler_id
753: and pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
754: and epe.comp_lvl_cd = 'PLANFC'
755: and epe.pgm_id = p_pgm_id

Line 769: ben_elig_per_elctbl_chc epe

765: --
766: cursor c_imputed_rslt is
767: select effective_start_date
768: from ben_prtt_enrt_rslt_f pen,
769: ben_elig_per_elctbl_chc epe
770: where pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
771: and epe.per_in_ler_id = p_per_in_ler_id
772: and epe.comp_lvl_cd = 'PLANIMP'
773: and epe.business_group_id = p_business_group_id

Line 2663: from ben_elig_per_elctbl_chc epe, ben_BNFT_PRVDR_POOL_f bpl,

2659: where ecr.acty_base_rt_id = p_acty_base_rt_id
2660: and ecr.elig_per_elctbl_chc_id in
2661: (select
2662: epe.elig_per_elctbl_chc_id
2663: from ben_elig_per_elctbl_chc epe, ben_BNFT_PRVDR_POOL_f bpl,
2664: ben_acty_base_rt_f abr
2665: where epe.BNFT_PRVDR_POOL_ID = p_bnft_prvdr_pool_id
2666: and epe.bnft_prvdr_pool_id = bpl.bnft_prvdr_pool_id
2667: and p_effective_date between bpl.effective_start_date and