APPS.BEN_DISTRIBUTE_RATES dependencies on BEN_PER_IN_LER

Line 1697: ben_per_in_ler pil,

1693: ety.processing_type,
1694: asg.payroll_id,
1695: eln.element_type_id
1696: from ben_prtt_rt_val prv,
1697: ben_per_in_ler pil,
1698: pay_element_entry_values_f evl,
1699: per_all_assignments_f asg,
1700: pay_element_entries_f een,
1701: pay_element_links_f eln,

Line 1860: ben_per_in_ler pil

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

Line 1878: ben_per_in_ler pil

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

Line 2260: ben_per_in_ler pil

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

Line 2292: ben_per_in_ler pil

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,
2296: enb.elig_per_elctbl_chc_id) =

Line 4507: ben_per_in_ler pil

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;
4511: --

Line 4720: ,ben_per_in_ler pil

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
4724: and epe.per_in_ler_id = pil.per_in_ler_id