APPS.BEN_DETERMINE_RATE_CHG dependencies on BEN_PER_IN_LER

Line 255: from ben_per_in_ler pil

251: l_new_payroll_id number;
252: --
253: cursor c_pil is
254: select pil.per_in_ler_id, pil.lf_evt_ocrd_dt, pil.ler_id
255: from ben_per_in_ler pil
256: where pil.person_id = p_person_id
257: -- added per_in_ler_id for unrestricted enhancement
258: and pil.per_in_ler_id = p_per_in_ler_id
259: and pil.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;

Line 581: ben_per_in_ler pil

577: ppe.std_prem_val,
578: ppe.std_prem_uom,
579: ppe.object_version_number
580: from ben_prtt_prem_f ppe,
581: ben_per_in_ler pil
582: where ppe.prtt_enrt_rslt_id = l_pen.prtt_enrt_rslt_id
583: and ppe.actl_prem_id = v_actl_prem_id
584: and ppe.per_in_ler_id = pil.per_in_ler_id
585: and pil.per_in_ler_stat_cd not in ('BCKDT','VOIDD')

Line 677: ben_per_in_ler pil

673: c_bnft_prvdr_pool_id number ,
674: c_prtt_enrt_rslt_id number) is
675: select prvdd_val
676: from ben_bnft_prvdd_ldgr_f bpl,
677: ben_per_in_ler pil
678: where bpl.acty_base_rt_id = c_acty_base_rt_id
679: and bpl.bnft_prvdr_pool_id = c_bnft_prvdr_pool_id
680: and bpl.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
681: and bpl.prvdd_val is not null

Line 2464: ben_per_in_ler pil

2460: bpl.prvdd_val,
2461: bpl.business_group_id,
2462: pil.person_id
2463: from ben_bnft_prvdd_ldgr_f bpl,
2464: ben_per_in_ler pil
2465: where bpl.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2466: and bpl.prvdd_val is not null
2467: and bpl.effective_end_date = hr_api.g_eot
2468: and bpl.per_in_ler_id = pil.per_in_ler_id