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 1446: FROM ben_prtt_enrt_rslt_f pen, ben_pl_f pl, ben_oipl_f oipl

1442: --
1443: -- --
1444: CURSOR c_enrolled_opts_in_pl_typ IS
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

Line 1476: FROM ben_prtt_enrt_rslt_f pen,

1472: --
1473: --
1474: CURSOR c_cvrd_opts_in_pl_typ IS
1475: SELECT pen.enrt_cvg_strt_dt enrt_cvg_strt_dt
1476: FROM ben_prtt_enrt_rslt_f pen,
1477: ben_pl_f pl,
1478: ben_oipl_f oipl,
1479: ben_elig_cvrd_dpnt_f pdp
1480: WHERE pdp.dpnt_person_id = p_person_id

Line 1539: FROM ben_prtt_enrt_rslt_f pen

1535: --
1536: --
1537: CURSOR c_plan_enrolment_info IS
1538: SELECT pen.enrt_cvg_strt_dt enrt_cvg_strt_dt
1539: FROM ben_prtt_enrt_rslt_f pen
1540: WHERE pen.person_id = p_person_id
1541: AND pen.business_group_id = p_business_group_id
1542: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1543: -- AND pen.sspndd_flag = 'N' --CFW

Line 1563: FROM ben_prtt_enrt_rslt_f pen

1559: -- added for level
1560:
1561: CURSOR c_plip_enrolment_info IS
1562: SELECT pen.enrt_cvg_strt_dt enrt_cvg_strt_dt
1563: FROM ben_prtt_enrt_rslt_f pen
1564: WHERE pen.person_id = p_person_id
1565: AND pen.business_group_id = p_business_group_id
1566: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1567: -- AND pen.sspndd_flag = 'N' --CFW

Line 1583: FROM ben_prtt_enrt_rslt_f pen

1579: --
1580:
1581: CURSOR c_ptip_2_enrolment_info IS
1582: SELECT pen.enrt_cvg_strt_dt enrt_cvg_strt_dt
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

Line 1597: FROM ben_prtt_enrt_rslt_f pen

1593: ---
1594:
1595: CURSOR c_pgm_enrolment_info IS
1596: SELECT pen.enrt_cvg_strt_dt enrt_cvg_strt_dt
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

Line 1610: FROM ben_prtt_enrt_rslt_f pen, ben_pl_f pln

1606:
1607: -- Bug#2108168 - Check for current enrollment in a waive plan
1608: CURSOR c_ptip_waive_enrolment_info IS
1609: SELECT pen.enrt_cvg_strt_dt
1610: FROM ben_prtt_enrt_rslt_f pen, ben_pl_f pln
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'

Line 1629: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp

1625: --
1626: --
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

Line 1658: FROM ben_prtt_enrt_rslt_f pen, ben_plip_f plip

1654: CURSOR c_ptip_enrolment_info IS
1655: SELECT pen.pl_id,
1656: pen.oipl_id,
1657: plip.plip_id
1658: FROM ben_prtt_enrt_rslt_f pen, ben_plip_f plip
1659: WHERE pen.person_id = p_person_id
1660: AND pen.business_group_id = p_business_group_id
1661: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1662: --AND pen.sspndd_flag = 'N'

Line 2349: from ben_prtt_enrt_rslt_f rslt,ben_ler_f ler

2345: --however he wanted this to be removed so that self service open enrollment
2346: --will not be impacted and asked find ways to show history on enrollment results later
2347: cursor c_get_latest_enrt_dt is
2348: select max(rslt.effective_start_date)
2349: from ben_prtt_enrt_rslt_f rslt,ben_ler_f ler
2350: where rslt.person_id = p_person_id
2351: and ler.ler_id=rslt.ler_id
2352: -- and rslt.prtt_enrt_rslt_stat_cd NOT IN ('BCKDT', 'VOIDD')
2353: and rslt.prtt_enrt_rslt_stat_cd is null

Line 2687: l_pen_rec ben_prtt_enrt_rslt_f%ROWTYPE;

2683: l_level VARCHAR2(30);
2684: l_plan_rec ben_pl_f%ROWTYPE;
2685: l_pgm_rec ben_pgm_f%ROWTYPE;
2686: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
2687: l_pen_rec ben_prtt_enrt_rslt_f%ROWTYPE;
2688: l_pl_typ_esd DATE;
2689: l_pl_typ_eed DATE;
2690: l_ler_esd DATE;
2691: l_ler_eed DATE;

Line 2845: FROM ben_prtt_enrt_rslt_f pen

2841: pen.enrt_ovrid_thru_dt,
2842: pen.orgnl_enrt_dt,
2843: pen.enrt_cvg_thru_dt,
2844: pen.pl_typ_id
2845: FROM ben_prtt_enrt_rslt_f pen
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

Line 2879: FROM ben_prtt_enrt_rslt_f pen

2875: pen.enrt_ovridn_flag,
2876: pen.enrt_ovrid_thru_dt,
2877: pen.enrt_cvg_thru_dt,
2878: pen.pl_typ_id
2879: FROM ben_prtt_enrt_rslt_f pen
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

Line 2907: FROM ben_prtt_enrt_rslt_f pen

2903: p_enrt_cvg_thru_dt in date,
2904: p_pgm_id in number,
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

Line 2926: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp

2922: --
2923: --
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

Line 2950: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp

2946: --
2947: --
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

Line 3411: FROM ben_prtt_enrt_rslt_f pen, ben_oipl_f enrd_oipl

3407: --
3408: --
3409: CURSOR c_oipl_enrt_in_pl IS
3410: SELECT enrd_oipl.ordr_num
3411: FROM ben_prtt_enrt_rslt_f pen, ben_oipl_f enrd_oipl
3412: WHERE
3413: -- get result for plan if exists
3414: pen.person_id = p_person_id
3415: AND pen.business_group_id = p_business_group_id

Line 3433: FROM ben_prtt_enrt_rslt_f pen,

3429: --
3430: --
3431: CURSOR c_oipl_cvg_in_pl IS
3432: SELECT enrd_oipl.ordr_num
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

Line 3563: from ben_prtt_enrt_rslt_f

3559: --
3560: -- unrestricted process change
3561: cursor c_prtt_enrt_rslt(l_prtt_enrt_rslt_id number) is
3562: select min(effective_start_date)
3563: from ben_prtt_enrt_rslt_f
3564: where prtt_enrt_rslt_id = l_prtt_enrt_rslt_id;
3565: l_effective_start_date date;
3566: --
3567: cursor c_opt_level is

Line 7962: FROM ben_prtt_enrt_rslt_f pen

7958: --
7959: --
7960: CURSOR c_plan_enrolment_info IS
7961: SELECT 'Y'
7962: FROM ben_prtt_enrt_rslt_f pen
7963: WHERE pen.person_id = p_person_id
7964: AND pen.business_group_id = p_business_group_id
7965: AND pen.prtt_enrt_rslt_stat_cd IS NULL
7966: -- AND pen.sspndd_flag = 'N' --CFW

Line 7988: FROM ben_prtt_enrt_rslt_f pen

7984: --
7985: --
7986: CURSOR c_oipl_enrolment_info IS
7987: SELECT 'Y'
7988: FROM ben_prtt_enrt_rslt_f pen
7989: WHERE pen.person_id = p_person_id
7990: AND pen.business_group_id = p_business_group_id
7991: -- AND pen.sspndd_flag = 'N' --CFW
7992: AND (pen.sspndd_flag = 'N' --CFW

Line 8013: FROM ben_prtt_enrt_rslt_f pen

8009: -- Gets the enrolment information for the ptip in which the plan belongs
8010: --
8011: CURSOR c_ptip_enrolment_info IS
8012: SELECT 'Y'
8013: FROM ben_prtt_enrt_rslt_f pen
8014: WHERE pen.person_id = p_person_id
8015: AND pen.business_group_id = p_business_group_id
8016: AND pen.prtt_enrt_rslt_stat_cd IS NULL
8017: -- AND pen.sspndd_flag = 'N'

Line 9390: p_pen_rec OUT NOCOPY ben_prtt_enrt_rslt_f%ROWTYPE) IS

9386: p_effective_date IN DATE,
9387: p_business_group_id IN NUMBER,
9388: p_prtt_enrt_rslt_id IN NUMBER,
9389: p_level IN VARCHAR2,
9390: p_pen_rec OUT NOCOPY ben_prtt_enrt_rslt_f%ROWTYPE) IS
9391: --
9392: l_effective_date_1 DATE := p_effective_date - 1;
9393: --
9394: -- Gets the enrolment information for the ptip

Line 9403: FROM ben_prtt_enrt_rslt_f pen

9399: -- the chek l_effective_date_1 <= pen.enrt_cvg_thru_dt became true
9400: -- so changed to l_effective_date_1 < pen.enrt_cvg_thru_dt
9401: CURSOR c_ptip_enrolment_info IS
9402: SELECT *
9403: FROM ben_prtt_enrt_rslt_f pen
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'

Line 9424: FROM ben_prtt_enrt_rslt_f pen

9420: -- Gets the enrolment information for the oipl
9421: --
9422: CURSOR c_oipl_enrolment_info IS
9423: SELECT *
9424: FROM ben_prtt_enrt_rslt_f pen
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

Line 9445: FROM ben_prtt_enrt_rslt_f pen

9441: -- Gets the enrolment information for the pl
9442: --
9443: CURSOR c_pl_enrolment_info IS
9444: SELECT *
9445: FROM ben_prtt_enrt_rslt_f pen
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'

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

9462: -- Gets the enrolment information for the opt
9463: --
9464: CURSOR c_opt_enrolment_info IS
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

Line 9677: FROM ben_prtt_enrt_rslt_f pen

9673: pen.erlst_deenrt_dt,
9674: pen.prtt_enrt_rslt_id,
9675: pen.enrt_ovridn_flag,
9676: pen.enrt_ovrid_thru_dt
9677: FROM ben_prtt_enrt_rslt_f pen
9678: WHERE pen.person_id = p_person_id
9679: AND pen.business_group_id = p_business_group_id
9680: -- AND pen.sspndd_flag = 'N' --CFW
9681: AND (pen.sspndd_flag = 'N' --CFW

Line 9706: FROM ben_prtt_enrt_rslt_f pen

9702: pen.erlst_deenrt_dt,
9703: pen.prtt_enrt_rslt_id,
9704: pen.enrt_ovridn_flag,
9705: pen.enrt_ovrid_thru_dt
9706: FROM ben_prtt_enrt_rslt_f pen
9707: WHERE pen.person_id = p_person_id
9708: AND pen.business_group_id = p_business_group_id
9709: -- AND pen.sspndd_flag = 'N' --CFW
9710: AND (pen.sspndd_flag = 'N' --CFW

Line 9731: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp

9727: --
9728: --
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

Line 9755: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp

9751: --
9752: --
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