[Home] [Help]
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
1472: and p_effective_date BETWEEN le.effective_start_date AND le.effective_end_date
1525: ben_pl_typ_f plt,
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
1620: ben_pl_f pln,
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)
1636: and pen.person_id = p_person_id
1637: and pen.prtt_enrt_rslt_id = pbn.prtt_enrt_rslt_id
1638: and pbn.per_in_ler_id = pil.per_in_ler_id
1639: and pil.ler_id = ler.ler_id
1640: and exists (select null from ben_per_in_ler pil
1641: where pil.per_in_ler_id = pbn.per_in_ler_id
1642: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT'))
1643: and pen.prtt_enrt_rslt_stat_cd IS NULL
1644: and pen.enrt_cvg_thru_dt = to_date('31-12-4712','DD-MM-YYYY')