APPS.HR_PERSON_RECORD dependencies on BEN_PRTT_ENRT_RSLT_F

Line 1467: from ben_prtt_enrt_rslt_f pen,

1463: -- Benefit Cursors
1464: -- Code Commented for bug 7689952 - Start
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

Line 1521: ben_prtt_enrt_rslt_f pen,

1517: ppf.full_name dependent_full_name,
1518: pdp.cvg_strt_dt,
1519: to_date(null) cvg_thru_dt
1520: from ben_elig_per_elctbl_chc epe,
1521: ben_prtt_enrt_rslt_f pen,
1522: ben_elig_cvrd_dpnt_f pdp,
1523: per_contact_relationships pcr,
1524: per_people_f ppf,
1525: ben_pl_typ_f plt,

Line 1617: ben_prtt_enrt_rslt_f pen,

1613: pen.oipl_ordr_num oipl_ordr_num,
1614: pen.bnft_ordr_num bnft_ordr_num
1615: from per_people_f ppf,
1616: per_contact_relationships pcr,
1617: ben_prtt_enrt_rslt_f pen,
1618: ben_pl_bnf_f pbn,
1619: ben_pl_typ_f plt,
1620: ben_pl_f pln,
1621: hr_all_organization_units org,

Line 1786: ben_prtt_enrt_rslt_f pen,

1782: epe.pl_id,
1783: epe.oipl_id
1784: FROM ben_elig_per_elctbl_chc epe,
1785: ben_enrt_bnft beb,
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

Line 1789: ben_prtt_enrt_rslt_f pen1,

1785: ben_enrt_bnft beb,
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 (+)

Line 1856: ben_prtt_enrt_rslt_f pen,

1852: epe.pl_id,
1853: epe.oipl_id
1854: FROM ben_elig_per_elctbl_chc epe,
1855: ben_enrt_bnft beb,
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

Line 1859: ben_prtt_enrt_rslt_f pen1,

1855: ben_enrt_bnft beb,
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 (+)