APPS.BEN_DISTRIBUTE_RATES dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 1739: ben_pil_elctbl_chc_popl pel,

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
1743: and epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id

Line 1757: ben_pil_elctbl_chc_popl pel,

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
1761: and epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id

Line 2056: -- p_acty_ref_perd_cd is set to ben_pil_elctbl_chc_popl.acty_ref_perd_cd

2052: -- Priority 2:
2053: -- p_enrt_rt_id is not null
2054: -- p_start_date is set to ben_enrt_rt.rt_strt_dt
2055: -- p_end_date is set to ben_yr_perd.end_date
2056: -- p_acty_ref_perd_cd is set to ben_pil_elctbl_chc_popl.acty_ref_perd_cd
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

Line 2063: -- p_acty_ref_perd_cd is set to ben_pil_elctbl_chc_popl.acty_ref_perd_cd

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: ---------------------------------------------------------------------------
2066: procedure set_default_dates(p_enrt_rt_id in number,
2067: p_elig_per_elctbl_chc_id in number,

Line 2134: ben_pil_elctbl_chc_popl pel,

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
2138: and epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id

Line 2166: ben_pil_elctbl_chc_popl pel,

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
2170: and decode(ecr.enrt_bnft_id, null, ecr.elig_per_elctbl_chc_id,

Line 4164: from ben_pil_elctbl_chc_popl pel,

4160: cursor c_pel is
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

Line 4186: ben_pil_elctbl_chc_popl pel,

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
4190: and pel.per_in_ler_id = pil.per_in_ler_id;