APPS.BEN_DETERMINE_RATE_CHG dependencies on BEN_PER_IN_LER

Line 276: from ben_per_in_ler pil

272: l_new_payroll_id number;
273: --
274: cursor c_pil is
275: select pil.per_in_ler_id, pil.lf_evt_ocrd_dt, pil.ler_id
276: from ben_per_in_ler pil
277: where pil.person_id = p_person_id
278: -- added per_in_ler_id for unrestricted enhancement
279: and pil.per_in_ler_id = p_per_in_ler_id
280: and pil.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;

Line 629: ben_per_in_ler pil

625: ppe.std_prem_val,
626: ppe.std_prem_uom,
627: ppe.object_version_number
628: from ben_prtt_prem_f ppe,
629: ben_per_in_ler pil
630: where ppe.prtt_enrt_rslt_id = l_pen.prtt_enrt_rslt_id
631: and ppe.actl_prem_id = v_actl_prem_id
632: and ppe.per_in_ler_id = pil.per_in_ler_id
633: and pil.per_in_ler_stat_cd not in ('BCKDT','VOIDD')

Line 725: ben_per_in_ler pil

721: c_bnft_prvdr_pool_id number ,
722: c_prtt_enrt_rslt_id number) is
723: select prvdd_val
724: from ben_bnft_prvdd_ldgr_f bpl,
725: ben_per_in_ler pil
726: where bpl.acty_base_rt_id = c_acty_base_rt_id
727: and bpl.bnft_prvdr_pool_id = c_bnft_prvdr_pool_id
728: and bpl.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
729: and bpl.prvdd_val is not null

Line 2647: ben_per_in_ler pil

2643: bpl.prvdd_val,
2644: bpl.business_group_id,
2645: pil.person_id
2646: from ben_bnft_prvdd_ldgr_f bpl,
2647: ben_per_in_ler pil
2648: where bpl.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2649: and bpl.prvdd_val is not null
2650: and bpl.effective_end_date = hr_api.g_eot
2651: and bpl.per_in_ler_id = pil.per_in_ler_id