APPS.BEN_PERSON_RECORD dependencies on BEN_PER_IN_LER

Line 59: ben_per_in_ler pil,

55: ben_pl_typ_f plt,
56: ben_pl_f pln,
57: ben_opt_f opt,
58: ben_oipl_f oipl,
59: ben_per_in_ler pil,
60: ben_ler_f ler
61: where epe.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
62: and epe.pl_id = pln.pl_id
63: and epe.pl_typ_id = plt.pl_typ_id

Line 155: ben_per_in_ler pil,

151: ben_pl_f pln,
152: hr_all_organization_units org,
153: ben_opt_f opt,
154: ben_oipl_f oipl,
155: ben_per_in_ler pil,
156: ben_ler_f ler
157: where pen.pl_id = pln.pl_id
158: -- Code Changes for bug 7689952 - Start
159: --and (pen.per_in_ler_id = l_per_in_ler_id)

Line 171: and exists (select null from ben_per_in_ler pil

167: and pen.person_id = p_person_id
168: and pen.prtt_enrt_rslt_id = pbn.prtt_enrt_rslt_id
169: and pbn.per_in_ler_id = pil.per_in_ler_id
170: and pil.ler_id = ler.ler_id
171: and exists (select null from ben_per_in_ler pil
172: where pil.per_in_ler_id = pbn.per_in_ler_id
173: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT'))
174: and pen.prtt_enrt_rslt_stat_cd IS NULL
175: and pen.enrt_cvg_thru_dt = to_date('31-12-4712','DD-MM-YYYY')