APPS.BEN_DISTRIBUTE_RATES dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 1858: from ben_elig_per_elctbl_chc epe,

1854: pel.lee_rsn_id,
1855: pel.enrt_perd_id,
1856: pil.person_id,
1857: pil.lf_evt_ocrd_dt
1858: from ben_elig_per_elctbl_chc epe,
1859: ben_pil_elctbl_chc_popl pel,
1860: ben_per_in_ler pil
1861: where epe.elig_per_elctbl_chc_id = l_ecr.elig_per_elctbl_chc_id
1862: and epe.per_in_ler_id = pil.per_in_ler_id

Line 1876: ben_elig_per_elctbl_chc epe,

1872: pel.enrt_perd_id,
1873: pil.person_id,
1874: pil.lf_evt_ocrd_dt
1875: from ben_enrt_bnft enb,
1876: ben_elig_per_elctbl_chc epe,
1877: ben_pil_elctbl_chc_popl pel,
1878: ben_per_in_ler pil
1879: where enb.enrt_bnft_id = l_ecr.enrt_bnft_id
1880: and epe.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id

Line 2186: -- p_start_date is set to ben_elig_per_elctbl_chc.enrt_cvg_strt_dt

2182: -- In this case, the parameters are set only if they are null.
2183: --
2184: -- Priority 3:
2185: -- p_elig_per_elctbl_chc_id is not null
2186: -- p_start_date is set to ben_elig_per_elctbl_chc.enrt_cvg_strt_dt
2187: -- p_end_date is set to ben_yr_perd.end_date
2188: -- p_acty_ref_perd_cd is set to ben_pil_elctbl_chc_popl.acty_ref_perd_cd
2189: -- In this case, the parameters are set only if they are null.
2190: ---------------------------------------------------------------------------

Line 2258: from ben_elig_per_elctbl_chc epe,

2254: pil.person_id,
2255: pil.lf_evt_ocrd_dt,
2256: --END BUG 3191928
2257: epe.pl_typ_id -- ICM
2258: from ben_elig_per_elctbl_chc epe,
2259: ben_pil_elctbl_chc_popl pel,
2260: ben_per_in_ler pil
2261: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
2262: and epe.business_group_id = p_business_group_id

Line 2290: ben_elig_per_elctbl_chc epe,

2286: pil.lf_evt_ocrd_dt
2287: --END BUG 3191928
2288: from ben_enrt_rt ecr,
2289: ben_enrt_bnft enb,
2290: ben_elig_per_elctbl_chc epe,
2291: ben_pil_elctbl_chc_popl pel,
2292: ben_per_in_ler pil
2293: where ecr.enrt_rt_id = p_enrt_rt_id
2294: and ecr.business_group_id = p_business_group_id

Line 2349: ben_elig_per_elctbl_chc epe

2345:
2346: cursor c_pgm_typ_cd(v_elig_per_elctbl_chc_id in number) is
2347: select pgm.pgm_typ_cd
2348: from ben_pgm_f pgm,
2349: ben_elig_per_elctbl_chc epe
2350: where epe.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
2351: and pgm.pgm_id = epe.pgm_id
2352: and p_effective_date between pgm.effective_start_date
2353: and pgm.effective_end_date;

Line 4485: ben_elig_per_elctbl_chc epe

4481: select pel.enrt_perd_id,
4482: pel.lee_rsn_id,
4483: epe.yr_perd_id
4484: from ben_pil_elctbl_chc_popl pel,
4485: ben_elig_per_elctbl_chc epe
4486: where pel.per_in_ler_id = p_per_in_ler_id
4487: and pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
4488: and pel.per_in_ler_id = epe.per_in_ler_id
4489: and ((p_pgm_id is not null and

Line 4505: from ben_elig_per_elctbl_chc epe,

4501: epe.yr_perd_id,
4502: pel.enrt_perd_id,
4503: pel.lee_rsn_id,
4504: pil.business_group_id
4505: from ben_elig_per_elctbl_chc epe,
4506: ben_pil_elctbl_chc_popl pel,
4507: ben_per_in_ler pil
4508: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
4509: and epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id

Line 4719: ,ben_elig_per_elctbl_chc epe

4715: select yrp.start_date, yrp.end_date, epe.pgm_id, epe.pl_id,
4716: epe.pl_typ_id, epe.business_group_id, pil.ler_id,
4717: oipl.opt_id
4718: from ben_yr_perd yrp
4719: ,ben_elig_per_elctbl_chc epe
4720: ,ben_per_in_ler pil
4721: ,ben_oipl_f oipl
4722: where epe.yr_perd_id = yrp.yr_perd_id
4723: and epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id