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_ENROLMENT_REQUIREMENTS dependencies on HR_API

Line 1449: AND pen.effective_end_date = hr_api.g_eot

1445: SELECT pen.enrt_cvg_strt_dt enrt_cvg_strt_dt
1446: FROM ben_prtt_enrt_rslt_f pen, ben_pl_f pl, ben_oipl_f oipl
1447: WHERE pen.person_id = p_person_id
1448: AND pen.business_group_id = p_business_group_id
1449: AND pen.effective_end_date = hr_api.g_eot
1450: AND l_lf_evt_ocrd_dt_1 BETWEEN pen.enrt_cvg_strt_dt
1451: AND pen.enrt_cvg_thru_dt
1452: AND pl.pl_id = pen.pl_id
1453: AND pl.business_group_id = p_business_group_id

Line 1482: AND pen.effective_end_date = hr_api.g_eot

1478: ben_oipl_f oipl,
1479: ben_elig_cvrd_dpnt_f pdp
1480: WHERE pdp.dpnt_person_id = p_person_id
1481: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
1482: AND pen.effective_end_date = hr_api.g_eot
1483: AND pdp.effective_end_date = hr_api.g_eot
1484: AND pdp.business_group_id = p_business_group_id
1485: AND pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1486: AND pen.business_group_id = p_business_group_id

Line 1483: AND pdp.effective_end_date = hr_api.g_eot

1479: ben_elig_cvrd_dpnt_f pdp
1480: WHERE pdp.dpnt_person_id = p_person_id
1481: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
1482: AND pen.effective_end_date = hr_api.g_eot
1483: AND pdp.effective_end_date = hr_api.g_eot
1484: AND pdp.business_group_id = p_business_group_id
1485: AND pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1486: AND pen.business_group_id = p_business_group_id
1487: AND l_lf_evt_ocrd_dt_1 BETWEEN pen.enrt_cvg_strt_dt

Line 1546: pen.enrt_cvg_thru_dt = hr_api.g_eot

1542: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1543: -- AND pen.sspndd_flag = 'N' --CFW
1544: AND (pen.sspndd_flag = 'N' --CFW
1545: OR (pen.sspndd_flag = 'Y' and
1546: pen.enrt_cvg_thru_dt = hr_api.g_eot
1547: )
1548: )
1549: AND pen.effective_end_date = hr_api.g_eot
1550: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt

Line 1549: AND pen.effective_end_date = hr_api.g_eot

1545: OR (pen.sspndd_flag = 'Y' and
1546: pen.enrt_cvg_thru_dt = hr_api.g_eot
1547: )
1548: )
1549: AND pen.effective_end_date = hr_api.g_eot
1550: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt
1551: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
1552: AND p_pl_id = pen.pl_id
1553: AND (

Line 1570: pen.enrt_cvg_thru_dt = hr_api.g_eot

1566: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1567: -- AND pen.sspndd_flag = 'N' --CFW
1568: AND (pen.sspndd_flag = 'N' --CFW
1569: OR (pen.sspndd_flag = 'Y' and
1570: pen.enrt_cvg_thru_dt = hr_api.g_eot
1571: )
1572: )
1573: AND pen.effective_end_date = hr_api.g_eot
1574: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt

Line 1573: AND pen.effective_end_date = hr_api.g_eot

1569: OR (pen.sspndd_flag = 'Y' and
1570: pen.enrt_cvg_thru_dt = hr_api.g_eot
1571: )
1572: )
1573: AND pen.effective_end_date = hr_api.g_eot
1574: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt
1575: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
1576: AND p_pl_id = pen.pl_id
1577: AND pen.pgm_id = p_pgm_id ;

Line 1587: AND pen.effective_end_date = hr_api.g_eot

1583: FROM ben_prtt_enrt_rslt_f pen
1584: WHERE pen.person_id = p_person_id
1585: AND pen.business_group_id = p_business_group_id
1586: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1587: AND pen.effective_end_date = hr_api.g_eot
1588: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt
1589: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
1590: AND g_ptip_id = pen.ptip_id
1591: AND pen.pgm_id = p_pgm_id ;

Line 1601: AND pen.effective_end_date = hr_api.g_eot

1597: FROM ben_prtt_enrt_rslt_f pen
1598: WHERE pen.person_id = p_person_id
1599: AND pen.business_group_id = p_business_group_id
1600: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1601: AND pen.effective_end_date = hr_api.g_eot
1602: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt
1603: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
1604: AND pen.pgm_id = p_pgm_id ;
1605:

Line 1615: AND pen.effective_end_date = hr_api.g_eot

1611: WHERE pen.person_id = p_person_id
1612: AND pen.business_group_id = p_business_group_id
1613: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1614: AND pen.sspndd_flag = 'N'
1615: AND pen.effective_end_date = hr_api.g_eot
1616: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt
1617: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
1618: AND g_ptip_id = pen.ptip_id
1619: AND pln.pl_id = pen.pl_id

Line 1631: AND pen.effective_end_date = hr_api.g_eot

1627: CURSOR c_plan_cvg_info IS
1628: SELECT pen.enrt_cvg_strt_dt enrt_cvg_strt_dt
1629: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp
1630: WHERE pdp.dpnt_person_id = p_person_id
1631: AND pen.effective_end_date = hr_api.g_eot
1632: AND pdp.effective_end_date = hr_api.g_eot
1633: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
1634: AND pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1635: AND pen.business_group_id = p_business_group_id

Line 1632: AND pdp.effective_end_date = hr_api.g_eot

1628: SELECT pen.enrt_cvg_strt_dt enrt_cvg_strt_dt
1629: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp
1630: WHERE pdp.dpnt_person_id = p_person_id
1631: AND pen.effective_end_date = hr_api.g_eot
1632: AND pdp.effective_end_date = hr_api.g_eot
1633: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
1634: AND pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1635: AND pen.business_group_id = p_business_group_id
1636: AND pen.prtt_enrt_rslt_stat_cd IS NULL

Line 1640: pen.enrt_cvg_thru_dt = hr_api.g_eot

1636: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1637: -- AND pen.sspndd_flag = 'N'
1638: AND (pen.sspndd_flag = 'N' --CFW
1639: OR (pen.sspndd_flag = 'Y' and
1640: pen.enrt_cvg_thru_dt = hr_api.g_eot
1641: )
1642: )
1643: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt
1644: AND pen.enrt_cvg_thru_dt < pen.effective_end_date

Line 1665: pen.enrt_cvg_thru_dt = hr_api.g_eot

1661: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1662: --AND pen.sspndd_flag = 'N'
1663: AND (pen.sspndd_flag = 'N' --CFW
1664: OR (pen.sspndd_flag = 'Y' and
1665: pen.enrt_cvg_thru_dt = hr_api.g_eot
1666: )
1667: )
1668: AND pen.effective_end_date = hr_api.g_eot
1669: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt

Line 1668: AND pen.effective_end_date = hr_api.g_eot

1664: OR (pen.sspndd_flag = 'Y' and
1665: pen.enrt_cvg_thru_dt = hr_api.g_eot
1666: )
1667: )
1668: AND pen.effective_end_date = hr_api.g_eot
1669: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt
1670: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
1671: AND g_ptip_id = pen.ptip_id
1672: AND plip.pgm_id = pen.pgm_id

Line 2356: and rslt.enrt_cvg_thru_dt = hr_api.g_eot; -- Bug 4388226 - End-dated suspended enrl shudn't be picked up.

2352: -- and rslt.prtt_enrt_rslt_stat_cd NOT IN ('BCKDT', 'VOIDD')
2353: and rslt.prtt_enrt_rslt_stat_cd is null
2354: and ler.typ_cd not in ('COMP','ABS', 'GSP', 'IREC','SCHEDDU' )
2355: and rslt.business_group_id = p_business_group_id
2356: and rslt.enrt_cvg_thru_dt = hr_api.g_eot; -- Bug 4388226 - End-dated suspended enrl shudn't be picked up.
2357:
2358: --
2359:
2360: begin

Line 2850: pen.enrt_cvg_thru_dt = hr_api.g_eot

2846: WHERE pen.person_id = p_person_id
2847: AND pen.business_group_id = p_business_group_id
2848: AND (pen.sspndd_flag = 'N' --CFW
2849: OR (pen.sspndd_flag = 'Y' and
2850: pen.enrt_cvg_thru_dt = hr_api.g_eot
2851: )
2852: )
2853: AND pen.prtt_enrt_rslt_stat_cd IS NULL
2854: AND pen.effective_end_date = hr_api.g_eot

Line 2854: AND pen.effective_end_date = hr_api.g_eot

2850: pen.enrt_cvg_thru_dt = hr_api.g_eot
2851: )
2852: )
2853: AND pen.prtt_enrt_rslt_stat_cd IS NULL
2854: AND pen.effective_end_date = hr_api.g_eot
2855: AND p_cvg_dt <= pen.enrt_cvg_thru_dt
2856: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
2857: AND pen.oipl_id IS NULL
2858: AND l_pl_id = pen.pl_id

Line 2884: pen.enrt_cvg_thru_dt = hr_api.g_eot

2880: WHERE pen.person_id = p_person_id
2881: AND pen.business_group_id = p_business_group_id
2882: AND (pen.sspndd_flag = 'N' --CFW
2883: OR (pen.sspndd_flag = 'Y' and
2884: pen.enrt_cvg_thru_dt = hr_api.g_eot
2885: )
2886: )
2887: AND pen.prtt_enrt_rslt_stat_cd IS NULL
2888: AND pen.effective_end_date = hr_api.g_eot

Line 2888: AND pen.effective_end_date = hr_api.g_eot

2884: pen.enrt_cvg_thru_dt = hr_api.g_eot
2885: )
2886: )
2887: AND pen.prtt_enrt_rslt_stat_cd IS NULL
2888: AND pen.effective_end_date = hr_api.g_eot
2889: AND p_cvg_dt <= pen.enrt_cvg_thru_dt
2890: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
2891: AND p_oipl_id = pen.oipl_id
2892: AND (

Line 2909: AND pen.effective_end_date = hr_api.g_eot

2905: p_pl_typ_id in number) is
2906: SELECT 'Y'
2907: FROM ben_prtt_enrt_rslt_f pen
2908: WHERE pen.person_id = p_person_id
2909: AND pen.effective_end_date = hr_api.g_eot
2910: AND pen.enrt_cvg_strt_dt > p_enrt_cvg_thru_dt
2911: ANd pen.pl_typ_id = p_pl_typ_id
2912: AND (
2913: ( pen.pgm_id = p_pgm_id

Line 2928: AND pdp.effective_end_date = hr_api.g_eot

2924: CURSOR c_plan_cvg_info IS
2925: SELECT 'Y'
2926: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp
2927: WHERE pdp.dpnt_person_id = p_person_id
2928: AND pdp.effective_end_date = hr_api.g_eot
2929: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
2930: AND pdp.business_group_id = p_business_group_id
2931: AND pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
2932: AND pen.business_group_id = p_business_group_id

Line 2935: AND pen.effective_end_date = hr_api.g_eot

2931: AND pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
2932: AND pen.business_group_id = p_business_group_id
2933: AND pen.sspndd_flag = 'N'
2934: AND pen.prtt_enrt_rslt_stat_cd IS NULL
2935: AND pen.effective_end_date = hr_api.g_eot
2936: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt
2937: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
2938: AND l_pl_id = pen.pl_id
2939: AND (

Line 2952: AND pdp.effective_end_date = hr_api.g_eot

2948: CURSOR c_oipl_cvg_info IS
2949: SELECT 'Y'
2950: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp
2951: WHERE pdp.dpnt_person_id = p_person_id
2952: AND pdp.effective_end_date = hr_api.g_eot
2953: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
2954: AND pdp.business_group_id = p_business_group_id
2955: AND pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
2956: AND pen.business_group_id = p_business_group_id

Line 2959: AND pen.effective_end_date = hr_api.g_eot

2955: AND pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
2956: AND pen.business_group_id = p_business_group_id
2957: AND pen.sspndd_flag = 'N'
2958: AND pen.prtt_enrt_rslt_stat_cd IS NULL
2959: AND pen.effective_end_date = hr_api.g_eot
2960: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt
2961: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
2962: AND p_oipl_id = pen.oipl_id
2963: AND (

Line 3418: AND pen.effective_end_date = hr_api.g_eot

3414: pen.person_id = p_person_id
3415: AND pen.business_group_id = p_business_group_id
3416: AND pen.prtt_enrt_rslt_stat_cd IS NULL
3417: AND pen.sspndd_flag = 'N'
3418: AND pen.effective_end_date = hr_api.g_eot
3419: AND pen.enrt_cvg_thru_dt >= l_lf_evt_ocrd_dt_1
3420: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
3421: AND pen.pl_id = l_pl_id
3422: -- get enrolled oipl

Line 3437: AND pdp.effective_end_date = hr_api.g_eot

3433: FROM ben_prtt_enrt_rslt_f pen,
3434: ben_elig_cvrd_dpnt_f pdp,
3435: ben_oipl_f enrd_oipl
3436: WHERE pdp.dpnt_person_id = p_person_id
3437: AND pdp.effective_end_date = hr_api.g_eot
3438: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
3439: AND pdp.business_group_id = p_business_group_id
3440: AND pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
3441: -- get result for plan if exists

Line 3445: AND pen.effective_end_date = hr_api.g_eot

3441: -- get result for plan if exists
3442: AND pen.business_group_id = p_business_group_id
3443: AND pen.prtt_enrt_rslt_stat_cd IS NULL
3444: AND pen.sspndd_flag = 'N'
3445: AND pen.effective_end_date = hr_api.g_eot
3446: AND pen.enrt_cvg_thru_dt >= l_lf_evt_ocrd_dt_1
3447: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
3448: AND pen.pl_id = l_pl_id
3449: -- get enrolled oipl

Line 3819: IF l_crnt_enrt_cvg_thru_dt <> hr_api.g_eot THEN

3815: END IF;
3816: --
3817: ELSE
3818: --BUG 6519487 fix
3819: IF l_crnt_enrt_cvg_thru_dt <> hr_api.g_eot THEN
3820: OPEN c_future_results (p_person_id ,
3821: l_crnt_enrt_cvg_thru_dt,
3822: p_pgm_id ,
3823: l_current_pl_typ_id) ;

Line 3875: IF l_crnt_enrt_cvg_thru_dt <> hr_api.g_eot THEN

3871: END IF;
3872: --
3873: ELSE
3874: ----BUG 6519487 fix
3875: IF l_crnt_enrt_cvg_thru_dt <> hr_api.g_eot THEN
3876: OPEN c_future_results (p_person_id ,
3877: l_crnt_enrt_cvg_thru_dt,
3878: p_pgm_id ,
3879: l_current_pl_typ_id) ;

Line 5261: l_rec_enrt_perd_end_dt := hr_api.g_eot;

5257: END IF; -- Need to get program level enrolment period info
5258: -- Bug 2200139 Override Enrollments
5259: ELSIF l_unrestricted_enrt_flag = 'Y' OR p_run_mode = 'V' THEN
5260: l_rec_enrt_perd_strt_dt := l_lf_evt_ocrd_dt_fetch;
5261: l_rec_enrt_perd_end_dt := hr_api.g_eot;
5262: l_rec_procg_end_dt := hr_api.g_eot;
5263: l_rec_dflt_asnmt_dt := l_lf_evt_ocrd_dt_fetch;
5264: l_rec_enrt_typ_cycl_cd := 'U';
5265: l_rec_cls_enrt_dt_to_use_cd := 'ELCNSMADE';

Line 5262: l_rec_procg_end_dt := hr_api.g_eot;

5258: -- Bug 2200139 Override Enrollments
5259: ELSIF l_unrestricted_enrt_flag = 'Y' OR p_run_mode = 'V' THEN
5260: l_rec_enrt_perd_strt_dt := l_lf_evt_ocrd_dt_fetch;
5261: l_rec_enrt_perd_end_dt := hr_api.g_eot;
5262: l_rec_procg_end_dt := hr_api.g_eot;
5263: l_rec_dflt_asnmt_dt := l_lf_evt_ocrd_dt_fetch;
5264: l_rec_enrt_typ_cycl_cd := 'U';
5265: l_rec_cls_enrt_dt_to_use_cd := 'ELCNSMADE';
5266: END IF; -- run_mode cases

Line 7969: pen.enrt_cvg_thru_dt = hr_api.g_eot

7965: AND pen.prtt_enrt_rslt_stat_cd IS NULL
7966: -- AND pen.sspndd_flag = 'N' --CFW
7967: AND (pen.sspndd_flag = 'N' --CFW
7968: OR (pen.sspndd_flag = 'Y' and
7969: pen.enrt_cvg_thru_dt = hr_api.g_eot
7970: )
7971: )
7972: AND pen.effective_end_date = hr_api.g_eot
7973: AND l_lf_evt_ocrd_dt <= pen.enrt_cvg_thru_dt

Line 7972: AND pen.effective_end_date = hr_api.g_eot

7968: OR (pen.sspndd_flag = 'Y' and
7969: pen.enrt_cvg_thru_dt = hr_api.g_eot
7970: )
7971: )
7972: AND pen.effective_end_date = hr_api.g_eot
7973: AND l_lf_evt_ocrd_dt <= pen.enrt_cvg_thru_dt
7974: AND l_lf_evt_ocrd_dt >= pen.enrt_cvg_strt_dt
7975: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
7976: AND p_pl_id = pen.pl_id

Line 7994: pen.enrt_cvg_thru_dt = hr_api.g_eot

7990: AND pen.business_group_id = p_business_group_id
7991: -- AND pen.sspndd_flag = 'N' --CFW
7992: AND (pen.sspndd_flag = 'N' --CFW
7993: OR (pen.sspndd_flag = 'Y' and
7994: pen.enrt_cvg_thru_dt = hr_api.g_eot
7995: )
7996: )
7997: AND pen.prtt_enrt_rslt_stat_cd IS NULL
7998: AND pen.effective_end_date = hr_api.g_eot

Line 7998: AND pen.effective_end_date = hr_api.g_eot

7994: pen.enrt_cvg_thru_dt = hr_api.g_eot
7995: )
7996: )
7997: AND pen.prtt_enrt_rslt_stat_cd IS NULL
7998: AND pen.effective_end_date = hr_api.g_eot
7999: AND l_lf_evt_ocrd_dt <= pen.enrt_cvg_thru_dt
8000: AND l_lf_evt_ocrd_dt >= pen.enrt_cvg_strt_dt
8001: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
8002: AND p_oipl_id = pen.oipl_id

Line 8020: pen.enrt_cvg_thru_dt = hr_api.g_eot

8016: AND pen.prtt_enrt_rslt_stat_cd IS NULL
8017: -- AND pen.sspndd_flag = 'N'
8018: AND (pen.sspndd_flag = 'N' --CFW
8019: OR (pen.sspndd_flag = 'Y' and
8020: pen.enrt_cvg_thru_dt = hr_api.g_eot
8021: )
8022: )
8023: AND pen.effective_end_date = hr_api.g_eot
8024: AND

Line 8023: AND pen.effective_end_date = hr_api.g_eot

8019: OR (pen.sspndd_flag = 'Y' and
8020: pen.enrt_cvg_thru_dt = hr_api.g_eot
8021: )
8022: )
8023: AND pen.effective_end_date = hr_api.g_eot
8024: AND
8025: -- nvl(p_lf_evt_ocrd_dt,p_effective_date) between
8026: -- pen.effective_start_date and pen.effective_end_date and
8027: l_lf_evt_ocrd_dt <= pen.enrt_cvg_thru_dt

Line 9408: AND pen.effective_end_date = hr_api.g_eot

9404: WHERE pen.person_id = p_person_id
9405: AND pen.business_group_id = p_business_group_id
9406: AND pen.prtt_enrt_rslt_stat_cd IS NULL
9407: AND pen.sspndd_flag = 'N'
9408: AND pen.effective_end_date = hr_api.g_eot
9409: AND l_effective_date_1 < pen.enrt_cvg_thru_dt
9410: AND pen.prtt_enrt_rslt_id <> p_prtt_enrt_rslt_id
9411: AND (
9412: ( pen.pgm_id = p_pgm_id

Line 9429: AND pen.effective_end_date = hr_api.g_eot

9425: WHERE pen.person_id = p_person_id
9426: AND pen.business_group_id = p_business_group_id
9427: AND pen.prtt_enrt_rslt_stat_cd IS NULL
9428: -- AND pen.sspndd_flag = 'N' --CFW
9429: AND pen.effective_end_date = hr_api.g_eot
9430: AND l_effective_date_1 < pen.enrt_cvg_thru_dt
9431: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
9432: AND pen.prtt_enrt_rslt_id <> p_prtt_enrt_rslt_id
9433: AND (

Line 9450: AND pen.effective_end_date = hr_api.g_eot

9446: WHERE pen.person_id = p_person_id
9447: AND pen.business_group_id = p_business_group_id
9448: AND pen.prtt_enrt_rslt_stat_cd IS NULL
9449: AND pen.sspndd_flag = 'N'
9450: AND pen.effective_end_date = hr_api.g_eot
9451: AND l_effective_date_1 < pen.enrt_cvg_thru_dt
9452: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
9453: AND pen.prtt_enrt_rslt_id <> p_prtt_enrt_rslt_id
9454: AND (

Line 9469: AND pen.effective_end_date = hr_api.g_eot

9465: SELECT pen.*
9466: FROM ben_prtt_enrt_rslt_f pen, ben_pl_f pl, ben_oipl_f oipl
9467: WHERE pen.person_id = p_person_id
9468: AND pen.business_group_id = p_business_group_id
9469: AND pen.effective_end_date = hr_api.g_eot
9470: AND l_effective_date_1 BETWEEN pen.enrt_cvg_strt_dt
9471: AND pen.enrt_cvg_thru_dt
9472: AND pl.pl_id = pen.pl_id
9473: and pen.oipl_id = p_oipl_id /* bug 1527086 */

Line 9683: pen.enrt_cvg_thru_dt = hr_api.g_eot

9679: AND pen.business_group_id = p_business_group_id
9680: -- AND pen.sspndd_flag = 'N' --CFW
9681: AND (pen.sspndd_flag = 'N' --CFW
9682: OR (pen.sspndd_flag = 'Y' and
9683: pen.enrt_cvg_thru_dt = hr_api.g_eot
9684: )
9685: )
9686: AND pen.prtt_enrt_rslt_stat_cd IS NULL
9687: AND pen.effective_end_date = hr_api.g_eot

Line 9687: AND pen.effective_end_date = hr_api.g_eot

9683: pen.enrt_cvg_thru_dt = hr_api.g_eot
9684: )
9685: )
9686: AND pen.prtt_enrt_rslt_stat_cd IS NULL
9687: AND pen.effective_end_date = hr_api.g_eot
9688: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt
9689: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
9690: AND l_plan_rec.pl_id = pen.pl_id
9691: AND (

Line 9712: pen.enrt_cvg_thru_dt = hr_api.g_eot

9708: AND pen.business_group_id = p_business_group_id
9709: -- AND pen.sspndd_flag = 'N' --CFW
9710: AND (pen.sspndd_flag = 'N' --CFW
9711: OR (pen.sspndd_flag = 'Y' and
9712: pen.enrt_cvg_thru_dt = hr_api.g_eot
9713: )
9714: )
9715: AND pen.prtt_enrt_rslt_stat_cd IS NULL
9716: AND pen.effective_end_date = hr_api.g_eot

Line 9716: AND pen.effective_end_date = hr_api.g_eot

9712: pen.enrt_cvg_thru_dt = hr_api.g_eot
9713: )
9714: )
9715: AND pen.prtt_enrt_rslt_stat_cd IS NULL
9716: AND pen.effective_end_date = hr_api.g_eot
9717: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt
9718: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
9719: AND l_oipl_rec.oipl_id = pen.oipl_id
9720: AND (

Line 9733: AND pdp.effective_end_date = hr_api.g_eot

9729: CURSOR c_plan_cvg_info IS
9730: SELECT 'Y'
9731: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp
9732: WHERE pdp.dpnt_person_id = p_person_id
9733: AND pdp.effective_end_date = hr_api.g_eot
9734: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
9735: AND pdp.business_group_id = p_business_group_id
9736: AND pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
9737: AND pen.business_group_id = p_business_group_id

Line 9740: AND pen.effective_end_date = hr_api.g_eot

9736: AND pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
9737: AND pen.business_group_id = p_business_group_id
9738: AND pen.sspndd_flag = 'N'
9739: AND pen.prtt_enrt_rslt_stat_cd IS NULL
9740: AND pen.effective_end_date = hr_api.g_eot
9741: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt
9742: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
9743: AND l_plan_rec.pl_id = pen.pl_id
9744: AND (

Line 9757: AND pdp.effective_end_date = hr_api.g_eot

9753: CURSOR c_oipl_cvg_info IS
9754: SELECT 'Y'
9755: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp
9756: WHERE pdp.dpnt_person_id = p_person_id
9757: AND pdp.effective_end_date = hr_api.g_eot
9758: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
9759: AND pdp.business_group_id = p_business_group_id
9760: AND pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
9761: AND pen.business_group_id = p_business_group_id

Line 9765: pen.enrt_cvg_thru_dt = hr_api.g_eot

9761: AND pen.business_group_id = p_business_group_id
9762: -- AND pen.sspndd_flag = 'N'
9763: AND (pen.sspndd_flag = 'N' --CFW
9764: OR (pen.sspndd_flag = 'Y' and
9765: pen.enrt_cvg_thru_dt = hr_api.g_eot
9766: )
9767: )
9768: AND pen.prtt_enrt_rslt_stat_cd IS NULL
9769: AND pen.effective_end_date = hr_api.g_eot

Line 9769: AND pen.effective_end_date = hr_api.g_eot

9765: pen.enrt_cvg_thru_dt = hr_api.g_eot
9766: )
9767: )
9768: AND pen.prtt_enrt_rslt_stat_cd IS NULL
9769: AND pen.effective_end_date = hr_api.g_eot
9770: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt
9771: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
9772: AND l_oipl_rec.oipl_id = pen.oipl_id
9773: AND (