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_EVALUATE_ELIG_PROFILES dependencies on BEN_ELP_CACHE

Line 389: l_inst_dets ben_elp_cache.g_cache_elpels_instor;

385: p_plip_id in number default null,
386: p_opt_id in number default null) is
387: --
388: l_proc varchar2(100):= g_package||'check_los_elig';
389: l_inst_dets ben_elp_cache.g_cache_elpels_instor;
390: l_inst_count number;
391: l_insttorrw_num binary_integer;
392: l_ok boolean := false;
393: l_rows_found boolean := false;

Line 412: ben_elp_cache.elpels_getcacdets

408: hr_utility.set_location('Entering: '||l_proc,10);
409: --
410: -- Getting eligibility profile length of service by eligibility profile
411: --
412: ben_elp_cache.elpels_getcacdets
413: (p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date)
414: ,p_business_group_id => p_business_group_id
415: ,p_eligy_prfl_id => p_eligy_prfl_id
416: ,p_inst_set => l_inst_dets

Line 607: l_inst_dets ben_elp_cache.g_cache_elpeap_instor;

603: l_dummy_date date;
604: l_prtn_ovridn_flag varchar2(30);
605: l_prtn_ovridn_thru_dt date;
606: l_epo_row ben_derive_part_and_rate_facts.g_cache_structure;
607: l_inst_dets ben_elp_cache.g_cache_elpeap_instor;
608: l_inst_count number;
609: l_insttorrw_num binary_integer;
610: l_crit_passed boolean;
611: l_score_tab scoreTab;

Line 619: ben_elp_cache.elpeap_getcacdets

615: hr_utility.set_location('Entering :'||l_proc, 10);
616: --
617: -- Getting eligibility profile age details by eligibility profile
618: --
619: ben_elp_cache.elpeap_getcacdets
620: (p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date)
621: ,p_business_group_id => p_business_group_id
622: ,p_eligy_prfl_id => p_eligy_prfl_id
623: ,p_inst_set => l_inst_dets

Line 801: l_inst_dets ben_elp_cache.g_cache_elpecp_instor;

797: p_plip_id in number default null,
798: p_opt_id in number default null) is
799: --
800: l_proc varchar2(100):= g_package||'check_age_los_elig';
801: l_inst_dets ben_elp_cache.g_cache_elpecp_instor;
802: l_inst_count number;
803: l_insttorrw_num binary_integer;
804: l_ok boolean := false;
805: l_rows_found boolean := false;

Line 831: ben_elp_cache.elpecp_getcacdets

827: hr_utility.set_location('Entering :'||l_proc,10);
828: --
829: -- Getting eligibility profile age/los combination by eligibility profile
830: --
831: ben_elp_cache.elpecp_getcacdets
832: (p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date)
833: ,p_business_group_id => p_business_group_id
834: ,p_eligy_prfl_id => p_eligy_prfl_id
835: ,p_inst_set => l_inst_dets

Line 1094: l_inst_dets ben_elp_cache.g_cache_elpecl_instor;

1090: p_plip_id in number default null,
1091: p_opt_id in number default null) is
1092: --
1093: l_proc varchar2(100):=g_package||'check_comp_level_rl_elig';
1094: l_inst_dets ben_elp_cache.g_cache_elpecl_instor;
1095: l_inst_count number;
1096: l_insttorrw_num binary_integer;
1097: l_ok boolean := false;
1098: l_rows_found boolean := false;

Line 1113: ben_elp_cache.elpecl_getcacdets

1109: hr_utility.set_location('Entering: '||l_proc, 10);
1110: --
1111: -- Getting eligibility profile compensation level by eligibility profile
1112: --
1113: ben_elp_cache.elpecl_getcacdets
1114: (p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date)
1115: ,p_business_group_id => p_business_group_id
1116: ,p_comp_src_cd => 'RL'
1117: ,p_eligy_prfl_id => p_eligy_prfl_id

Line 1246: l_inst_dets ben_elp_cache.g_cache_elpecl_instor;

1242: p_person_id in number,
1243: p_per_comp_val in number) is
1244: --
1245: l_proc varchar2(100):=g_package||'check_comp_level_elig';
1246: l_inst_dets ben_elp_cache.g_cache_elpecl_instor;
1247: l_inst_count number;
1248: l_insttorrw_num binary_integer;
1249: l_ok boolean := false;
1250: l_rows_found boolean := false;

Line 1261: ben_elp_cache.elpecl_getcacdets

1257: hr_utility.set_location('Entering: '||l_proc, 10);
1258: --
1259: -- Getting eligibility profile compensation level by eligibility profile
1260: --
1261: ben_elp_cache.elpecl_getcacdets
1262: (p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date)
1263: ,p_business_group_id => p_business_group_id
1264: ,p_comp_src_cd => 'STTDCOMP'
1265: ,p_eligy_prfl_id => p_eligy_prfl_id

Line 1397: l_inst_dets ben_elp_cache.g_cache_elpehw_instor;

1393: p_effective_date in date,
1394: p_per_hrs_wkd in number) is
1395: --
1396: l_proc varchar2(100):= g_package||'check_hrs_wkd_ben_bal';
1397: l_inst_dets ben_elp_cache.g_cache_elpehw_instor;
1398: l_inst_count number;
1399: l_insttorrw_num binary_integer;
1400: l_ok boolean := false;
1401: l_rows_found boolean := false;

Line 1424: ben_elp_cache.elpehw_getcacdets

1420: end if;
1421: --
1422: -- Getting hours worked profile information
1423: --
1424: ben_elp_cache.elpehw_getcacdets
1425: (p_effective_date => p_effective_date
1426: ,p_business_group_id => p_business_group_id
1427: ,p_hrs_src_cd => 'BNFTBALTYP'
1428: ,p_eligy_prfl_id => p_eligy_prfl_id

Line 1561: l_inst_dets ben_elp_cache.g_cache_elpehw_instor;

1557: p_effective_date in date,
1558: p_per_hrs_wkd in number) is
1559: --
1560: l_proc varchar2(100):= g_package||'check_hrs_wkd_balance';
1561: l_inst_dets ben_elp_cache.g_cache_elpehw_instor;
1562: l_inst_count number;
1563: l_insttorrw_num binary_integer;
1564: l_ok boolean := false;
1565: l_rows_found boolean := false;

Line 1583: ben_elp_cache.elpehw_getcacdets

1579: end if;
1580: --
1581: -- Getting hours worked profile information
1582: --
1583: ben_elp_cache.elpehw_getcacdets
1584: (p_effective_date => p_effective_date
1585: ,p_business_group_id => p_business_group_id
1586: ,p_hrs_src_cd => 'RL'
1587: ,p_eligy_prfl_id => p_eligy_prfl_id

Line 1716: l_inst_dets ben_elp_cache.g_cache_elpehw_instor;

1712: p_effective_date in date,
1713: p_per_hrs_wkd in number) is
1714: --
1715: l_proc varchar2(100):= g_package||'check_hrs_wkd_balance';
1716: l_inst_dets ben_elp_cache.g_cache_elpehw_instor;
1717: l_inst_count number;
1718: l_insttorrw_num binary_integer;
1719: l_ok boolean := false;
1720: l_rows_found boolean := false;

Line 1738: ben_elp_cache.elpehw_getcacdets

1734: end if;
1735: --
1736: -- Getting hours worked profile information
1737: --
1738: ben_elp_cache.elpehw_getcacdets
1739: (p_effective_date => p_effective_date
1740: ,p_business_group_id => p_business_group_id
1741: ,p_hrs_src_cd => 'BALTYP'
1742: ,p_eligy_prfl_id => p_eligy_prfl_id

Line 1869: l_inst_dets ben_elp_cache.g_cache_elpepf_instor;

1865: p_effective_date in date,
1866: p_per_pct_ft_val in number) is
1867: --
1868: l_proc varchar2(100):=g_package||'check_pct_fltm_elig';
1869: l_inst_dets ben_elp_cache.g_cache_elpepf_instor;
1870: l_inst_count number;
1871: l_insttorrw_num binary_integer;
1872: l_ok boolean := false;
1873: l_rows_found boolean := false;

Line 1884: ben_elp_cache.elpepf_getcacdets

1880: hr_utility.set_location('Entering :'||l_proc,10);
1881: --
1882: -- Getting eligibility profile full time by eligibility profile
1883: --
1884: ben_elp_cache.elpepf_getcacdets
1885: (p_effective_date => p_effective_date
1886: ,p_business_group_id => p_business_group_id
1887: ,p_eligy_prfl_id => p_eligy_prfl_id
1888: ,p_inst_set => l_inst_dets

Line 2005: l_inst_dets ben_elp_cache.g_cache_elpegr_instor;

2001: p_effective_date in date,
2002: p_grade_id in number) is
2003: --
2004: l_proc varchar2(100) := g_package||'check_grade_elig';
2005: l_inst_dets ben_elp_cache.g_cache_elpegr_instor;
2006: l_inst_count number;
2007: l_insttorrw_num binary_integer;
2008: l_ok boolean := false;
2009: l_rows_found boolean := false;

Line 2019: ben_elp_cache.elpegr_getcacdets

2015: hr_utility.set_location('Entering : '||l_proc,10);
2016: --
2017: -- Getting eligibility profile grade by eligibility profile
2018: --
2019: ben_elp_cache.elpegr_getcacdets
2020: (p_effective_date => p_effective_date
2021: ,p_business_group_id => p_business_group_id
2022: ,p_eligy_prfl_id => p_eligy_prfl_id
2023: ,p_inst_set => l_inst_dets

Line 2118: l_inst_dets ben_elp_cache.g_cache_elpegn_instor;

2114: p_effective_date in date,
2115: p_sex in varchar2) is
2116: --
2117: l_proc varchar2(100) := g_package||'check_gender_elig';
2118: l_inst_dets ben_elp_cache.g_cache_elpegn_instor;
2119: l_inst_count number;
2120: l_insttorrw_num binary_integer;
2121: l_ok boolean := false;
2122: l_rows_found boolean := false;

Line 2132: ben_elp_cache.elpegn_getcacdets

2128: hr_utility.set_location('Entering : '||l_proc,10);
2129: --
2130: -- Getting eligibility profile sex by eligibility profile
2131: --
2132: ben_elp_cache.elpegn_getcacdets
2133: (p_effective_date => p_effective_date
2134: ,p_business_group_id => p_business_group_id
2135: ,p_eligy_prfl_id => p_eligy_prfl_id
2136: ,p_inst_set => l_inst_dets

Line 2245: l_inst_dets ben_elp_cache.g_cache_elperl_instor;

2241: and ITEM_NAME = 'ASSIGNMENT_ID'
2242: and usage = 'U';
2243: --
2244: l_proc varchar2(100) := g_package||'check_rule_elig';
2245: l_inst_dets ben_elp_cache.g_cache_elperl_instor;
2246: l_inst_count number;
2247: l_insttorrw_num binary_integer;
2248: l_ok boolean := false;
2249: l_rows_found boolean := false;

Line 2265: ben_elp_cache.elperl_getcacdets

2261: --
2262: -- Getting eligibility profile rule by eligibility profile
2263: --
2264:
2265: ben_elp_cache.elperl_getcacdets
2266: (p_effective_date => p_effective_date
2267: ,p_business_group_id => p_business_group_id
2268: ,p_eligy_prfl_id => p_eligy_prfl_id
2269: ,p_inst_set => l_inst_dets

Line 2439: l_inst_dets ben_elp_cache.g_cache_elpejp_instor;

2435: p_effective_date in date,
2436: p_job_id in number) is
2437: --
2438: l_proc varchar2(100) := g_package||'check_job_elig';
2439: l_inst_dets ben_elp_cache.g_cache_elpejp_instor;
2440: l_inst_count number;
2441: l_insttorrw_num binary_integer;
2442: l_ok boolean := false;
2443: l_rows_found boolean := false;

Line 2453: ben_elp_cache.elpejp_getcacdets

2449: hr_utility.set_location('Entering : '||l_proc,10);
2450: --
2451: -- Getting eligibility profile job by eligibility profile
2452: --
2453: ben_elp_cache.elpejp_getcacdets
2454: (p_effective_date => p_effective_date
2455: ,p_business_group_id => p_business_group_id
2456: ,p_eligy_prfl_id => p_eligy_prfl_id
2457: ,p_inst_set => l_inst_dets

Line 2551: l_inst_dets ben_elp_cache.g_cache_elpept_instor;

2547: g_cache_typ_table) is
2548: --
2549: l_proc varchar2(100) := g_package||'check_per_typ_elig';
2550: --
2551: l_inst_dets ben_elp_cache.g_cache_elpept_instor;
2552: l_inst_count number;
2553: l_insttorrw_num binary_integer;
2554: --
2555: l_rows_found boolean := false;

Line 2564: ben_elp_cache.elpept_getcacdets

2560: begin
2561: --
2562: hr_utility.set_location('Entering :'||l_proc,10);
2563: --
2564: ben_elp_cache.elpept_getcacdets
2565: (p_effective_date => p_effective_date
2566: ,p_business_group_id => p_business_group_id
2567: ,p_eligy_prfl_id => p_eligy_prfl_id
2568: ,p_inst_set => l_inst_dets

Line 2677: l_inst_dets ben_elp_cache.g_cache_elpepb_instor;

2673: p_effective_date in date,
2674: p_pay_basis_id in number) is
2675: --
2676: l_proc varchar2(100) := g_package||'check_py_bss_elig';
2677: l_inst_dets ben_elp_cache.g_cache_elpepb_instor;
2678: l_inst_count number;
2679: l_insttorrw_num binary_integer;
2680: l_ok boolean := false;
2681: l_rows_found boolean := false;

Line 2691: ben_elp_cache.elpepb_getcacdets

2687: hr_utility.set_location('Entering : '||l_proc,10);
2688: --
2689: -- Getting eligibility profile pay basis by eligibility profile
2690: --
2691: ben_elp_cache.elpepb_getcacdets
2692: (p_effective_date => p_effective_date
2693: ,p_business_group_id => p_business_group_id
2694: ,p_eligy_prfl_id => p_eligy_prfl_id
2695: ,p_inst_set => l_inst_dets

Line 2817: l_inst_dets ben_elp_cache.g_cache_elpepy_instor;

2813: p_effective_date in date,
2814: p_payroll_id in number) is
2815: --
2816: l_proc varchar2(100) := g_package||'check_pyrl_elig';
2817: l_inst_dets ben_elp_cache.g_cache_elpepy_instor;
2818: l_inst_count number;
2819: l_insttorrw_num binary_integer;
2820: l_ok boolean := false;
2821: l_rows_found boolean := false;

Line 2832: ben_elp_cache.elpepy_getcacdets

2828: hr_utility.set_location('payroll id : '||p_payroll_id,10);
2829: --
2830: -- Getting eligibility profile payroll by eligibility profile
2831: --
2832: ben_elp_cache.elpepy_getcacdets
2833: (p_effective_date => p_effective_date
2834: ,p_business_group_id => p_business_group_id
2835: ,p_eligy_prfl_id => p_eligy_prfl_id
2836: ,p_inst_set => l_inst_dets

Line 2928: l_inst_dets ben_elp_cache.g_cache_elpebn_instor;

2924: p_effective_date in date,
2925: p_benefit_group_id in number) is
2926: --
2927: l_proc varchar2(100) := g_package||'check_benefits_grp_elig';
2928: l_inst_dets ben_elp_cache.g_cache_elpebn_instor;
2929: l_inst_count number;
2930: l_insttorrw_num binary_integer;
2931: l_ok boolean := false;
2932: l_rows_found boolean := false;

Line 2942: ben_elp_cache.elpebn_getcacdets

2938: hr_utility.set_location('Entering : '||l_proc,10);
2939: --
2940: -- Getting eligibility profile benefits group by eligibility profile
2941: --
2942: ben_elp_cache.elpebn_getcacdets
2943: (p_effective_date => p_effective_date
2944: ,p_business_group_id => p_business_group_id
2945: ,p_eligy_prfl_id => p_eligy_prfl_id
2946: ,p_inst_set => l_inst_dets

Line 3038: l_inst_dets ben_elp_cache.g_cache_elpewl_instor;

3034: p_effective_date in date,
3035: p_location_id in number) is
3036: --
3037: l_proc varchar2(100) := g_package||'check_wk_location_elig';
3038: l_inst_dets ben_elp_cache.g_cache_elpewl_instor;
3039: l_inst_count number;
3040: l_insttorrw_num binary_integer;
3041: l_ok boolean := false;
3042: l_rows_found boolean := false;

Line 3052: ben_elp_cache.elpewl_getcacdets

3048: hr_utility.set_location('Entering : '||l_proc,10);
3049: --
3050: -- Getting eligibility profile location by eligibility profile
3051: --
3052: ben_elp_cache.elpewl_getcacdets
3053: (p_effective_date => p_effective_date
3054: ,p_business_group_id => p_business_group_id
3055: ,p_eligy_prfl_id => p_eligy_prfl_id
3056: ,p_inst_set => l_inst_dets

Line 3146: l_inst_dets ben_elp_cache.g_cache_elpepg_instor;

3142: p_effective_date in date,
3143: p_people_group_id in number) is
3144: --
3145: l_proc varchar2(100) := g_package||'check_people_group_elig';
3146: l_inst_dets ben_elp_cache.g_cache_elpepg_instor;
3147: l_inst_count number;
3148: l_insttorrw_num binary_integer;
3149: l_ok boolean := false;
3150: l_rows_found boolean := false;

Line 3201: ben_elp_cache.elpepg_getcacdets

3197: hr_utility.set_location('Entering : '||l_proc,10);
3198: --
3199: -- Getting eligibility profile organization by eligibility profile
3200: --
3201: ben_elp_cache.elpepg_getcacdets
3202: (p_effective_date => p_effective_date
3203: ,p_business_group_id => p_business_group_id
3204: ,p_eligy_prfl_id => p_eligy_prfl_id
3205: ,p_inst_set => l_inst_dets

Line 3578: l_inst_dets ben_elp_cache.g_cache_elpeou_instor;

3574: p_effective_date in date,
3575: p_organization_id in number) is
3576: --
3577: l_proc varchar2(100) := g_package||'check_org_unit_elig';
3578: l_inst_dets ben_elp_cache.g_cache_elpeou_instor;
3579: l_inst_count number;
3580: l_insttorrw_num binary_integer;
3581: l_ok boolean := false;
3582: l_rows_found boolean := false;

Line 3592: ben_elp_cache.elpeou_getcacdets

3588: hr_utility.set_location('Entering : '||l_proc,10);
3589: --
3590: -- Getting eligibility profile organization by eligibility profile
3591: --
3592: ben_elp_cache.elpeou_getcacdets
3593: (p_effective_date => p_effective_date
3594: ,p_business_group_id => p_business_group_id
3595: ,p_eligy_prfl_id => p_eligy_prfl_id
3596: ,p_inst_set => l_inst_dets

Line 3686: l_inst_dets ben_elp_cache.g_cache_elpehs_instor;

3682: p_effective_date in date,
3683: p_hourly_salaried_code in varchar2) is
3684: --
3685: l_proc varchar2(100) := g_package||'check_py_freq_elig';
3686: l_inst_dets ben_elp_cache.g_cache_elpehs_instor;
3687: l_inst_count number;
3688: l_insttorrw_num binary_integer;
3689: l_ok boolean := false;
3690: l_rows_found boolean := false;

Line 3700: ben_elp_cache.elpehs_getcacdets

3696: hr_utility.set_location('Entering : '||l_proc,10);
3697: --
3698: -- Getting eligibility profile pay frequency by eligibility profile
3699: --
3700: ben_elp_cache.elpehs_getcacdets
3701: (p_effective_date => p_effective_date
3702: ,p_business_group_id => p_business_group_id
3703: ,p_eligy_prfl_id => p_eligy_prfl_id
3704: ,p_inst_set => l_inst_dets

Line 3800: l_inst_dets ben_elp_cache.g_cache_elpesa_instor;

3796: is
3797: --
3798: l_proc varchar2(100) := g_package||'check_service_area_elig';
3799: /*
3800: l_inst_dets ben_elp_cache.g_cache_elpesa_instor;
3801: */
3802: l_rows_found boolean := false;
3803: l_pad_rec per_addresses%rowtype;
3804: l_svc_area_id number(15);

Line 4111: l_inst_dets ben_elp_cache.g_cache_elpesh_instor;

4107: l_proc varchar2(100) := g_package||'check_sched_hrs_elig';
4108: l_ok boolean := false;
4109: l_rows_found boolean := false;
4110: --
4111: l_inst_dets ben_elp_cache.g_cache_elpesh_instor;
4112: l_inst_count number;
4113: l_insttorrw_num binary_integer;
4114: --
4115: l_sched_effective_date date;

Line 4156: ben_elp_cache.elpesh_getcacdets

4152:
4153: -- Getting eligibility profile scheduled hours by eligibility profile
4154: --
4155:
4156: ben_elp_cache.elpesh_getcacdets
4157: (p_effective_date => nvl(l_fonm_cvg_strt_dt, p_effective_date)
4158: ,p_business_group_id => p_business_group_id
4159: ,p_eligy_prfl_id => p_eligy_prfl_id
4160: ,p_inst_set => l_inst_dets

Line 4471: l_inst_dets ben_elp_cache.g_cache_elpebu_instor;

4467: p_effective_date in date,
4468: p_bargaining_unit_code in varchar2) is
4469: --
4470: l_proc varchar2(100) := g_package||'check_brg_unit_elig';
4471: l_inst_dets ben_elp_cache.g_cache_elpebu_instor;
4472: l_inst_count number;
4473: l_insttorrw_num binary_integer;
4474: l_ok boolean := false;
4475: l_rows_found boolean := false;

Line 4485: ben_elp_cache.elpebu_getcacdets

4481: hr_utility.set_location('Entering : '||l_proc,10);
4482: --
4483: -- Getting eligibility profile bargaining unit by eligibility profile
4484: --
4485: ben_elp_cache.elpebu_getcacdets
4486: (p_effective_date => p_effective_date
4487: ,p_business_group_id => p_business_group_id
4488: ,p_eligy_prfl_id => p_eligy_prfl_id
4489: ,p_inst_set => l_inst_dets

Line 4579: l_inst_dets ben_elp_cache.g_cache_elpelu_instor;

4575: p_effective_date in date,
4576: p_labour_union_member_flag in varchar2) is
4577: --
4578: l_proc varchar2(100) := g_package||'check_lbr_union_elig';
4579: l_inst_dets ben_elp_cache.g_cache_elpelu_instor;
4580: l_inst_count number;
4581: l_insttorrw_num binary_integer;
4582: l_ok boolean := false;
4583: l_rows_found boolean := false;

Line 4593: ben_elp_cache.elpelu_getcacdets

4589: hr_utility.set_location('Entering : '||l_proc,10);
4590: --
4591: -- Getting eligibility profile labour union membership by eligibility profile
4592: --
4593: ben_elp_cache.elpelu_getcacdets
4594: (p_effective_date => p_effective_date
4595: ,p_business_group_id => p_business_group_id
4596: ,p_eligy_prfl_id => p_eligy_prfl_id
4597: ,p_inst_set => l_inst_dets

Line 4688: l_inst_dets ben_elp_cache.g_cache_elpees_instor;

4684: p_assignment_status_type_id in number) is
4685: --
4686: l_proc varchar2(100) := g_package||'check_ee_stat_elig';
4687: --
4688: l_inst_dets ben_elp_cache.g_cache_elpees_instor;
4689: l_inst_count number;
4690: l_insttorrw_num binary_integer;
4691: --
4692: l_ok boolean := false;

Line 4703: ben_elp_cache.elpees_getcacdets

4699: hr_utility.set_location('Entering : '||l_proc,10);
4700: --
4701: -- Getting eligibility profile assignment status type by eligibility profile
4702: --
4703: ben_elp_cache.elpees_getcacdets
4704: (p_effective_date => p_effective_date
4705: ,p_business_group_id => p_business_group_id
4706: ,p_eligy_prfl_id => p_eligy_prfl_id
4707: ,p_inst_set => l_inst_dets

Line 4803: l_inst_dets ben_elp_cache.g_cache_elpelr_instor;

4799: p_abs_attd_reason_id in varchar2 default null,
4800: p_effective_date in date) is
4801: --
4802: l_proc varchar2(100) := g_package||'check_loa_rsn_elig';
4803: l_inst_dets ben_elp_cache.g_cache_elpelr_instor;
4804: l_inst_count number;
4805: l_insttorrw_num binary_integer;
4806: l_ok boolean := false;
4807: l_ok1 boolean := false;

Line 4835: ben_elp_cache.elpelr_getcacdets

4831: hr_utility.set_location('Entering : '||l_proc,10);
4832: --
4833: -- Getting eligibility profile leave of absence reason by eligibility profile
4834: --
4835: ben_elp_cache.elpelr_getcacdets
4836: (p_effective_date => p_effective_date
4837: ,p_business_group_id => p_business_group_id
4838: ,p_eligy_prfl_id => p_eligy_prfl_id
4839: ,p_inst_set => l_inst_dets

Line 5048: l_inst_dets ben_elp_cache.g_cache_elpeln_instor;

5044: p_effective_date in date,
5045: p_gre_name in varchar2) is
5046: --
5047: l_proc varchar2(100) := g_package||'check_lgl_ent_elig';
5048: l_inst_dets ben_elp_cache.g_cache_elpeln_instor;
5049: l_inst_count number;
5050: l_insttorrw_num binary_integer;
5051: l_ok boolean := false;
5052: l_rows_found boolean := false;

Line 5062: ben_elp_cache.elpeln_getcacdets

5058: hr_utility.set_location('Entering : '||l_proc,10);
5059: --
5060: -- Getting eligibility profile legal entity by eligibility profile
5061: --
5062: ben_elp_cache.elpeln_getcacdets
5063: (p_effective_date => p_effective_date
5064: ,p_business_group_id => p_business_group_id
5065: ,p_eligy_prfl_id => p_eligy_prfl_id
5066: ,p_inst_set => l_inst_dets

Line 5162: l_inst_dets ben_elp_cache.g_cache_elpepp_instor;

5158: p_lf_evt_ocrd_dt in date) is
5159: --
5160: l_proc varchar2(100) := g_package||
5161: 'check_prtt_in_anthr_pl_elig';
5162: l_inst_dets ben_elp_cache.g_cache_elpepp_instor;
5163: l_inst_count number;
5164: l_insttorrw_num binary_integer;
5165: l_ok boolean := false;
5166: l_rows_found boolean := false;

Line 5197: ben_elp_cache.elpepp_getcacdets

5193: hr_utility.set_location('Entering : '||l_proc,10);
5194: --
5195: -- Getting eligibility profile other plan by eligibility profile
5196: --
5197: ben_elp_cache.elpepp_getcacdets
5198: (p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date)
5199: ,p_business_group_id => p_business_group_id
5200: ,p_eligy_prfl_id => p_eligy_prfl_id
5201: ,p_inst_set => l_inst_dets

Line 5265: l_inst_dets ben_elp_cache.g_cache_elpefp_instor;

5261: p_effective_date in date,
5262: p_employment_category in varchar2) is
5263: --
5264: l_proc varchar2(100) := g_package||'check_fl_tm_pt_elig';
5265: l_inst_dets ben_elp_cache.g_cache_elpefp_instor;
5266: l_inst_count number;
5267: l_insttorrw_num binary_integer;
5268: l_rows_found boolean := false;
5269: l_ok boolean := false;

Line 5279: ben_elp_cache.elpefp_getcacdets

5275: hr_utility.set_location('Entering : '||l_proc,10);
5276: --
5277: -- Getting eligibility profile full/part time by eligibility profile
5278: --
5279: ben_elp_cache.elpefp_getcacdets
5280: (p_effective_date => p_effective_date
5281: ,p_business_group_id => p_business_group_id
5282: ,p_eligy_prfl_id => p_eligy_prfl_id
5283: ,p_inst_set => l_inst_dets

Line 5386: l_inst_dets ben_elp_cache.g_cache_elpecl_instor;

5382: p_plip_id in number default null,
5383: p_opt_id in number default null) is
5384: --
5385: l_proc varchar2(100):=g_package||'check_person_ben_bal';
5386: l_inst_dets ben_elp_cache.g_cache_elpecl_instor;
5387: l_inst_count number;
5388: l_insttorrw_num binary_integer;
5389: l_ok boolean := false;
5390: l_rows_found boolean := false;

Line 5401: ben_elp_cache.elpecl_getcacdets

5397: hr_utility.set_location('Entering: '||l_proc, 10);
5398: --
5399: -- Getting eligibility profile compensation level by eligibility profile
5400: --
5401: ben_elp_cache.elpecl_getcacdets
5402: (p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date)
5403: ,p_business_group_id => p_business_group_id
5404: ,p_comp_src_cd => 'BNFTBALTYP'
5405: ,p_eligy_prfl_id => p_eligy_prfl_id

Line 5534: l_inst_dets ben_elp_cache.g_cache_elpean_instor;

5530: p_person_id in number,
5531: p_effective_date in date) is
5532: --
5533: l_proc varchar2(100):=g_package||'check_asnt_set';
5534: l_inst_dets ben_elp_cache.g_cache_elpean_instor;
5535: l_inst_count number;
5536: l_insttorrw_num binary_integer;
5537: l_ok boolean := false;
5538: l_rows_found boolean := false;

Line 5551: ben_elp_cache.elpean_getcacdets

5547: hr_utility.set_location('Entering: '||l_proc, 10);
5548: --
5549: -- Getting eligibility profile compensation level by eligibility profile
5550: --
5551: ben_elp_cache.elpean_getcacdets
5552: (p_effective_date => p_effective_date
5553: ,p_business_group_id => p_business_group_id
5554: ,p_eligy_prfl_id => p_eligy_prfl_id
5555: ,p_inst_set => l_inst_dets

Line 5716: l_inst_dets ben_elp_cache.g_cache_elpecl_instor;

5712: p_plip_id in number default null,
5713: p_opt_id in number default null) is
5714: --
5715: l_proc varchar2(100):=g_package||'check_person_balance';
5716: l_inst_dets ben_elp_cache.g_cache_elpecl_instor;
5717: l_inst_count number;
5718: l_insttorrw_num binary_integer;
5719: l_ok boolean := false;
5720: l_rows_found boolean := false;

Line 5731: ben_elp_cache.elpecl_getcacdets

5727: hr_utility.set_location('Entering: '||l_proc, 10);
5728: --
5729: -- Getting eligibility profile compensation level by eligibility profile
5730: --
5731: ben_elp_cache.elpecl_getcacdets
5732: (p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date)
5733: ,p_business_group_id => p_business_group_id
5734: ,p_comp_src_cd => 'BALTYP'
5735: ,p_eligy_prfl_id => p_eligy_prfl_id

Line 5862: l_inst_dets ben_elp_cache.g_cache_elpeno_instor;

5858: p_business_group_id in number,
5859: p_effective_date in date) is
5860: --
5861: l_proc varchar2(100):=g_package||'check_elig_no_othr_cvg_prte';
5862: l_inst_dets ben_elp_cache.g_cache_elpeno_instor;
5863: l_inst_count number;
5864: l_insttorrw_num binary_integer;
5865: l_ok boolean := false;
5866: l_rows_found boolean := false;

Line 5875: ben_elp_cache.elpeno_getcacdets

5871: hr_utility.set_location('Entering: '||l_proc, 10);
5872: --
5873: -- Getting eligibility profile compensation level by eligibility profile
5874: --
5875: ben_elp_cache.elpeno_getcacdets
5876: (p_effective_date => p_effective_date,
5877: p_business_group_id => p_business_group_id,
5878: p_eligy_prfl_id => p_eligy_prfl_id,
5879: p_inst_set => l_inst_dets,

Line 5933: l_inst_dets ben_elp_cache.g_cache_elpelv_instor;

5929: p_leaving_reason in varchar2 default null,
5930: p_effective_date in date) is
5931: --
5932: l_proc varchar2(100):=g_package||'check_elig_lvg_rsn_prte';
5933: l_inst_dets ben_elp_cache.g_cache_elpelv_instor;
5934: l_inst_count number;
5935: l_insttorrw_num binary_integer;
5936: l_ok boolean := false;
5937: l_rows_found boolean := false;

Line 5948: ben_elp_cache.elpelv_getcacdets

5944: hr_utility.set_location('Entering: '||l_proc, 10);
5945: --
5946: -- Getting eligibility profile compensation level by eligibility profile
5947: --
5948: ben_elp_cache.elpelv_getcacdets
5949: (p_effective_date => p_effective_date,
5950: p_business_group_id => p_business_group_id,
5951: p_eligy_prfl_id => p_eligy_prfl_id,
5952: p_inst_set => l_inst_dets,

Line 6053: l_inst_dets ben_elp_cache.g_cache_elpeom_instor;

6049: p_business_group_id in number,
6050: p_effective_date in date) is
6051: --
6052: l_proc varchar2(100):=g_package||'check_elig_optd_mdcr_prte';
6053: l_inst_dets ben_elp_cache.g_cache_elpeom_instor;
6054: l_inst_count number;
6055: l_insttorrw_num binary_integer;
6056: l_ok boolean := false;
6057: l_rows_found boolean := false;

Line 6066: ben_elp_cache.elpeom_getcacdets

6062: hr_utility.set_location('Entering: '||l_proc, 10);
6063: --
6064: -- Getting eligibility profile compensation level by eligibility profile
6065: --
6066: ben_elp_cache.elpeom_getcacdets
6067: (p_effective_date => p_effective_date,
6068: p_business_group_id => p_business_group_id,
6069: p_eligy_prfl_id => p_eligy_prfl_id,
6070: p_inst_set => l_inst_dets,

Line 6125: l_inst_dets ben_elp_cache.g_cache_elpeep_instor;

6121: p_effective_date in date,
6122: p_lf_evt_ocrd_dt in date) is
6123: --
6124: l_proc varchar2(100):=g_package||'check_elig_enrld_anthr_pl';
6125: l_inst_dets ben_elp_cache.g_cache_elpeep_instor;
6126: l_inst_count number;
6127: l_insttorrw_num binary_integer;
6128: l_ok boolean := false;
6129: l_rows_found boolean := false;

Line 6140: ben_elp_cache.elpeep_getcacdets

6136: hr_utility.set_location('Entering: '||l_proc, 10);
6137: --
6138: -- Getting eligibility profile enrld in another plan by eligibility profile
6139: --
6140: ben_elp_cache.elpeep_getcacdets
6141: (p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
6142: p_business_group_id => p_business_group_id,
6143: p_eligy_prfl_id => p_eligy_prfl_id,
6144: p_inst_set => l_inst_dets,

Line 6241: l_inst_dets ben_elp_cache.g_cache_elpeei_instor;

6237: p_effective_date in date,
6238: p_lf_evt_ocrd_dt in date) is
6239: --
6240: l_proc varchar2(100):=g_package||'check_elig_enrld_anthr_oipl';
6241: l_inst_dets ben_elp_cache.g_cache_elpeei_instor;
6242: l_inst_count number;
6243: l_insttorrw_num binary_integer;
6244: l_ok boolean := false;
6245: l_rows_found boolean := false;

Line 6268: ben_elp_cache.elpeei_getcacdets

6264: hr_utility.set_location('Entering: '||l_proc, 10);
6265: --
6266: -- Getting eligibility profile compensation level by eligibility profile
6267: --
6268: ben_elp_cache.elpeei_getcacdets
6269: (p_effective_date => nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date)),
6270: p_business_group_id => p_business_group_id,
6271: p_eligy_prfl_id => p_eligy_prfl_id,
6272: p_inst_set => l_inst_dets,

Line 6374: l_inst_dets ben_elp_cache.g_cache_elpeeg_instor;

6370: )
6371: is
6372: --
6373: l_proc varchar2(100):=g_package||'check_elig_enrld_anthr_pgm';
6374: l_inst_dets ben_elp_cache.g_cache_elpeeg_instor;
6375: l_inst_count number;
6376: l_insttorrw_num binary_integer;
6377: l_ok boolean := false;
6378: l_rows_found boolean := false;

Line 6390: ben_elp_cache.elpeeg_getcacdets

6386: hr_utility.set_location('prfl_id: '||p_eligy_prfl_id, 10);
6387: --
6388: -- Getting eligibility profile compensation level by eligibility profile
6389: --
6390: ben_elp_cache.elpeeg_getcacdets
6391: (p_effective_date => nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date)),
6392: p_business_group_id => p_business_group_id,
6393: p_eligy_prfl_id => p_eligy_prfl_id,
6394: p_inst_set => l_inst_dets,

Line 6494: l_inst_dets ben_elp_cache.g_cache_elpedp_instor;

6490: p_effective_date in date,
6491: p_lf_evt_ocrd_dt in date) is
6492: --
6493: l_proc varchar2(100):=g_package||'check_elig_dpnt_cvrd_othr_pl';
6494: l_inst_dets ben_elp_cache.g_cache_elpedp_instor;
6495: l_inst_count number;
6496: l_insttorrw_num binary_integer;
6497: l_ok boolean := false;
6498: l_rows_found boolean := false;

Line 6528: ben_elp_cache.elpedp_getcacdets

6524: hr_utility.set_location('Entering: '||l_proc, 10);
6525: --
6526: -- Getting eligibility profile compensation level by eligibility profile
6527: --
6528: ben_elp_cache.elpedp_getcacdets
6529: (p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
6530: p_business_group_id => p_business_group_id,
6531: p_eligy_prfl_id => p_eligy_prfl_id,
6532: p_inst_set => l_inst_dets,

Line 6613: l_inst_dets ben_elp_cache.g_cache_elpeai_instor;

6609: p_effective_date in date,
6610: p_lf_evt_ocrd_dt in date) is
6611: --
6612: l_proc varchar2(100):=g_package||'check_elig_enrld_anthr_plip';
6613: l_inst_dets ben_elp_cache.g_cache_elpeai_instor;
6614: l_inst_count number;
6615: l_insttorrw_num binary_integer;
6616: l_ok boolean := false;
6617: l_rows_found boolean := false;

Line 6646: ben_elp_cache.elpeai_getcacdets

6642: hr_utility.set_location('Entering: '||l_proc, 10);
6643: --
6644: -- Getting eligibility profile compensation level by eligibility profile
6645: --
6646: ben_elp_cache.elpeai_getcacdets
6647: (p_effective_date => nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date)),
6648: p_business_group_id => p_business_group_id,
6649: p_eligy_prfl_id => p_eligy_prfl_id,
6650: p_inst_set => l_inst_dets,

Line 6733: l_inst_dets ben_elp_cache.g_cache_elpedi_instor;

6729: p_effective_date in date,
6730: p_lf_evt_ocrd_dt in date) is
6731: --
6732: l_proc varchar2(100):=g_package||'check_elig_dpnt_cvrd_othr_plip';
6733: l_inst_dets ben_elp_cache.g_cache_elpedi_instor;
6734: l_inst_count number;
6735: l_insttorrw_num binary_integer;
6736: l_ok boolean := false;
6737: l_rows_found boolean := false;

Line 6775: ben_elp_cache.elpedi_getcacdets

6771: hr_utility.set_location('Entering: '||l_proc, 10);
6772: --
6773: -- Getting eligibility profile compensation level by eligibility profile
6774: --
6775: ben_elp_cache.elpedi_getcacdets
6776: (p_effective_date => nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date)),
6777: p_business_group_id => p_business_group_id,
6778: p_eligy_prfl_id => p_eligy_prfl_id,
6779: p_inst_set => l_inst_dets,

Line 6862: l_inst_dets ben_elp_cache.g_cache_elpeet_instor;

6858: p_lf_evt_ocrd_dt in date) is
6859: --
6860: l_proc varchar2(100):=g_package||'check_elig_enrld_anthr_ptip';
6861: --
6862: l_inst_dets ben_elp_cache.g_cache_elpeet_instor;
6863: l_inst_count number;
6864: l_insttorrw_num binary_integer;
6865: l_ok boolean := false;
6866: l_rows_found boolean := false;

Line 6903: ben_elp_cache.elpeet_getcacdets

6899: hr_utility.set_location('l_fonm_cvg_strt_dt: '||l_fonm_cvg_strt_dt, 10);
6900: --
6901: -- Getting eligibility profile compensation level by eligibility profile
6902: --
6903: ben_elp_cache.elpeet_getcacdets
6904: (p_effective_date => nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date)),
6905: p_business_group_id => p_business_group_id,
6906: p_eligy_prfl_id => p_eligy_prfl_id,
6907: p_inst_set => l_inst_dets,

Line 7053: l_inst_dets ben_elp_cache.g_cache_elpedt_instor;

7049: p_effective_date in date,
7050: p_lf_evt_ocrd_dt in date) is
7051: --
7052: l_proc varchar2(100):=g_package||'check_elig_dpnt_cvrd_othr_ptip';
7053: l_inst_dets ben_elp_cache.g_cache_elpedt_instor;
7054: l_inst_count number;
7055: l_insttorrw_num binary_integer;
7056: l_ok boolean := false;
7057: l_rows_found boolean := false;

Line 7106: ben_elp_cache.elpedt_getcacdets

7102: hr_utility.set_location('Entering: '||l_proc, 10);
7103: --
7104: -- Getting eligibility profile compensation level by eligibility profile
7105: --
7106: ben_elp_cache.elpedt_getcacdets
7107: (p_effective_date => nvl(l_fonm_cvg_strt_dt,
7108: nvl(p_lf_evt_ocrd_dt,p_effective_date)),
7109: p_business_group_id => p_business_group_id,
7110: p_eligy_prfl_id => p_eligy_prfl_id,

Line 7208: l_inst_dets ben_elp_cache.g_cache_elpedg_instor;

7204: p_effective_date in date,
7205: p_lf_evt_ocrd_dt in date) is
7206: --
7207: l_proc varchar2(100):=g_package||'check_elig_dpnt_cvrd_othr_pgm';
7208: l_inst_dets ben_elp_cache.g_cache_elpedg_instor;
7209: l_inst_count number;
7210: l_insttorrw_num binary_integer;
7211: l_ok boolean := false;
7212: l_rows_found boolean := false;

Line 7242: ben_elp_cache.elpedg_getcacdets

7238: hr_utility.set_location('Entering: '||l_proc, 10);
7239: --
7240: -- Getting eligibility profile compensation level by eligibility profile
7241: --
7242: ben_elp_cache.elpedg_getcacdets
7243: (p_effective_date => nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date)),
7244: p_business_group_id => p_business_group_id,
7245: p_eligy_prfl_id => p_eligy_prfl_id,
7246: p_inst_set => l_inst_dets,

Line 7328: l_inst_dets ben_elp_cache.g_cache_elpecq_instor;

7324: p_lf_evt_ocrd_dt in date,
7325: p_effective_date in date) is
7326: --
7327: l_proc varchar2(100):=g_package||'check_elig_cbr_quald_bnf';
7328: l_inst_dets ben_elp_cache.g_cache_elpecq_instor;
7329: l_quald_bnf_flag ben_cbr_quald_bnf.quald_bnf_flag%type;
7330: l_inst_count number;
7331: l_insttorrw_num binary_integer;
7332: l_ok boolean := false;

Line 7366: ben_elp_cache.elpecq_getcacdets

7362: hr_utility.set_location('Entering: '||l_proc, 10);
7363: --
7364: -- Getting eligibility profile compensation level by eligibility profile
7365: --
7366: ben_elp_cache.elpecq_getcacdets
7367: (p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
7368: p_business_group_id => p_business_group_id,
7369: p_eligy_prfl_id => p_eligy_prfl_id,
7370: p_inst_set => l_inst_dets,

Line 7432: l_inst_set ben_elp_cache.g_elp_cache := ben_elp_cache.g_elp_cache();

7428: is
7429: --
7430: l_proc varchar2(100) := g_package||'check_dsbld_elig';
7431: --
7432: l_inst_set ben_elp_cache.g_elp_cache := ben_elp_cache.g_elp_cache();
7433: l_ok boolean := false;
7434: l_rows_found boolean := false;
7435: l_ele_num pls_integer;
7436: l_crit_passed boolean;

Line 7443: ben_elp_cache.elpeds_getdets

7439: begin
7440: --
7441: hr_utility.set_location('Entering : '||l_proc,10);
7442: --
7443: ben_elp_cache.elpeds_getdets
7444: (p_effective_date => p_effective_date
7445: ,p_eligy_prfl_id => p_eligy_prfl_id
7446: --
7447: ,p_inst_set => l_inst_set

Line 7544: l_inst_set ben_elp_cache.g_elp_cache := ben_elp_cache.g_elp_cache();

7540: is
7541: --
7542: l_proc varchar2(100) := g_package||'check_tbco_use_elig';
7543: --
7544: l_inst_set ben_elp_cache.g_elp_cache := ben_elp_cache.g_elp_cache();
7545: l_ok boolean := false;
7546: l_rows_found boolean := false;
7547: l_ele_num pls_integer;
7548: l_crit_passed boolean;

Line 7555: ben_elp_cache.elpetu_getdets

7551: begin
7552: --
7553: hr_utility.set_location('Entering : '||l_proc,10);
7554: --
7555: ben_elp_cache.elpetu_getdets
7556: (p_effective_date => p_effective_date
7557: ,p_eligy_prfl_id => p_eligy_prfl_id
7558: --
7559: ,p_inst_set => l_inst_set

Line 7655: l_inst_set ben_elp_cache.g_elp_cache := ben_elp_cache.g_elp_cache();

7651: p_effective_date in date) is
7652: --
7653: l_proc varchar2(100):=g_package||'.check_ttl_cvg_vol_elig';
7654: --
7655: l_inst_set ben_elp_cache.g_elp_cache := ben_elp_cache.g_elp_cache();
7656: l_ok boolean := false;
7657: l_rows_found boolean := false;
7658: l_ele_num pls_integer;
7659: --

Line 7695: ben_elp_cache.elpetc_getdets

7691: begin
7692: --
7693: hr_utility.set_location('Entering: '||l_proc, 10);
7694: --
7695: ben_elp_cache.elpetc_getdets
7696: (p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date)
7697: ,p_eligy_prfl_id => p_eligy_prfl_id
7698: --
7699: ,p_inst_set => l_inst_set

Line 7792: l_inst_set ben_elp_cache.g_elp_cache := ben_elp_cache.g_elp_cache();

7788: p_effective_date in date) is
7789: --
7790: l_proc varchar2(100):=g_package||'.check_ttl_prtt_elig';
7791: --
7792: l_inst_set ben_elp_cache.g_elp_cache := ben_elp_cache.g_elp_cache();
7793: l_ok boolean := false;
7794: l_rows_found boolean := false;
7795: l_ele_num pls_integer;
7796: --

Line 7832: ben_elp_cache.elpetp_getdets

7828: begin
7829: --
7830: hr_utility.set_location('Entering: '||l_proc, 10);
7831: --
7832: ben_elp_cache.elpetp_getdets
7833: (p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date)
7834: ,p_eligy_prfl_id => p_eligy_prfl_id
7835: --
7836: ,p_inst_set => l_inst_set

Line 7928: l_inst_set ben_elp_cache.g_elp_cache := ben_elp_cache.g_elp_cache();

7924: p_effective_date in date) is
7925: --
7926: l_proc varchar2(100):=g_package||'.check_anthr_pl_elig';
7927: --
7928: l_inst_set ben_elp_cache.g_elp_cache := ben_elp_cache.g_elp_cache();
7929: l_ok boolean := false;
7930: l_rows_found boolean := false;
7931: l_ele_num pls_integer;
7932: --

Line 7957: ben_elp_cache.elpeop_getdets

7953: begin
7954: --
7955: hr_utility.set_location('Entering: '||l_proc, 10);
7956: --
7957: ben_elp_cache.elpeop_getdets
7958: (p_effective_date => p_effective_date
7959: ,p_eligy_prfl_id => p_eligy_prfl_id
7960: --
7961: ,p_inst_set => l_inst_set

Line 8038: l_inst_set ben_elp_cache.g_elp_cache := ben_elp_cache.g_elp_cache();

8034: p_effective_date in date) is
8035: --
8036: l_proc varchar2(100):=g_package||'.check_hlth_cvg_elig';
8037: --
8038: l_inst_set ben_elp_cache.g_elp_cache := ben_elp_cache.g_elp_cache();
8039: l_ok boolean := false;
8040: l_rows_found boolean := false;
8041: l_ele_num pls_integer;
8042: --

Line 8075: ben_elp_cache.elpehc_getdets

8071: begin
8072: --
8073: hr_utility.set_location('Entering: '||l_proc, 10);
8074: --
8075: ben_elp_cache.elpehc_getdets
8076: (p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date)
8077: ,p_eligy_prfl_id => p_eligy_prfl_id
8078: --
8079: ,p_inst_set => l_inst_set

Line 8161: l_inst_set ben_elp_cache.g_elp_cache := ben_elp_cache.g_elp_cache();

8157: p_effective_date in date) is
8158: --
8159: l_proc varchar2(100):=g_package||'.check_comptncy_elig';
8160: --
8161: l_inst_set ben_elp_cache.g_elp_cache := ben_elp_cache.g_elp_cache();
8162: l_ok boolean := false;
8163: l_rows_found boolean := false;
8164: l_ele_num pls_integer;
8165: l_effective_date date;

Line 8191: ben_elp_cache.elpecy_getdets

8187: begin
8188: --
8189: hr_utility.set_location('Entering: '||l_proc, 10);
8190: --
8191: ben_elp_cache.elpecy_getdets
8192: (p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date)
8193: ,p_eligy_prfl_id => p_eligy_prfl_id
8194: --
8195: ,p_inst_set => l_inst_set

Line 8315: l_inst_set ben_elp_cache.g_elp_cache := ben_elp_cache.g_elp_cache();

8311: --
8312:
8313: l_proc varchar2(100):=g_package||'.check_perf_rtng_elig';
8314: --
8315: l_inst_set ben_elp_cache.g_elp_cache := ben_elp_cache.g_elp_cache();
8316: l_ok boolean := false;
8317: l_rows_found boolean := false;
8318: l_ele_num pls_integer;
8319: l_crit_passed boolean;

Line 8379: ben_elp_cache.elpepr_getdets

8375: --
8376: hr_utility.set_location('Entering: '||l_proc, 10);
8377: --
8378: if p_perf_rtng_cd is null then
8379: ben_elp_cache.elpepr_getdets
8380: (p_effective_date => p_effective_date
8381: ,p_eligy_prfl_id => p_eligy_prfl_id
8382: --
8383: ,p_inst_set => l_inst_set

Line 8559: l_inst_set ben_elp_cache.g_elp_cache := ben_elp_cache.g_elp_cache();

8555: p_lf_evt_ocrd_dt date,
8556: p_pay_basis_id number) is
8557: --
8558: l_proc varchar2(100) := g_package||' check_qua_in_gr_elig';
8559: l_inst_set ben_elp_cache.g_elp_cache := ben_elp_cache.g_elp_cache();
8560: l_ele_num pls_integer;
8561: --
8562: l_dummy varchar2(10) ;
8563: --

Line 8661: ben_elp_cache.elpeqg_getdets

8657: begin
8658: --
8659: hr_utility.set_location('Entering: '||l_proc, 10);
8660: --
8661: ben_elp_cache.elpeqg_getdets
8662: (p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date)
8663: ,p_eligy_prfl_id => p_eligy_prfl_id
8664: --
8665: ,p_inst_set => l_inst_set