APPS.BEN_DET_IMPUTED_INCOME dependencies on BEN_PER_IN_LER

Line 22: from ben_per_in_ler pil

18: --
19: cursor c_pil is
20: select pil.lf_evt_ocrd_dt,
21: pil.ler_id
22: from ben_per_in_ler pil
23: where pil.per_in_ler_id = p_per_in_ler_id;
24: --
25: l_pil_rec c_pil%rowtype;
26: --

Line 38: ben_per_in_ler pil

34: from ben_prtt_enrt_rslt_f pen,
35: ben_prtt_rt_val prv,
36: ben_acty_base_rt_f abr,
37: ben_pl_f pln,
38: ben_per_in_ler pil
39: where pen.person_id = p_person_id
40: and pen.prtt_enrt_rslt_stat_cd is null
41: and pen.enrt_cvg_thru_dt = p_eot
42: and pen.business_group_id = p_business_group_id

Line 70: ben_per_in_ler pil

66: cursor c_ben_amt(p_highly_comp in varchar2,p_eot in date) is
67: select sum(pen.bnft_amt)
68: from ben_prtt_enrt_rslt_f pen,
69: ben_pl_f pln,
70: ben_per_in_ler pil
71: where pen.person_id = p_person_id
72: and pen.prtt_enrt_rslt_stat_cd is null
73: and pen.enrt_cvg_thru_dt = p_eot
74: and pen.business_group_id = p_business_group_id