APPS.BEN_DISTRIBUTE_RATES dependencies on BEN_PER_IN_LER

Line 1577: ben_per_in_ler pil,

1573: ety.processing_type,
1574: asg.payroll_id,
1575: eln.element_type_id
1576: from ben_prtt_rt_val prv,
1577: ben_per_in_ler pil,
1578: pay_element_entry_values_f evl,
1579: per_all_assignments_f asg,
1580: pay_element_entries_f een,
1581: pay_element_links_f eln,

Line 1740: ben_per_in_ler pil

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

Line 1758: ben_per_in_ler pil

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

Line 2135: ben_per_in_ler pil

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

Line 2167: ben_per_in_ler pil

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

Line 4187: ben_per_in_ler pil

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

Line 4400: ,ben_per_in_ler pil

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