APPS.BEN_DISTRIBUTE_RATES dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 1738: from ben_elig_per_elctbl_chc epe,

1734: pel.lee_rsn_id,
1735: pel.enrt_perd_id,
1736: pil.person_id,
1737: pil.lf_evt_ocrd_dt
1738: from ben_elig_per_elctbl_chc epe,
1739: ben_pil_elctbl_chc_popl pel,
1740: ben_per_in_ler pil
1741: where epe.elig_per_elctbl_chc_id = l_ecr.elig_per_elctbl_chc_id
1742: and epe.per_in_ler_id = pil.per_in_ler_id

Line 1756: ben_elig_per_elctbl_chc epe,

1752: pel.enrt_perd_id,
1753: pil.person_id,
1754: pil.lf_evt_ocrd_dt
1755: from ben_enrt_bnft enb,
1756: ben_elig_per_elctbl_chc epe,
1757: ben_pil_elctbl_chc_popl pel,
1758: ben_per_in_ler pil
1759: where enb.enrt_bnft_id = l_ecr.enrt_bnft_id
1760: and epe.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id

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

2057: -- In this case, the parameters are set only if they are null.
2058: --
2059: -- Priority 3:
2060: -- p_elig_per_elctbl_chc_id is not null
2061: -- p_start_date is set to ben_elig_per_elctbl_chc.enrt_cvg_strt_dt
2062: -- p_end_date is set to ben_yr_perd.end_date
2063: -- p_acty_ref_perd_cd is set to ben_pil_elctbl_chc_popl.acty_ref_perd_cd
2064: -- In this case, the parameters are set only if they are null.
2065: ---------------------------------------------------------------------------

Line 2133: from ben_elig_per_elctbl_chc epe,

2129: pil.person_id,
2130: pil.lf_evt_ocrd_dt,
2131: --END BUG 3191928
2132: epe.pl_typ_id -- ICM
2133: from ben_elig_per_elctbl_chc epe,
2134: ben_pil_elctbl_chc_popl pel,
2135: ben_per_in_ler pil
2136: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
2137: and epe.business_group_id = p_business_group_id

Line 2165: ben_elig_per_elctbl_chc epe,

2161: pil.lf_evt_ocrd_dt
2162: --END BUG 3191928
2163: from ben_enrt_rt ecr,
2164: ben_enrt_bnft enb,
2165: ben_elig_per_elctbl_chc epe,
2166: ben_pil_elctbl_chc_popl pel,
2167: ben_per_in_ler pil
2168: where ecr.enrt_rt_id = p_enrt_rt_id
2169: and ecr.business_group_id = p_business_group_id

Line 2224: ben_elig_per_elctbl_chc epe

2220:
2221: cursor c_pgm_typ_cd(v_elig_per_elctbl_chc_id in number) is
2222: select pgm.pgm_typ_cd
2223: from ben_pgm_f pgm,
2224: ben_elig_per_elctbl_chc epe
2225: where epe.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
2226: and pgm.pgm_id = epe.pgm_id
2227: and p_effective_date between pgm.effective_start_date
2228: and pgm.effective_end_date;

Line 4165: ben_elig_per_elctbl_chc epe

4161: select pel.enrt_perd_id,
4162: pel.lee_rsn_id,
4163: epe.yr_perd_id
4164: from ben_pil_elctbl_chc_popl pel,
4165: ben_elig_per_elctbl_chc epe
4166: where pel.per_in_ler_id = p_per_in_ler_id
4167: and pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
4168: and pel.per_in_ler_id = epe.per_in_ler_id
4169: and ((p_pgm_id is not null and

Line 4185: from ben_elig_per_elctbl_chc epe,

4181: epe.yr_perd_id,
4182: pel.enrt_perd_id,
4183: pel.lee_rsn_id,
4184: pil.business_group_id
4185: from ben_elig_per_elctbl_chc epe,
4186: ben_pil_elctbl_chc_popl pel,
4187: ben_per_in_ler pil
4188: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
4189: and epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id

Line 4399: ,ben_elig_per_elctbl_chc epe

4395: select yrp.start_date, yrp.end_date, epe.pgm_id, epe.pl_id,
4396: epe.pl_typ_id, epe.business_group_id, pil.ler_id,
4397: oipl.opt_id
4398: from ben_yr_perd yrp
4399: ,ben_elig_per_elctbl_chc epe
4400: ,ben_per_in_ler pil
4401: ,ben_oipl_f oipl
4402: where epe.yr_perd_id = yrp.yr_perd_id
4403: and epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id