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 1476: AND pen.effective_end_date = hr_api.g_eot

1472: SELECT pen.enrt_cvg_strt_dt enrt_cvg_strt_dt
1473: FROM ben_prtt_enrt_rslt_f pen, ben_pl_f pl, ben_oipl_f oipl
1474: WHERE pen.person_id = p_person_id
1475: AND pen.business_group_id = p_business_group_id
1476: AND pen.effective_end_date = hr_api.g_eot
1477: AND l_lf_evt_ocrd_dt_1 BETWEEN pen.enrt_cvg_strt_dt
1478: AND pen.enrt_cvg_thru_dt
1479: AND pl.pl_id = pen.pl_id
1480: AND pl.business_group_id = p_business_group_id

Line 1509: AND pen.effective_end_date = hr_api.g_eot

1505: ben_oipl_f oipl,
1506: ben_elig_cvrd_dpnt_f pdp
1507: WHERE pdp.dpnt_person_id = p_person_id
1508: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
1509: AND pen.effective_end_date = hr_api.g_eot
1510: AND pdp.effective_end_date = hr_api.g_eot
1511: AND pdp.business_group_id = p_business_group_id
1512: AND pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1513: AND pen.business_group_id = p_business_group_id

Line 1510: AND pdp.effective_end_date = hr_api.g_eot

1506: ben_elig_cvrd_dpnt_f pdp
1507: WHERE pdp.dpnt_person_id = p_person_id
1508: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
1509: AND pen.effective_end_date = hr_api.g_eot
1510: AND pdp.effective_end_date = hr_api.g_eot
1511: AND pdp.business_group_id = p_business_group_id
1512: AND pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1513: AND pen.business_group_id = p_business_group_id
1514: AND l_lf_evt_ocrd_dt_1 BETWEEN pen.enrt_cvg_strt_dt

Line 1573: pen.enrt_cvg_thru_dt = hr_api.g_eot

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

Line 1576: AND pen.effective_end_date = hr_api.g_eot

1572: OR (pen.sspndd_flag = 'Y' and
1573: pen.enrt_cvg_thru_dt = hr_api.g_eot
1574: )
1575: )
1576: AND pen.effective_end_date = hr_api.g_eot
1577: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt
1578: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
1579: AND p_pl_id = pen.pl_id
1580: AND (

Line 1597: pen.enrt_cvg_thru_dt = hr_api.g_eot

1593: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1594: -- AND pen.sspndd_flag = 'N' --CFW
1595: AND (pen.sspndd_flag = 'N' --CFW
1596: OR (pen.sspndd_flag = 'Y' and
1597: pen.enrt_cvg_thru_dt = hr_api.g_eot
1598: )
1599: )
1600: AND pen.effective_end_date = hr_api.g_eot
1601: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt

Line 1600: AND pen.effective_end_date = hr_api.g_eot

1596: OR (pen.sspndd_flag = 'Y' and
1597: pen.enrt_cvg_thru_dt = hr_api.g_eot
1598: )
1599: )
1600: AND pen.effective_end_date = hr_api.g_eot
1601: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt
1602: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
1603: AND p_pl_id = pen.pl_id
1604: AND pen.pgm_id = p_pgm_id ;

Line 1614: AND pen.effective_end_date = hr_api.g_eot

1610: FROM ben_prtt_enrt_rslt_f pen
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.effective_end_date = hr_api.g_eot
1615: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt
1616: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
1617: AND g_ptip_id = pen.ptip_id
1618: AND pen.pgm_id = p_pgm_id ;

Line 1628: AND pen.effective_end_date = hr_api.g_eot

1624: FROM ben_prtt_enrt_rslt_f pen
1625: WHERE pen.person_id = p_person_id
1626: AND pen.business_group_id = p_business_group_id
1627: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1628: AND pen.effective_end_date = hr_api.g_eot
1629: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt
1630: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
1631: AND pen.pgm_id = p_pgm_id ;
1632:

Line 1642: AND pen.effective_end_date = hr_api.g_eot

1638: WHERE pen.person_id = p_person_id
1639: AND pen.business_group_id = p_business_group_id
1640: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1641: AND pen.sspndd_flag = 'N'
1642: AND pen.effective_end_date = hr_api.g_eot
1643: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt
1644: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
1645: AND g_ptip_id = pen.ptip_id
1646: AND pln.pl_id = pen.pl_id

Line 1658: AND pen.effective_end_date = hr_api.g_eot

1654: CURSOR c_plan_cvg_info IS
1655: SELECT pen.enrt_cvg_strt_dt enrt_cvg_strt_dt
1656: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp
1657: WHERE pdp.dpnt_person_id = p_person_id
1658: AND pen.effective_end_date = hr_api.g_eot
1659: AND pdp.effective_end_date = hr_api.g_eot
1660: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
1661: AND pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1662: AND pen.business_group_id = p_business_group_id

Line 1659: AND pdp.effective_end_date = hr_api.g_eot

1655: SELECT pen.enrt_cvg_strt_dt enrt_cvg_strt_dt
1656: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp
1657: WHERE pdp.dpnt_person_id = p_person_id
1658: AND pen.effective_end_date = hr_api.g_eot
1659: AND pdp.effective_end_date = hr_api.g_eot
1660: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
1661: AND pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1662: AND pen.business_group_id = p_business_group_id
1663: AND pen.prtt_enrt_rslt_stat_cd IS NULL

Line 1667: pen.enrt_cvg_thru_dt = hr_api.g_eot

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

Line 1692: pen.enrt_cvg_thru_dt = hr_api.g_eot

1688: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1689: --AND pen.sspndd_flag = 'N'
1690: AND (pen.sspndd_flag = 'N' --CFW
1691: OR (pen.sspndd_flag = 'Y' and
1692: pen.enrt_cvg_thru_dt = hr_api.g_eot
1693: )
1694: )
1695: AND pen.effective_end_date = hr_api.g_eot
1696: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt

Line 1695: AND pen.effective_end_date = hr_api.g_eot

1691: OR (pen.sspndd_flag = 'Y' and
1692: pen.enrt_cvg_thru_dt = hr_api.g_eot
1693: )
1694: )
1695: AND pen.effective_end_date = hr_api.g_eot
1696: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt
1697: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
1698: AND g_ptip_id = pen.ptip_id
1699: AND plip.pgm_id = pen.pgm_id

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

2379: -- and rslt.prtt_enrt_rslt_stat_cd NOT IN ('BCKDT', 'VOIDD')
2380: and rslt.prtt_enrt_rslt_stat_cd is null
2381: and ler.typ_cd not in ('COMP','ABS', 'GSP', 'IREC','SCHEDDU' )
2382: and rslt.business_group_id = p_business_group_id
2383: and rslt.enrt_cvg_thru_dt = hr_api.g_eot; -- Bug 4388226 - End-dated suspended enrl shudn't be picked up.
2384:
2385: --
2386:
2387: begin

Line 2882: pen.enrt_cvg_thru_dt = hr_api.g_eot

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

Line 2887: AND ((pen.effective_end_date = hr_api.g_eot

2883: )
2884: )
2885: AND pen.prtt_enrt_rslt_stat_cd IS NULL
2886: --8399189
2887: AND ((pen.effective_end_date = hr_api.g_eot
2888: and p_run_mode <> 'U')
2889: or ( p_effective_date between pen.effective_start_date and pen.effective_end_date
2890: and p_run_mode = 'U'))
2891: --8399189

Line 2922: pen.enrt_cvg_thru_dt = hr_api.g_eot

2918: WHERE pen.person_id = p_person_id
2919: AND pen.business_group_id = p_business_group_id
2920: AND (pen.sspndd_flag = 'N' --CFW
2921: OR (pen.sspndd_flag = 'Y' and
2922: pen.enrt_cvg_thru_dt = hr_api.g_eot
2923: )
2924: )
2925: AND pen.prtt_enrt_rslt_stat_cd IS NULL
2926: ------Bug 8228639,modified the fix 7507714

Line 2927: AND ((pen.effective_end_date = hr_api.g_eot

2923: )
2924: )
2925: AND pen.prtt_enrt_rslt_stat_cd IS NULL
2926: ------Bug 8228639,modified the fix 7507714
2927: AND ((pen.effective_end_date = hr_api.g_eot
2928: and p_run_mode <> 'U')
2929: or ( p_effective_date between pen.effective_start_date and pen.effective_end_date
2930: and p_run_mode = 'U'))
2931: ------Bug 8228639,modified the fix 7507714

Line 2952: AND pen.effective_end_date = hr_api.g_eot

2948: p_pl_typ_id in number) is
2949: SELECT pen.* ----'Y',Bug 8453712
2950: FROM ben_prtt_enrt_rslt_f pen
2951: WHERE pen.person_id = p_person_id
2952: AND pen.effective_end_date = hr_api.g_eot
2953: AND pen.enrt_cvg_strt_dt > p_enrt_cvg_thru_dt
2954: ANd pen.pl_typ_id = p_pl_typ_id
2955: and nvl(pen.sspndd_flag,'N') = 'N'
2956: AND (

Line 2974: AND pdp.effective_end_date = hr_api.g_eot

2970: CURSOR c_plan_cvg_info IS
2971: SELECT 'Y'
2972: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp
2973: WHERE pdp.dpnt_person_id = p_person_id
2974: AND pdp.effective_end_date = hr_api.g_eot
2975: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
2976: AND pdp.business_group_id = p_business_group_id
2977: AND pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
2978: AND pen.business_group_id = p_business_group_id

Line 2981: AND pen.effective_end_date = hr_api.g_eot

2977: AND pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
2978: AND pen.business_group_id = p_business_group_id
2979: AND pen.sspndd_flag = 'N'
2980: AND pen.prtt_enrt_rslt_stat_cd IS NULL
2981: AND pen.effective_end_date = hr_api.g_eot
2982: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt
2983: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
2984: AND l_pl_id = pen.pl_id
2985: AND (

Line 2998: AND pdp.effective_end_date = hr_api.g_eot

2994: CURSOR c_oipl_cvg_info IS
2995: SELECT 'Y'
2996: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp
2997: WHERE pdp.dpnt_person_id = p_person_id
2998: AND pdp.effective_end_date = hr_api.g_eot
2999: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
3000: AND pdp.business_group_id = p_business_group_id
3001: AND pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
3002: AND pen.business_group_id = p_business_group_id

Line 3005: AND pen.effective_end_date = hr_api.g_eot

3001: AND pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
3002: AND pen.business_group_id = p_business_group_id
3003: AND pen.sspndd_flag = 'N'
3004: AND pen.prtt_enrt_rslt_stat_cd IS NULL
3005: AND pen.effective_end_date = hr_api.g_eot
3006: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt
3007: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
3008: AND p_oipl_id = pen.oipl_id
3009: AND (

Line 3464: AND pen.effective_end_date = hr_api.g_eot

3460: pen.person_id = p_person_id
3461: AND pen.business_group_id = p_business_group_id
3462: AND pen.prtt_enrt_rslt_stat_cd IS NULL
3463: AND pen.sspndd_flag = 'N'
3464: AND pen.effective_end_date = hr_api.g_eot
3465: AND pen.enrt_cvg_thru_dt >= l_lf_evt_ocrd_dt_1
3466: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
3467: AND pen.pl_id = l_pl_id
3468: -- get enrolled oipl

Line 3483: AND pdp.effective_end_date = hr_api.g_eot

3479: FROM ben_prtt_enrt_rslt_f pen,
3480: ben_elig_cvrd_dpnt_f pdp,
3481: ben_oipl_f enrd_oipl
3482: WHERE pdp.dpnt_person_id = p_person_id
3483: AND pdp.effective_end_date = hr_api.g_eot
3484: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
3485: AND pdp.business_group_id = p_business_group_id
3486: AND pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
3487: -- get result for plan if exists

Line 3491: AND pen.effective_end_date = hr_api.g_eot

3487: -- get result for plan if exists
3488: AND pen.business_group_id = p_business_group_id
3489: AND pen.prtt_enrt_rslt_stat_cd IS NULL
3490: AND pen.sspndd_flag = 'N'
3491: AND pen.effective_end_date = hr_api.g_eot
3492: AND pen.enrt_cvg_thru_dt >= l_lf_evt_ocrd_dt_1
3493: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
3494: AND pen.pl_id = l_pl_id
3495: -- get enrolled oipl

Line 3882: IF l_crnt_enrt_cvg_thru_dt <> hr_api.g_eot THEN

3878: END IF;
3879: --
3880: ELSE
3881: --BUG 6519487 fix
3882: IF l_crnt_enrt_cvg_thru_dt <> hr_api.g_eot THEN
3883: OPEN c_future_results (p_person_id ,
3884: l_crnt_enrt_cvg_thru_dt,
3885: p_pgm_id ,
3886: l_current_pl_typ_id) ;

Line 3951: IF l_crnt_enrt_cvg_thru_dt <> hr_api.g_eot THEN

3947: END IF;
3948: --
3949: ELSE
3950: ----BUG 6519487 fix
3951: IF l_crnt_enrt_cvg_thru_dt <> hr_api.g_eot THEN
3952: OPEN c_future_results (p_person_id ,
3953: l_crnt_enrt_cvg_thru_dt,
3954: p_pgm_id ,
3955: l_current_pl_typ_id) ;

Line 5351: l_rec_enrt_perd_end_dt := hr_api.g_eot;

5347: END IF; -- Need to get program level enrolment period info
5348: -- Bug 2200139 Override Enrollments
5349: ELSIF l_unrestricted_enrt_flag = 'Y' OR p_run_mode = 'V' THEN
5350: l_rec_enrt_perd_strt_dt := l_lf_evt_ocrd_dt_fetch;
5351: l_rec_enrt_perd_end_dt := hr_api.g_eot;
5352: l_rec_procg_end_dt := hr_api.g_eot;
5353: l_rec_dflt_asnmt_dt := l_lf_evt_ocrd_dt_fetch;
5354: l_rec_enrt_typ_cycl_cd := 'U';
5355: l_rec_cls_enrt_dt_to_use_cd := 'ELCNSMADE';

Line 5352: l_rec_procg_end_dt := hr_api.g_eot;

5348: -- Bug 2200139 Override Enrollments
5349: ELSIF l_unrestricted_enrt_flag = 'Y' OR p_run_mode = 'V' THEN
5350: l_rec_enrt_perd_strt_dt := l_lf_evt_ocrd_dt_fetch;
5351: l_rec_enrt_perd_end_dt := hr_api.g_eot;
5352: l_rec_procg_end_dt := hr_api.g_eot;
5353: l_rec_dflt_asnmt_dt := l_lf_evt_ocrd_dt_fetch;
5354: l_rec_enrt_typ_cycl_cd := 'U';
5355: l_rec_cls_enrt_dt_to_use_cd := 'ELCNSMADE';
5356: END IF; -- run_mode cases

Line 8106: pen.enrt_cvg_thru_dt = hr_api.g_eot

8102: AND pen.prtt_enrt_rslt_stat_cd IS NULL
8103: -- AND pen.sspndd_flag = 'N' --CFW
8104: AND (pen.sspndd_flag = 'N' --CFW
8105: OR (pen.sspndd_flag = 'Y' and
8106: pen.enrt_cvg_thru_dt = hr_api.g_eot
8107: )
8108: )
8109: AND pen.effective_end_date = hr_api.g_eot
8110: AND l_lf_evt_ocrd_dt <= pen.enrt_cvg_thru_dt

Line 8109: AND pen.effective_end_date = hr_api.g_eot

8105: OR (pen.sspndd_flag = 'Y' and
8106: pen.enrt_cvg_thru_dt = hr_api.g_eot
8107: )
8108: )
8109: AND pen.effective_end_date = hr_api.g_eot
8110: AND l_lf_evt_ocrd_dt <= pen.enrt_cvg_thru_dt
8111: AND l_lf_evt_ocrd_dt >= pen.enrt_cvg_strt_dt
8112: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
8113: AND p_pl_id = pen.pl_id

Line 8131: pen.enrt_cvg_thru_dt = hr_api.g_eot

8127: AND pen.business_group_id = p_business_group_id
8128: -- AND pen.sspndd_flag = 'N' --CFW
8129: AND (pen.sspndd_flag = 'N' --CFW
8130: OR (pen.sspndd_flag = 'Y' and
8131: pen.enrt_cvg_thru_dt = hr_api.g_eot
8132: )
8133: )
8134: AND pen.prtt_enrt_rslt_stat_cd IS NULL
8135: AND pen.effective_end_date = hr_api.g_eot

Line 8135: AND pen.effective_end_date = hr_api.g_eot

8131: pen.enrt_cvg_thru_dt = hr_api.g_eot
8132: )
8133: )
8134: AND pen.prtt_enrt_rslt_stat_cd IS NULL
8135: AND pen.effective_end_date = hr_api.g_eot
8136: AND l_lf_evt_ocrd_dt <= pen.enrt_cvg_thru_dt
8137: AND l_lf_evt_ocrd_dt >= pen.enrt_cvg_strt_dt
8138: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
8139: AND p_oipl_id = pen.oipl_id

Line 8157: pen.enrt_cvg_thru_dt = hr_api.g_eot

8153: AND pen.prtt_enrt_rslt_stat_cd IS NULL
8154: -- AND pen.sspndd_flag = 'N'
8155: AND (pen.sspndd_flag = 'N' --CFW
8156: OR (pen.sspndd_flag = 'Y' and
8157: pen.enrt_cvg_thru_dt = hr_api.g_eot
8158: )
8159: )
8160: AND pen.effective_end_date = hr_api.g_eot
8161: AND

Line 8160: AND pen.effective_end_date = hr_api.g_eot

8156: OR (pen.sspndd_flag = 'Y' and
8157: pen.enrt_cvg_thru_dt = hr_api.g_eot
8158: )
8159: )
8160: AND pen.effective_end_date = hr_api.g_eot
8161: AND
8162: -- nvl(p_lf_evt_ocrd_dt,p_effective_date) between
8163: -- pen.effective_start_date and pen.effective_end_date and
8164: l_lf_evt_ocrd_dt <= pen.enrt_cvg_thru_dt

Line 9547: AND pen.effective_end_date = hr_api.g_eot

9543: WHERE pen.person_id = p_person_id
9544: AND pen.business_group_id = p_business_group_id
9545: AND pen.prtt_enrt_rslt_stat_cd IS NULL
9546: AND pen.sspndd_flag = 'N'
9547: AND pen.effective_end_date = hr_api.g_eot
9548: AND l_effective_date_1 < pen.enrt_cvg_thru_dt
9549: AND pen.prtt_enrt_rslt_id <> p_prtt_enrt_rslt_id
9550: AND (
9551: ( pen.pgm_id = p_pgm_id

Line 9568: AND pen.effective_end_date = hr_api.g_eot

9564: WHERE pen.person_id = p_person_id
9565: AND pen.business_group_id = p_business_group_id
9566: AND pen.prtt_enrt_rslt_stat_cd IS NULL
9567: -- AND pen.sspndd_flag = 'N' --CFW
9568: AND pen.effective_end_date = hr_api.g_eot
9569: AND l_effective_date_1 < pen.enrt_cvg_thru_dt
9570: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
9571: AND pen.prtt_enrt_rslt_id <> p_prtt_enrt_rslt_id
9572: AND (

Line 9589: AND pen.effective_end_date = hr_api.g_eot

9585: WHERE pen.person_id = p_person_id
9586: AND pen.business_group_id = p_business_group_id
9587: AND pen.prtt_enrt_rslt_stat_cd IS NULL
9588: AND pen.sspndd_flag = 'N'
9589: AND pen.effective_end_date = hr_api.g_eot
9590: AND l_effective_date_1 < pen.enrt_cvg_thru_dt
9591: AND (pen.erlst_deenrt_dt IS NULL
9592: OR ( pen.erlst_deenrt_dt IS NOT NULL
9593: AND pen.enrt_cvg_thru_dt > pen.erlst_deenrt_dt))

Line 9611: AND pen.effective_end_date = hr_api.g_eot

9607: SELECT pen.*
9608: FROM ben_prtt_enrt_rslt_f pen, ben_pl_f pl, ben_oipl_f oipl
9609: WHERE pen.person_id = p_person_id
9610: AND pen.business_group_id = p_business_group_id
9611: AND pen.effective_end_date = hr_api.g_eot
9612: AND l_effective_date_1 BETWEEN pen.enrt_cvg_strt_dt
9613: AND pen.enrt_cvg_thru_dt
9614: AND pl.pl_id = pen.pl_id
9615: and pen.oipl_id = p_oipl_id /* bug 1527086 */

Line 9825: pen.enrt_cvg_thru_dt = hr_api.g_eot

9821: AND pen.business_group_id = p_business_group_id
9822: -- AND pen.sspndd_flag = 'N' --CFW
9823: AND (pen.sspndd_flag = 'N' --CFW
9824: OR (pen.sspndd_flag = 'Y' and
9825: pen.enrt_cvg_thru_dt = hr_api.g_eot
9826: )
9827: )
9828: AND pen.prtt_enrt_rslt_stat_cd IS NULL
9829: AND pen.effective_end_date = hr_api.g_eot

Line 9829: AND pen.effective_end_date = hr_api.g_eot

9825: pen.enrt_cvg_thru_dt = hr_api.g_eot
9826: )
9827: )
9828: AND pen.prtt_enrt_rslt_stat_cd IS NULL
9829: AND pen.effective_end_date = hr_api.g_eot
9830: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt
9831: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
9832: AND l_plan_rec.pl_id = pen.pl_id
9833: AND (

Line 9854: pen.enrt_cvg_thru_dt = hr_api.g_eot

9850: AND pen.business_group_id = p_business_group_id
9851: -- AND pen.sspndd_flag = 'N' --CFW
9852: AND (pen.sspndd_flag = 'N' --CFW
9853: OR (pen.sspndd_flag = 'Y' and
9854: pen.enrt_cvg_thru_dt = hr_api.g_eot
9855: )
9856: )
9857: AND pen.prtt_enrt_rslt_stat_cd IS NULL
9858: AND pen.effective_end_date = hr_api.g_eot

Line 9858: AND pen.effective_end_date = hr_api.g_eot

9854: pen.enrt_cvg_thru_dt = hr_api.g_eot
9855: )
9856: )
9857: AND pen.prtt_enrt_rslt_stat_cd IS NULL
9858: AND pen.effective_end_date = hr_api.g_eot
9859: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt
9860: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
9861: AND l_oipl_rec.oipl_id = pen.oipl_id
9862: AND (

Line 9875: AND pdp.effective_end_date = hr_api.g_eot

9871: CURSOR c_plan_cvg_info IS
9872: SELECT 'Y'
9873: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp
9874: WHERE pdp.dpnt_person_id = p_person_id
9875: AND pdp.effective_end_date = hr_api.g_eot
9876: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
9877: AND pdp.business_group_id = p_business_group_id
9878: AND pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
9879: AND pen.business_group_id = p_business_group_id

Line 9882: AND pen.effective_end_date = hr_api.g_eot

9878: AND pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
9879: AND pen.business_group_id = p_business_group_id
9880: AND pen.sspndd_flag = 'N'
9881: AND pen.prtt_enrt_rslt_stat_cd IS NULL
9882: AND pen.effective_end_date = hr_api.g_eot
9883: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt
9884: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
9885: AND l_plan_rec.pl_id = pen.pl_id
9886: AND (

Line 9899: AND pdp.effective_end_date = hr_api.g_eot

9895: CURSOR c_oipl_cvg_info IS
9896: SELECT 'Y'
9897: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp
9898: WHERE pdp.dpnt_person_id = p_person_id
9899: AND pdp.effective_end_date = hr_api.g_eot
9900: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
9901: AND pdp.business_group_id = p_business_group_id
9902: AND pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
9903: AND pen.business_group_id = p_business_group_id

Line 9907: pen.enrt_cvg_thru_dt = hr_api.g_eot

9903: AND pen.business_group_id = p_business_group_id
9904: -- AND pen.sspndd_flag = 'N'
9905: AND (pen.sspndd_flag = 'N' --CFW
9906: OR (pen.sspndd_flag = 'Y' and
9907: pen.enrt_cvg_thru_dt = hr_api.g_eot
9908: )
9909: )
9910: AND pen.prtt_enrt_rslt_stat_cd IS NULL
9911: AND pen.effective_end_date = hr_api.g_eot

Line 9911: AND pen.effective_end_date = hr_api.g_eot

9907: pen.enrt_cvg_thru_dt = hr_api.g_eot
9908: )
9909: )
9910: AND pen.prtt_enrt_rslt_stat_cd IS NULL
9911: AND pen.effective_end_date = hr_api.g_eot
9912: AND l_lf_evt_ocrd_dt_1 <= pen.enrt_cvg_thru_dt
9913: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
9914: AND l_oipl_rec.oipl_id = pen.oipl_id
9915: AND (