APPS.HR_PERSON_RECORD dependencies on BEN_LER_F

Line 1469: ben_ler_f le

1465: /*cursor c_get_id(p_person_id NUMBER,p_effective_date DATE,p_business_group_id NUMBER) is
1466: select distinct pen.per_in_ler_id,pil.lf_evt_ocrd_dt
1467: from ben_prtt_enrt_rslt_f pen,
1468: ben_per_in_ler pil,
1469: ben_ler_f le
1470: where pen.business_group_id=p_business_group_id
1471: and p_effective_date BETWEEN pen.effective_start_date AND pen.effective_end_date
1472: and p_effective_date BETWEEN le.effective_start_date AND le.effective_end_date
1473: and pen.prtt_enrt_rslt_stat_cd IS NULL

Line 1530: ben_ler_f ler

1526: ben_pl_f pln,
1527: ben_opt_f opt,
1528: ben_oipl_f oipl,
1529: ben_per_in_ler pil,
1530: ben_ler_f ler
1531: where epe.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1532: and epe.pl_id = pln.pl_id
1533: and epe.pl_typ_id = plt.pl_typ_id
1534: and pen.prtt_enrt_rslt_id = pdp.prtt_enrt_rslt_id

Line 1625: ben_ler_f ler

1621: hr_all_organization_units org,
1622: ben_opt_f opt,
1623: ben_oipl_f oipl,
1624: ben_per_in_ler pil,
1625: ben_ler_f ler
1626: where pen.pl_id = pln.pl_id
1627: -- Code Changes for bug 7689952 - Start
1628: --and (pen.per_in_ler_id = l_per_in_ler_id)
1629: and pen.enrt_cvg_thru_dt >= pen.effective_start_date

Line 1790: ben_ler_f ler

1786: ben_prtt_enrt_rslt_f pen,
1787: ben_pl_typ_f plt,
1788: ben_pil_elctbl_chc_popl pel,
1789: ben_prtt_enrt_rslt_f pen1,
1790: ben_ler_f ler
1791: WHERE pen.prtt_enrt_rslt_id = pen1.rplcs_sspndd_rslt_id (+)
1792: and ( p_effective_date) between pen1.effective_start_date (+)
1793: and pen1.effective_end_date (+)
1794: and pen1.prtt_enrt_rslt_stat_cd (+) is NULL

Line 1860: ben_ler_f ler

1856: ben_prtt_enrt_rslt_f pen,
1857: ben_pl_typ_f plt,
1858: ben_pil_elctbl_chc_popl pel,
1859: ben_prtt_enrt_rslt_f pen1,
1860: ben_ler_f ler
1861: WHERE pen.prtt_enrt_rslt_id = pen1.rplcs_sspndd_rslt_id (+)
1862: and (p_effective_date) between pen1.effective_start_date (+)
1863: and pen1.effective_end_date (+)
1864: and pen1.prtt_enrt_rslt_stat_cd (+) is NULL