APPS.BEN_DETERMINE_RATE_CHG dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 274: from ben_elig_per_elctbl_chc epe,

270: epe.fonm_cvg_strt_dt,
271: pel.enrt_perd_id,
272: pel.lee_rsn_id,
273: pel.enrt_perd_strt_dt
274: from ben_elig_per_elctbl_chc epe,
275: ben_pil_elctbl_chc_popl pel
276: where epe.per_in_ler_id = l_per_in_ler_id
277: and epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
278: and epe.per_in_ler_id = pel.per_in_ler_id

Line 293: from ben_elig_per_elctbl_chc epe,

289: epe.fonm_cvg_strt_dt,
290: pel.enrt_perd_id,
291: pel.lee_rsn_id,
292: pel.enrt_perd_strt_dt
293: from ben_elig_per_elctbl_chc epe,
294: ben_pil_elctbl_chc_popl pel
295: where epe.per_in_ler_id = l_per_in_ler_id
296: and epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
297: and epe.per_in_ler_id = pel.per_in_ler_id

Line 319: from ben_elig_per_elctbl_chc epe,

315: epe.fonm_cvg_strt_dt,
316: pel.enrt_perd_id,
317: pel.lee_rsn_id,
318: pel.enrt_perd_strt_dt
319: from ben_elig_per_elctbl_chc epe,
320: ben_pil_elctbl_chc_popl pel
321: where epe.per_in_ler_id = l_per_in_ler_id
322: and epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
323: and epe.per_in_ler_id = pel.per_in_ler_id

Line 656: from ben_elig_per_elctbl_chc epe1,

652: epe.per_in_ler_id,
653: ecr.enrt_rt_id,
654: ecr.acty_base_rt_id,
655: nvl(ecr.dflt_val, ecr.val) val
656: from ben_elig_per_elctbl_chc epe1,
657: ben_elig_per_elctbl_chc epe,
658: ben_enrt_rt ecr
659: where epe1.elig_per_elctbl_chc_id=l_epe.elig_per_elctbl_chc_id and
660: epe1.business_group_id=p_business_group_id and

Line 657: ben_elig_per_elctbl_chc epe,

653: ecr.enrt_rt_id,
654: ecr.acty_base_rt_id,
655: nvl(ecr.dflt_val, ecr.val) val
656: from ben_elig_per_elctbl_chc epe1,
657: ben_elig_per_elctbl_chc epe,
658: ben_enrt_rt ecr
659: where epe1.elig_per_elctbl_chc_id=l_epe.elig_per_elctbl_chc_id and
660: epe1.business_group_id=p_business_group_id and
661: epe1.pgm_id = epe.pgm_id and

Line 692: ,ben_elig_per_elctbl_chc epe

688: /* Start of Changes for WWBUG: 1646442: added cursor and variable */
689: cursor c_pel (p_elig_pe_elctbl_chc_id number) is
690: select pel.enrt_perd_id,pel.lee_rsn_id
691: from ben_pil_elctbl_chc_popl pel
692: ,ben_elig_per_elctbl_chc epe
693: where pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
694: and epe.elig_per_elctbl_chc_id = p_elig_pe_elctbl_chc_id;
695: --
696: l_pelrec c_pel%rowtype;

Line 703: ben_elig_per_elctbl_chc epe

699: --Bug 3044116
700: cursor c_prtt_enrt (p_pgm_id number) is
701: select epe.prtt_enrt_rslt_id,pel.enrt_perd_strt_dt
702: from ben_pil_elctbl_chc_popl pel,
703: ben_elig_per_elctbl_chc epe
704: where pel.per_in_ler_id = p_per_in_ler_id
705: and pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
706: and epe.comp_lvl_cd = 'PLANFC'
707: and epe.pgm_id = p_pgm_id

Line 721: ben_elig_per_elctbl_chc epe

717: --
718: cursor c_imputed_rslt is
719: select effective_start_date
720: from ben_prtt_enrt_rslt_f pen,
721: ben_elig_per_elctbl_chc epe
722: where pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
723: and epe.per_in_ler_id = p_per_in_ler_id
724: and epe.comp_lvl_cd = 'PLANIMP'
725: and epe.business_group_id = p_business_group_id

Line 2480: from ben_elig_per_elctbl_chc epe, ben_BNFT_PRVDR_POOL_f bpl,

2476: where ecr.acty_base_rt_id = p_acty_base_rt_id
2477: and ecr.elig_per_elctbl_chc_id in
2478: (select
2479: epe.elig_per_elctbl_chc_id
2480: from ben_elig_per_elctbl_chc epe, ben_BNFT_PRVDR_POOL_f bpl,
2481: ben_acty_base_rt_f abr
2482: where epe.BNFT_PRVDR_POOL_ID = p_bnft_prvdr_pool_id
2483: and epe.bnft_prvdr_pool_id = bpl.bnft_prvdr_pool_id
2484: and p_effective_date between bpl.effective_start_date and