APPS.BEN_PERSON_RECORD dependencies on BEN_LER_F

Line 60: ben_ler_f ler

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
64: and pen.prtt_enrt_rslt_id = pdp.prtt_enrt_rslt_id

Line 156: ben_ler_f ler

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)
160: and pen.enrt_cvg_thru_dt >= pen.effective_start_date

Line 322: ben_ler_f ler

318: ben_prtt_enrt_rslt_f pen,
319: ben_pl_typ_f plt,
320: ben_pil_elctbl_chc_popl pel,
321: ben_prtt_enrt_rslt_f pen1,
322: ben_ler_f ler
323: WHERE pen.prtt_enrt_rslt_id = pen1.rplcs_sspndd_rslt_id (+)
324: and ( p_effective_date) between pen1.effective_start_date (+)
325: and pen1.effective_end_date (+)
326: and pen1.prtt_enrt_rslt_stat_cd (+) is NULL

Line 392: ben_ler_f ler

388: ben_prtt_enrt_rslt_f pen,
389: ben_pl_typ_f plt,
390: ben_pil_elctbl_chc_popl pel,
391: ben_prtt_enrt_rslt_f pen1,
392: ben_ler_f ler
393: WHERE pen.prtt_enrt_rslt_id = pen1.rplcs_sspndd_rslt_id (+)
394: and (p_effective_date) between pen1.effective_start_date (+)
395: and pen1.effective_end_date (+)
396: and pen1.prtt_enrt_rslt_stat_cd (+) is NULL