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 BEN_PRTT_ENRT_RSLT_F

Line 1473: FROM ben_prtt_enrt_rslt_f pen, ben_pl_f pl, ben_oipl_f oipl

1469: --
1470: -- --
1471: CURSOR c_enrolled_opts_in_pl_typ IS
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

Line 1503: FROM ben_prtt_enrt_rslt_f pen,

1499: --
1500: --
1501: CURSOR c_cvrd_opts_in_pl_typ IS
1502: SELECT pen.enrt_cvg_strt_dt enrt_cvg_strt_dt
1503: FROM ben_prtt_enrt_rslt_f pen,
1504: ben_pl_f pl,
1505: ben_oipl_f oipl,
1506: ben_elig_cvrd_dpnt_f pdp
1507: WHERE pdp.dpnt_person_id = p_person_id

Line 1566: FROM ben_prtt_enrt_rslt_f pen

1562: --
1563: --
1564: CURSOR c_plan_enrolment_info IS
1565: SELECT pen.enrt_cvg_strt_dt enrt_cvg_strt_dt
1566: FROM ben_prtt_enrt_rslt_f pen
1567: WHERE pen.person_id = p_person_id
1568: AND pen.business_group_id = p_business_group_id
1569: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1570: -- AND pen.sspndd_flag = 'N' --CFW

Line 1590: FROM ben_prtt_enrt_rslt_f pen

1586: -- added for level
1587:
1588: CURSOR c_plip_enrolment_info IS
1589: SELECT pen.enrt_cvg_strt_dt enrt_cvg_strt_dt
1590: FROM ben_prtt_enrt_rslt_f pen
1591: WHERE pen.person_id = p_person_id
1592: AND pen.business_group_id = p_business_group_id
1593: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1594: -- AND pen.sspndd_flag = 'N' --CFW

Line 1610: FROM ben_prtt_enrt_rslt_f pen

1606: --
1607:
1608: CURSOR c_ptip_2_enrolment_info IS
1609: SELECT pen.enrt_cvg_strt_dt enrt_cvg_strt_dt
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

Line 1624: FROM ben_prtt_enrt_rslt_f pen

1620: ---
1621:
1622: CURSOR c_pgm_enrolment_info IS
1623: SELECT pen.enrt_cvg_strt_dt enrt_cvg_strt_dt
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

Line 1637: FROM ben_prtt_enrt_rslt_f pen, ben_pl_f pln

1633:
1634: -- Bug#2108168 - Check for current enrollment in a waive plan
1635: CURSOR c_ptip_waive_enrolment_info IS
1636: SELECT pen.enrt_cvg_strt_dt
1637: FROM ben_prtt_enrt_rslt_f pen, ben_pl_f pln
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'

Line 1656: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp

1652: --
1653: --
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

Line 1685: FROM ben_prtt_enrt_rslt_f pen, ben_plip_f plip

1681: CURSOR c_ptip_enrolment_info IS
1682: SELECT pen.pl_id,
1683: pen.oipl_id,
1684: plip.plip_id
1685: FROM ben_prtt_enrt_rslt_f pen, ben_plip_f plip
1686: WHERE pen.person_id = p_person_id
1687: AND pen.business_group_id = p_business_group_id
1688: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1689: --AND pen.sspndd_flag = 'N'

Line 2376: from ben_prtt_enrt_rslt_f rslt,ben_ler_f ler

2372: --however he wanted this to be removed so that self service open enrollment
2373: --will not be impacted and asked find ways to show history on enrollment results later
2374: cursor c_get_latest_enrt_dt is
2375: select max(rslt.effective_start_date)
2376: from ben_prtt_enrt_rslt_f rslt,ben_ler_f ler
2377: where rslt.person_id = p_person_id
2378: and ler.ler_id=rslt.ler_id
2379: -- and rslt.prtt_enrt_rslt_stat_cd NOT IN ('BCKDT', 'VOIDD')
2380: and rslt.prtt_enrt_rslt_stat_cd is null

Line 2714: l_pen_rec ben_prtt_enrt_rslt_f%ROWTYPE;

2710: l_level VARCHAR2(30);
2711: l_plan_rec ben_pl_f%ROWTYPE;
2712: l_pgm_rec ben_pgm_f%ROWTYPE;
2713: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
2714: l_pen_rec ben_prtt_enrt_rslt_f%ROWTYPE;
2715: l_pl_typ_esd DATE;
2716: l_pl_typ_eed DATE;
2717: l_ler_esd DATE;
2718: l_ler_eed DATE;

Line 2877: FROM ben_prtt_enrt_rslt_f pen

2873: pen.enrt_ovrid_thru_dt,
2874: pen.orgnl_enrt_dt,
2875: pen.enrt_cvg_thru_dt,
2876: pen.pl_typ_id
2877: FROM ben_prtt_enrt_rslt_f pen
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

Line 2917: FROM ben_prtt_enrt_rslt_f pen

2913: pen.enrt_ovrid_thru_dt,
2914: pen.enrt_cvg_thru_dt,
2915: pen.sspndd_flag, ---------Bug 8846328
2916: pen.pl_typ_id
2917: FROM ben_prtt_enrt_rslt_f pen
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

Line 2950: FROM ben_prtt_enrt_rslt_f pen

2946: p_enrt_cvg_thru_dt in date,
2947: p_pgm_id in number,
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

Line 2972: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp

2968: --
2969: --
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

Line 2996: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp

2992: --
2993: --
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

Line 3457: FROM ben_prtt_enrt_rslt_f pen, ben_oipl_f enrd_oipl

3453: --
3454: --
3455: CURSOR c_oipl_enrt_in_pl IS
3456: SELECT enrd_oipl.ordr_num
3457: FROM ben_prtt_enrt_rslt_f pen, ben_oipl_f enrd_oipl
3458: WHERE
3459: -- get result for plan if exists
3460: pen.person_id = p_person_id
3461: AND pen.business_group_id = p_business_group_id

Line 3479: FROM ben_prtt_enrt_rslt_f pen,

3475: --
3476: --
3477: CURSOR c_oipl_cvg_in_pl IS
3478: SELECT enrd_oipl.ordr_num
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

Line 3609: from ben_prtt_enrt_rslt_f

3605: --
3606: -- unrestricted process change
3607: cursor c_prtt_enrt_rslt(l_prtt_enrt_rslt_id number) is
3608: select min(effective_start_date)
3609: from ben_prtt_enrt_rslt_f
3610: where prtt_enrt_rslt_id = l_prtt_enrt_rslt_id;
3611: l_effective_start_date date;
3612: --
3613: cursor c_opt_level is

Line 8099: FROM ben_prtt_enrt_rslt_f pen

8095: --
8096: --
8097: CURSOR c_plan_enrolment_info IS
8098: SELECT 'Y'
8099: FROM ben_prtt_enrt_rslt_f pen
8100: WHERE pen.person_id = p_person_id
8101: AND pen.business_group_id = p_business_group_id
8102: AND pen.prtt_enrt_rslt_stat_cd IS NULL
8103: -- AND pen.sspndd_flag = 'N' --CFW

Line 8125: FROM ben_prtt_enrt_rslt_f pen

8121: --
8122: --
8123: CURSOR c_oipl_enrolment_info IS
8124: SELECT 'Y'
8125: FROM ben_prtt_enrt_rslt_f pen
8126: WHERE pen.person_id = p_person_id
8127: AND pen.business_group_id = p_business_group_id
8128: -- AND pen.sspndd_flag = 'N' --CFW
8129: AND (pen.sspndd_flag = 'N' --CFW

Line 8150: FROM ben_prtt_enrt_rslt_f pen

8146: -- Gets the enrolment information for the ptip in which the plan belongs
8147: --
8148: CURSOR c_ptip_enrolment_info IS
8149: SELECT 'Y'
8150: FROM ben_prtt_enrt_rslt_f pen
8151: WHERE pen.person_id = p_person_id
8152: AND pen.business_group_id = p_business_group_id
8153: AND pen.prtt_enrt_rslt_stat_cd IS NULL
8154: -- AND pen.sspndd_flag = 'N'

Line 9529: p_pen_rec OUT NOCOPY ben_prtt_enrt_rslt_f%ROWTYPE) IS

9525: p_effective_date IN DATE,
9526: p_business_group_id IN NUMBER,
9527: p_prtt_enrt_rslt_id IN NUMBER,
9528: p_level IN VARCHAR2,
9529: p_pen_rec OUT NOCOPY ben_prtt_enrt_rslt_f%ROWTYPE) IS
9530: --
9531: l_effective_date_1 DATE := p_effective_date - 1;
9532: --
9533: -- Gets the enrolment information for the ptip

Line 9542: FROM ben_prtt_enrt_rslt_f pen

9538: -- the chek l_effective_date_1 <= pen.enrt_cvg_thru_dt became true
9539: -- so changed to l_effective_date_1 < pen.enrt_cvg_thru_dt
9540: CURSOR c_ptip_enrolment_info IS
9541: SELECT *
9542: FROM ben_prtt_enrt_rslt_f pen
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'

Line 9563: FROM ben_prtt_enrt_rslt_f pen

9559: -- Gets the enrolment information for the oipl
9560: --
9561: CURSOR c_oipl_enrolment_info IS
9562: SELECT *
9563: FROM ben_prtt_enrt_rslt_f pen
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

Line 9584: FROM ben_prtt_enrt_rslt_f pen

9580: -- Gets the enrolment information for the pl
9581: --
9582: CURSOR c_pl_enrolment_info IS
9583: SELECT *
9584: FROM ben_prtt_enrt_rslt_f pen
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'

Line 9608: FROM ben_prtt_enrt_rslt_f pen, ben_pl_f pl, ben_oipl_f oipl

9604: -- Gets the enrolment information for the opt
9605: --
9606: CURSOR c_opt_enrolment_info IS
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

Line 9819: FROM ben_prtt_enrt_rslt_f pen

9815: pen.erlst_deenrt_dt,
9816: pen.prtt_enrt_rslt_id,
9817: pen.enrt_ovridn_flag,
9818: pen.enrt_ovrid_thru_dt
9819: FROM ben_prtt_enrt_rslt_f pen
9820: WHERE pen.person_id = p_person_id
9821: AND pen.business_group_id = p_business_group_id
9822: -- AND pen.sspndd_flag = 'N' --CFW
9823: AND (pen.sspndd_flag = 'N' --CFW

Line 9848: FROM ben_prtt_enrt_rslt_f pen

9844: pen.erlst_deenrt_dt,
9845: pen.prtt_enrt_rslt_id,
9846: pen.enrt_ovridn_flag,
9847: pen.enrt_ovrid_thru_dt
9848: FROM ben_prtt_enrt_rslt_f pen
9849: WHERE pen.person_id = p_person_id
9850: AND pen.business_group_id = p_business_group_id
9851: -- AND pen.sspndd_flag = 'N' --CFW
9852: AND (pen.sspndd_flag = 'N' --CFW

Line 9873: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp

9869: --
9870: --
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

Line 9897: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp

9893: --
9894: --
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