eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_LF_EVT_CLPS_RESTORE dependencies on BEN_PER_IN_LER

Line 139: ben_per_in_ler pil,

135: pen.RPLCS_SSPNDD_RSLT_ID,
136: pen.SSPNDD_FLAG,
137: pen.UOM
138: from ben_prtt_enrt_rslt_f pen,
139: ben_per_in_ler pil,
140: ben_pil_elctbl_chc_popl pel --Added for Bug 4423161
141: where pil.per_in_ler_id = c_bckdt_per_in_ler_id
142: and pil.person_id = c_person_id
143: and pil.per_in_ler_id = pen.per_in_ler_id

Line 168: ben_per_in_ler pil_inner

164: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
165: and pen.prtt_enrt_rslt_id not in (
166: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)
167: from ben_prtt_enrt_rslt_f pen_inner,
168: ben_per_in_ler pil_inner
169: where pil_inner.per_in_ler_id = c_bckdt_per_in_ler_id
170: and pil_inner.person_id = c_person_id
171: and pil_inner.per_in_ler_id = pen_inner.per_in_ler_id
172: and (pen_inner.enrt_cvg_thru_dt is null or

Line 179: ben_per_in_ler pil_inner

175: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
176: union
177: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)
178: from ben_le_clsn_n_rstr pen_inner,
179: ben_per_in_ler pil_inner
180: where pil_inner.per_in_ler_id = c_bckdt_per_in_ler_id
181: and pil_inner.person_id = c_person_id
182: AND pil_inner.per_in_ler_id = pen_inner.per_in_ler_id
183: and pen_inner.bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F'

Line 269: ben_per_in_ler pil,

265: pen.RPLCS_SSPNDD_RSLT_ID,
266: pen.SSPNDD_FLAG,
267: pen.UOM
268: from ben_le_clsn_n_rstr pen,
269: ben_per_in_ler pil,
270: ben_pil_elctbl_chc_popl pel --Added for Bug 4423161
271: where pil.per_in_ler_id = c_bckdt_per_in_ler_id
272: and pil.person_id = c_person_id
273: and pil.per_in_ler_id = pel.per_in_ler_id

Line 295: ben_per_in_ler pil_inner

291: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
292: and pen.bkup_tbl_id not in (
293: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)
294: from ben_prtt_enrt_rslt_f pen_inner,
295: ben_per_in_ler pil_inner
296: where pil_inner.per_in_ler_id = c_bckdt_per_in_ler_id
297: and pil_inner.person_id = c_person_id
298: and pil_inner.per_in_ler_id = pen_inner.per_in_ler_id
299: and (pen_inner.enrt_cvg_thru_dt is null or

Line 306: ben_per_in_ler pil_inner

302: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
303: union
304: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)
305: from ben_le_clsn_n_rstr pen_inner,
306: ben_per_in_ler pil_inner
307: where pil_inner.per_in_ler_id = c_bckdt_per_in_ler_id
308: and pil_inner.person_id = c_person_id
309: AND pil_inner.per_in_ler_id = pen_inner.per_in_ler_id
310: and pen_inner.bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F'

Line 497: from ben_per_in_ler pil

493: select pil.per_in_ler_id,
494: ler.name,
495: pil.bckt_per_in_ler_id,
496: ler_cs_bckdt.name ler_cs_bckdt_name
497: from ben_per_in_ler pil
498: ,ben_ler_f ler
499: ,ben_per_in_ler pil_cs_bckdt
500: ,ben_ler_f ler_cs_bckdt
501: ,ben_ptnl_ler_for_per plr

Line 499: ,ben_per_in_ler pil_cs_bckdt

495: pil.bckt_per_in_ler_id,
496: ler_cs_bckdt.name ler_cs_bckdt_name
497: from ben_per_in_ler pil
498: ,ben_ler_f ler
499: ,ben_per_in_ler pil_cs_bckdt
500: ,ben_ler_f ler_cs_bckdt
501: ,ben_ptnl_ler_for_per plr
502: where pil.person_id = p_person_id
503: and pil.business_group_id = p_business_group_id

Line 573: ben_per_in_ler pil

569: --
570: cursor c_enrt_rslt_exists is
571: select 'Y'
572: from ben_prtt_enrt_rslt_f pen,
573: ben_per_in_ler pil
574: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
575: and pil.business_group_id = p_business_group_id
576: and pen.per_in_ler_id = pil.per_in_ler_id
577: and pen.business_group_id = pil.business_group_id

Line 633: ben_per_in_ler pil

629: pen.PGM_ID,
630: pen.PL_ID,
631: pen.SSPNDD_FLAG
632: from ben_prtt_enrt_rslt_f pen,
633: ben_per_in_ler pil
634: where pil.per_in_ler_id = p_pil_id
635: and pil.person_id = p_person_id
636: and pil.business_group_id = p_business_group_id
637: AND pil.per_in_ler_id = pen.per_in_ler_id

Line 754: from ben_per_in_ler csd_pil,

750: --
751: cursor c_bckt_csd_pil is
752: select csd_pil.lf_evt_ocrd_dt,
753: csd_pil.per_in_ler_id
754: from ben_per_in_ler csd_pil,
755: ben_per_in_ler bckt_pil
756: where bckt_pil.per_in_ler_id = p_bckdt_per_in_ler_id
757: and bckt_pil.BCKT_PER_IN_LER_ID = csd_pil.per_in_ler_id
758: and bckt_pil.business_group_id = p_business_group_id

Line 755: ben_per_in_ler bckt_pil

751: cursor c_bckt_csd_pil is
752: select csd_pil.lf_evt_ocrd_dt,
753: csd_pil.per_in_ler_id
754: from ben_per_in_ler csd_pil,
755: ben_per_in_ler bckt_pil
756: where bckt_pil.per_in_ler_id = p_bckdt_per_in_ler_id
757: and bckt_pil.BCKT_PER_IN_LER_ID = csd_pil.per_in_ler_id
758: and bckt_pil.business_group_id = p_business_group_id
759: and csd_pil.business_group_id = p_business_group_id;

Line 771: from ben_per_in_ler pil,

767: -- iREC : do not consider iRec, ABS, COMP, GSP pils.
768: --
769: cursor c_inter_pil_cnt(cv_bckt_csd_lf_evt_ocrd_dt date) is
770: select pil.per_in_ler_id, pil.object_version_number
771: from ben_per_in_ler pil,
772: ben_ler_f ler
773: where pil.per_in_ler_id <> p_per_in_ler_id
774: and pil.per_in_ler_id <> p_bckdt_per_in_ler_id
775: and pil.person_id = p_person_id

Line 784: from ben_per_in_ler

780: and pil.business_group_id = p_business_group_id
781: and nvl(pil.per_in_ler_stat_cd, 'XXXX') not in('BCKDT', 'VOIDD')
782: and pil.lf_evt_ocrd_dt > cv_bckt_csd_lf_evt_ocrd_dt
783: and pil.lf_evt_ocrd_dt < (select lf_evt_ocrd_dt
784: from ben_per_in_ler
785: where per_in_ler_id = p_bckdt_per_in_ler_id
786: and business_group_id = p_business_group_id
787: );
788: --

Line 859: from ben_per_in_ler

855: ler.effective_end_date
856: and ler.typ_cd not in ('IREC','SCHEDDU', 'COMP', 'GSP', 'ABS')
857: and pen.effective_start_date >= (select decode(PRVS_STAT_CD, 'STRTD',STRTD_DT,
858: 'PROCD',PROCD_DT,LF_EVT_OCRD_DT)
859: from ben_per_in_ler
860: where per_in_ler_id = p_bckdt_per_in_ler_id
861: )
862: and rownum = 1 ;
863: --

Line 866: from ben_per_in_ler pil,

862: and rownum = 1 ;
863: --
864: cursor c_prev_pil(p_bckt_csd_lf_evt_ocrd_dt date,p_bckt_csd_per_in_ler_id number ) is
865: select pil.per_in_ler_id
866: from ben_per_in_ler pil,
867: ben_ler_f ler
868: where pil.per_in_ler_id not in (p_per_in_ler_id,p_bckt_csd_per_in_ler_id)
869: and pil.person_id = p_person_id
870: and pil.ler_id = ler.ler_id

Line 876: from ben_per_in_ler pil2

872: ler.effective_start_date and ler.effective_end_date
873: and ler.typ_cd not in ('IREC', 'SCHEDDU', 'COMP', 'GSP', 'ABS')
874: and pil.per_in_ler_stat_cd not in('BCKDT', 'VOIDD')
875: and pil.lf_evt_ocrd_dt in (select max(lf_evt_ocrd_dt)
876: from ben_per_in_ler pil2
877: where pil2.ler_id = pil.ler_id
878: and pil2.per_in_ler_stat_cd not in ('BCKDT', 'VOIDD')
879: and pil2.person_id = p_person_id
880: and pil2.lf_evt_ocrd_dt < p_bckt_csd_lf_evt_ocrd_dt

Line 1720: ben_per_in_ler pil

1716: ,ecd.ovrdn_flag
1717: ,ecd.ovrdn_thru_dt
1718: ,ecd.dpnt_person_id
1719: from ben_elig_cvrd_dpnt_f ecd,
1720: ben_per_in_ler pil
1721: where ecd.business_group_id=p_business_group_id
1722: and p_effective_date between
1723: ecd.effective_start_date and ecd.effective_end_date
1724: and pil.per_in_ler_id=ecd.per_in_ler_id

Line 1742: ben_per_in_ler pil

1738: ,ecd.ovrdn_flag
1739: ,ecd.ovrdn_thru_dt
1740: ,ecd.dpnt_person_id
1741: from ben_elig_cvrd_dpnt_f ecd,
1742: ben_per_in_ler pil
1743: where p_effective_date between
1744: ecd.effective_start_date and ecd.effective_end_date
1745: and pil.per_in_ler_id=ecd.per_in_ler_id
1746: and ecd.elig_per_elctbl_chc_id = p_curr_epe_id

Line 1768: ben_per_in_ler pil

1764: hr_utility.set_location ('Entering '||l_proc,10);
1765: --
1766: select count(*) into l_bckdt_ecd_count
1767: from ben_elig_cvrd_dpnt_f ecd,
1768: ben_per_in_ler pil
1769: where ecd.business_group_id=p_business_group_id
1770: and p_effective_date between
1771: ecd.effective_start_date and ecd.effective_end_date
1772: and pil.per_in_ler_id=ecd.per_in_ler_id

Line 1880: ben_per_in_ler pil

1876: --
1877: cursor c_bckdt_epe_cnt is
1878: select count(*)
1879: from ben_elig_per_elctbl_chc epe,
1880: ben_per_in_ler pil
1881: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
1882: and pil.person_id = p_person_id
1883: and pil.business_group_id = p_business_group_id
1884: AND pil.per_in_ler_id = epe.per_in_ler_id;

Line 1890: ben_per_in_ler pil

1886: --
1887: cursor c_curr_epe_cnt is
1888: select count(*)
1889: from ben_elig_per_elctbl_chc epe,
1890: ben_per_in_ler pil
1891: where pil.per_in_ler_id = p_per_in_ler_id
1892: and pil.person_id = p_person_id
1893: and pil.business_group_id = p_business_group_id
1894: AND pil.per_in_ler_id = epe.per_in_ler_id;

Line 1910: ben_per_in_ler pil

1906: --
1907: cursor c_bckdt_epe_dat is
1908: select epe.*
1909: from ben_elig_per_elctbl_chc epe,
1910: ben_per_in_ler pil
1911: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
1912: and pil.person_id = p_person_id
1913: and pil.business_group_id = p_business_group_id
1914: AND pil.per_in_ler_id = epe.per_in_ler_id;

Line 1920: ben_per_in_ler pil

1916: --
1917: cursor c_curr_epe_dat is
1918: select epe.*
1919: from ben_elig_per_elctbl_chc epe,
1920: ben_per_in_ler pil
1921: where pil.per_in_ler_id = p_per_in_ler_id
1922: and pil.person_id = p_person_id
1923: and pil.business_group_id = p_business_group_id
1924: AND pil.per_in_ler_id = epe.per_in_ler_id;

Line 2267: ben_per_in_ler pil

2263: cursor c_bckdt_epe_cnt is
2264: select count(*)
2265: from ben_elig_per_elctbl_chc epe,
2266: ben_pil_elctbl_chc_popl pel,
2267: ben_per_in_ler pil
2268: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
2269: and pil.person_id = p_person_id
2270: and pil.per_in_ler_id = pel.per_in_ler_id
2271: and (pel.pgm_id = p_pgm_id or

Line 2281: ben_per_in_ler pil

2277: cursor c_curr_epe_cnt is
2278: select count(*)
2279: from ben_elig_per_elctbl_chc epe,
2280: ben_pil_elctbl_chc_popl pel,
2281: ben_per_in_ler pil
2282: where pil.per_in_ler_id = p_per_in_ler_id
2283: and pil.person_id = p_person_id
2284: and pil.per_in_ler_id = pel.per_in_ler_id
2285: and (pel.pgm_id = p_pgm_id or

Line 2304: ben_per_in_ler pil

2300: cursor c_bckdt_epe_dat is
2301: select epe.*
2302: from ben_elig_per_elctbl_chc epe,
2303: ben_pil_elctbl_chc_popl pel,
2304: ben_per_in_ler pil
2305: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
2306: and pil.person_id = p_person_id
2307: and pil.per_in_ler_id = pel.per_in_ler_id
2308: and (pel.pgm_id = p_pgm_id or

Line 2318: ben_per_in_ler pil

2314: cursor c_curr_epe_dat is
2315: select epe.*
2316: from ben_elig_per_elctbl_chc epe,
2317: ben_pil_elctbl_chc_popl pel,
2318: ben_per_in_ler pil
2319: where pil.per_in_ler_id = p_per_in_ler_id
2320: and pil.person_id = p_person_id
2321: and pil.per_in_ler_id = pel.per_in_ler_id
2322: and (pel.pgm_id = p_pgm_id or

Line 2690: ben_per_in_ler pil

2686: --
2687: cursor c_ben_pil_elctbl_chc_popl is
2688: select pel.*
2689: from ben_pil_elctbl_chc_popl pel,
2690: ben_per_in_ler pil
2691: where pil.per_in_ler_id = p_per_in_ler_id
2692: and pil.business_group_id = p_business_group_id
2693: and pel.per_in_ler_id = pil.per_in_ler_id
2694: and pel.business_group_id = pil.business_group_id;

Line 3115: ben_per_in_ler pil

3111: pen.RPLCS_SSPNDD_RSLT_ID,
3112: pen.SSPNDD_FLAG,
3113: pen.UOM
3114: from ben_prtt_enrt_rslt_f pen,
3115: ben_per_in_ler pil
3116: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
3117: and pil.person_id = p_person_id
3118: and pil.business_group_id = p_business_group_id
3119: AND pil.per_in_ler_id = pen.per_in_ler_id

Line 3201: ben_per_in_ler pil

3197: pen.RPLCS_SSPNDD_RSLT_ID,
3198: pen.SSPNDD_FLAG,
3199: pen.UOM
3200: from ben_le_clsn_n_rstr pen,
3201: ben_per_in_ler pil
3202: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
3203: and pil.person_id = p_person_id
3204: and pil.business_group_id = p_business_group_id
3205: AND pil.per_in_ler_id = pen.per_in_ler_id

Line 3213: ben_per_in_ler pil

3209: --
3210: cursor c_curr_pen_dat is
3211: select pen.*
3212: from ben_prtt_enrt_rslt_f pen,
3213: ben_per_in_ler pil
3214: where pil.per_in_ler_id = p_per_in_ler_id
3215: and pil.person_id = p_person_id
3216: and pil.business_group_id = p_business_group_id
3217: AND pil.per_in_ler_id = pen.per_in_ler_id

Line 3242: ben_per_in_ler pil

3238: -- imputed income as they are not considered in c_curr_pen_dat
3239: --
3240: select count(*) into l_bckdt_pen_cnt_temp
3241: from ben_prtt_enrt_rslt_f pen,
3242: ben_per_in_ler pil
3243: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
3244: and pil.person_id = p_person_id
3245: and pil.business_group_id = p_business_group_id
3246: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')

Line 3251: ben_per_in_ler pil

3247: AND pil.per_in_ler_id = pen.per_in_ler_id;
3248: --
3249: select count(*) into l_bckdt_pen_cnt
3250: from ben_le_clsn_n_rstr pen,
3251: ben_per_in_ler pil
3252: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
3253: and pil.person_id = p_person_id
3254: and pil.business_group_id = p_business_group_id
3255: AND pil.per_in_ler_id = pen.per_in_ler_id

Line 3533: from ben_per_in_ler csd_pil,

3529: -- backed out per in ler.
3530: --
3531: cursor c_bckt_csd_pil is
3532: select csd_pil.lf_evt_ocrd_dt
3533: from ben_per_in_ler csd_pil,
3534: ben_per_in_ler bckt_pil
3535: where bckt_pil.per_in_ler_id = p_bckdt_per_in_ler_id
3536: and bckt_pil.BCKT_PER_IN_LER_ID = csd_pil.per_in_ler_id
3537: and bckt_pil.business_group_id = p_business_group_id

Line 3534: ben_per_in_ler bckt_pil

3530: --
3531: cursor c_bckt_csd_pil is
3532: select csd_pil.lf_evt_ocrd_dt
3533: from ben_per_in_ler csd_pil,
3534: ben_per_in_ler bckt_pil
3535: where bckt_pil.per_in_ler_id = p_bckdt_per_in_ler_id
3536: and bckt_pil.BCKT_PER_IN_LER_ID = csd_pil.per_in_ler_id
3537: and bckt_pil.business_group_id = p_business_group_id
3538: and csd_pil.business_group_id = p_business_group_id;

Line 3549: from ben_per_in_ler pil,

3545: -- iREC : do not consider iRec, ABS, COMP, GSP pils.
3546: --
3547: cursor c_inter_pil_cnt(cv_bckt_csd_lf_evt_ocrd_dt date) is
3548: select pil.per_in_ler_id, pil.object_version_number
3549: from ben_per_in_ler pil,
3550: ben_ler_f ler
3551: where pil.per_in_ler_id <> p_per_in_ler_id
3552: and pil.per_in_ler_id <> p_bckdt_per_in_ler_id
3553: and pil.person_id = p_person_id

Line 3562: from ben_per_in_ler

3558: and pil.business_group_id = p_business_group_id
3559: and nvl(pil.per_in_ler_stat_cd, 'XXXX') not in('BCKDT', 'VOIDD')
3560: and pil.lf_evt_ocrd_dt > cv_bckt_csd_lf_evt_ocrd_dt
3561: and pil.lf_evt_ocrd_dt < (select lf_evt_ocrd_dt
3562: from ben_per_in_ler
3563: where per_in_ler_id = p_bckdt_per_in_ler_id
3564: and business_group_id = p_business_group_id
3565: );
3566: --

Line 3621: ben_per_in_ler pil

3617: pen.PL_ID,
3618: pen.PL_TYP_ID,
3619: pen.PTIP_ID
3620: from ben_prtt_enrt_rslt_f pen,
3621: ben_per_in_ler pil
3622: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
3623: and pil.person_id = p_person_id
3624: and pil.business_group_id = p_business_group_id
3625: and pil.per_in_ler_id = pen.per_in_ler_id

Line 3637: ben_per_in_ler pil

3633: pen.PL_ID,
3634: pen.PL_TYP_ID,
3635: pen.PTIP_ID
3636: from ben_le_clsn_n_rstr pen,
3637: ben_per_in_ler pil
3638: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
3639: and pil.person_id = p_person_id
3640: and pil.business_group_id = p_business_group_id
3641: AND pil.per_in_ler_id = pen.per_in_ler_id

Line 3658: ben_per_in_ler pil

3654: pen.PL_TYP_ID,
3655: pen.PTIP_ID,
3656: pen.effective_start_date
3657: from ben_prtt_enrt_rslt_f pen,
3658: ben_per_in_ler pil
3659: where pil.per_in_ler_id = p_per_in_ler_id
3660: and pil.person_id = p_person_id
3661: and pil.business_group_id = p_business_group_id
3662: and pil.per_in_ler_id = pen.per_in_ler_id

Line 4762: ben_per_in_ler pil

4758: --
4759: cursor c_pen_dpnts(cp_dpnt_person_id in number) is
4760: select pdp.*
4761: from ben_elig_cvrd_dpnt_f pdp ,
4762: ben_per_in_ler pil
4763: where pdp.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4764: and pdp.cvg_strt_dt is not null
4765: and nvl(pdp.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
4766: and pdp.business_group_id = p_business_group_id

Line 5613: from ben_per_in_ler pil

5609: l_proc varchar2(72) := g_package||'.reinstate_the_prev_enrt';
5610: --
5611: cursor c_bckdt_pil is
5612: select pil.PRVS_STAT_CD, pil.object_version_number, pil.BCKT_PER_IN_LER_ID
5613: from ben_per_in_ler pil
5614: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
5615: and pil.business_group_id = p_business_group_id;
5616: --
5617: l_bckt_csd_per_in_ler_id number;

Line 5708: ben_per_in_ler pil

5704: pen.RPLCS_SSPNDD_RSLT_ID,
5705: pen.SSPNDD_FLAG,
5706: pen.UOM
5707: from ben_prtt_enrt_rslt_f pen,
5708: ben_per_in_ler pil
5709: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
5710: and pil.person_id = p_person_id
5711: and pil.business_group_id = p_business_group_id
5712: and pil.per_in_ler_id = pen.per_in_ler_id

Line 5726: ben_per_in_ler pil_inner

5722: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
5723: and pen.prtt_enrt_rslt_id not in (
5724: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)
5725: from ben_prtt_enrt_rslt_f pen_inner,
5726: ben_per_in_ler pil_inner
5727: where pil_inner.per_in_ler_id = p_bckdt_per_in_ler_id
5728: and pil_inner.person_id = p_person_id
5729: and pil_inner.business_group_id = p_business_group_id
5730: and pil_inner.per_in_ler_id = pen_inner.per_in_ler_id

Line 5738: ben_per_in_ler pil_inner

5734: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
5735: union
5736: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)
5737: from ben_le_clsn_n_rstr pen_inner,
5738: ben_per_in_ler pil_inner
5739: where pil_inner.per_in_ler_id = p_bckdt_per_in_ler_id
5740: and pil_inner.person_id = p_person_id
5741: and pil_inner.business_group_id = p_business_group_id
5742: AND pil_inner.per_in_ler_id = pen_inner.per_in_ler_id

Line 5829: ben_per_in_ler pil

5825: pen.RPLCS_SSPNDD_RSLT_ID,
5826: pen.SSPNDD_FLAG,
5827: pen.UOM
5828: from ben_le_clsn_n_rstr pen,
5829: ben_per_in_ler pil
5830: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
5831: and pil.person_id = p_person_id
5832: and pil.business_group_id = p_business_group_id
5833: AND pil.per_in_ler_id = pen.per_in_ler_id

Line 5844: ben_per_in_ler pil_inner

5840: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
5841: and pen.bkup_tbl_id not in (
5842: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)
5843: from ben_prtt_enrt_rslt_f pen_inner,
5844: ben_per_in_ler pil_inner
5845: where pil_inner.per_in_ler_id = p_bckdt_per_in_ler_id
5846: and pil_inner.person_id = p_person_id
5847: and pil_inner.business_group_id = p_business_group_id
5848: and pil_inner.per_in_ler_id = pen_inner.per_in_ler_id

Line 5856: ben_per_in_ler pil_inner

5852: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
5853: union
5854: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)
5855: from ben_le_clsn_n_rstr pen_inner,
5856: ben_per_in_ler pil_inner
5857: where pil_inner.per_in_ler_id = p_bckdt_per_in_ler_id
5858: and pil_inner.person_id = p_person_id
5859: and pil_inner.business_group_id = p_business_group_id
5860: AND pil_inner.per_in_ler_id = pen_inner.per_in_ler_id

Line 5881: ben_per_in_ler pil,

5877: pel.enrt_perd_strt_dt,
5878: to_date('31-12-4712','DD-MM-YYYY') enrt_cvg_end_dt,
5879: pel.dflt_enrt_dt
5880: from ben_elig_per_elctbl_chc epe,
5881: ben_per_in_ler pil,
5882: ben_pil_elctbl_chc_popl pel
5883: where epe.per_in_ler_id = p_per_in_ler_id
5884: and epe.business_group_id = p_business_group_id
5885: and epe.pl_id = cp_pl_id

Line 6017: ben_per_in_ler pil

6013: --
6014: cursor c_bckt_csd_pen(cv_per_in_ler_id in number) is
6015: select pen.*, pil.lf_evt_ocrd_dt
6016: from ben_prtt_enrt_rslt_f pen,
6017: ben_per_in_ler pil
6018: where pen.per_in_ler_id = cv_per_in_ler_id
6019: and pen.per_in_ler_id = pil.per_in_ler_id
6020: and pen.business_group_id = p_business_group_id
6021: and pil.business_group_id = p_business_group_id

Line 7115: -- added to the ben_per_in_ler.

7111: -- 9999 do I need to void any other data, status etc.,
7112: --
7113: -- Now restore the backed out pil to Started status.
7114: -- It should be restored to the prev status 99999 once the column is
7115: -- added to the ben_per_in_ler.
7116: --
7117: reinstate_the_prev_enrt(
7118: p_person_id => p_person_id
7119: ,p_business_group_id => p_business_group_id

Line 7503: from ben_per_in_ler pil

7499: ) is
7500: --
7501: cursor c_pil(p_per_in_ler_id in number) is
7502: select pil.object_version_number
7503: from ben_per_in_ler pil
7504: where pil.per_in_ler_id = p_per_in_ler_id;
7505: --
7506: cursor c_multiple_rate is
7507: select null

Line 7646: from ben_per_in_ler pil

7642: l_proc varchar2(72) := g_package||'.reinstate_prev_enrt_for_popl';
7643: --
7644: cursor c_bckdt_pil is
7645: select pil.PRVS_STAT_CD, pil.object_version_number, pil.BCKT_PER_IN_LER_ID
7646: from ben_per_in_ler pil
7647: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
7648: and pil.business_group_id = p_business_group_id;
7649: --
7650: l_bckt_csd_per_in_ler_id number;

Line 7749: ben_per_in_ler pil

7745: --
7746: cursor c_bckt_csd_pen(cv_per_in_ler_id in number) is
7747: select pen.*, pil.lf_evt_ocrd_dt
7748: from ben_prtt_enrt_rslt_f pen,
7749: ben_per_in_ler pil
7750: where pen.per_in_ler_id = cv_per_in_ler_id
7751: and pen.per_in_ler_id = pil.per_in_ler_id
7752: and pen.business_group_id = p_business_group_id
7753: and pil.business_group_id = p_business_group_id

Line 9141: from ben_per_in_ler pil,

9137: and per_in_ler_id = p_bckdt_per_in_ler_id;
9138: --
9139: cursor c_bckdt_pil is
9140: select ler.name, pil.PRVS_STAT_CD, pil.object_version_number, pil.BCKT_PER_IN_LER_ID
9141: from ben_per_in_ler pil,
9142: ben_ler_f ler
9143: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
9144: and ler.ler_id = pil.ler_id
9145: and p_effective_date between ler.effective_start_date

Line 9205: ben_per_in_ler pil_inner

9201: pen_inner.enrt_cvg_strt_dt,
9202: pen_inner.enrt_cvg_thru_dt,
9203: pen_inner.object_version_number
9204: FROM ben_le_clsn_n_rstr pen_inner,
9205: ben_per_in_ler pil_inner
9206: WHERE pil_inner.per_in_ler_id = p_bckdt_per_in_ler_id
9207: AND pil_inner.person_id = p_person_id
9208: AND pil_inner.business_group_id = p_business_group_id
9209: AND pil_inner.per_in_ler_id = pen_inner.per_in_ler_id

Line 9961: from ben_per_in_ler pil

9957: --
9958: cursor c_bckdt_pil is
9959: select pil.PER_IN_LER_STAT_CD, pil.object_version_number,
9960: pil.lf_evt_ocrd_dt
9961: from ben_per_in_ler pil
9962: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
9963: and pil.business_group_id = p_business_group_id;
9964:
9965:

Line 10050: ben_per_in_ler pil

10046: pen.RPLCS_SSPNDD_RSLT_ID,
10047: pen.SSPNDD_FLAG,
10048: pen.UOM
10049: from ben_le_clsn_n_rstr pen,
10050: ben_per_in_ler pil
10051: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
10052: and pil.person_id = p_person_id
10053: and pil.business_group_id = p_business_group_id
10054: AND pil.per_in_ler_id = pen.per_in_ler_id

Line 10065: ben_per_in_ler pil_inner

10061: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
10062: and pen.bkup_tbl_id not in (
10063: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)
10064: from ben_prtt_enrt_rslt_f pen_inner,
10065: ben_per_in_ler pil_inner
10066: where pil_inner.per_in_ler_id = p_bckdt_per_in_ler_id
10067: and pil_inner.person_id = p_person_id
10068: and pil_inner.business_group_id = p_business_group_id
10069: and pil_inner.per_in_ler_id = pen_inner.per_in_ler_id

Line 10077: ben_per_in_ler pil_inner

10073: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
10074: union
10075: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)
10076: from ben_le_clsn_n_rstr pen_inner,
10077: ben_per_in_ler pil_inner
10078: where pil_inner.per_in_ler_id = p_bckdt_per_in_ler_id
10079: and pil_inner.person_id = p_person_id
10080: and pil_inner.business_group_id = p_business_group_id
10081: AND pil_inner.per_in_ler_id = pen_inner.per_in_ler_id

Line 10103: ben_per_in_ler pil,

10099: pel.enrt_perd_strt_dt,
10100: to_date('31-12-4712','DD-MM-YYYY') enrt_cvg_end_dt,
10101: pel.dflt_enrt_dt
10102: from ben_elig_per_elctbl_chc epe,
10103: ben_per_in_ler pil,
10104: ben_pil_elctbl_chc_popl pel
10105: where epe.per_in_ler_id = cp_per_in_ler_id
10106: and epe.business_group_id = p_business_group_id
10107: and epe.pl_id = cp_pl_id

Line 10246: ben_per_in_ler pil

10242: --
10243: cursor c_bckt_csd_pen(cv_per_in_ler_id in number) is
10244: select pen.*, pil.lf_evt_ocrd_dt
10245: from ben_prtt_enrt_rslt_f pen,
10246: ben_per_in_ler pil
10247: where pen.per_in_ler_id = cv_per_in_ler_id
10248: and pen.per_in_ler_id = pil.per_in_ler_id
10249: and pen.business_group_id = p_business_group_id
10250: and pil.business_group_id = p_business_group_id