APPS.BEN_DISTRIBUTE_RATES dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 1859: ben_pil_elctbl_chc_popl pel,

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

Line 1877: ben_pil_elctbl_chc_popl pel,

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

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

2177: -- Priority 2:
2178: -- p_enrt_rt_id is not null
2179: -- p_start_date is set to ben_enrt_rt.rt_strt_dt
2180: -- p_end_date is set to ben_yr_perd.end_date
2181: -- p_acty_ref_perd_cd is set to ben_pil_elctbl_chc_popl.acty_ref_perd_cd
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

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

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

Line 2259: ben_pil_elctbl_chc_popl pel,

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

Line 2291: ben_pil_elctbl_chc_popl pel,

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

Line 4484: from ben_pil_elctbl_chc_popl pel,

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

Line 4506: ben_pil_elctbl_chc_popl pel,

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