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_COBRA_REQUIREMENTS dependencies on BEN_CBR_PER_IN_LER

Line 222: from ben_cbr_per_in_ler crp

218: --
219: cursor c_chk_init_evt
220: is
221: select null
222: from ben_cbr_per_in_ler crp
223: where crp.per_in_ler_id = p_per_in_ler_id
224: and crp.business_group_id = p_business_group_id
225: and crp.init_evt_flag = 'Y';
226: --

Line 455: ,ben_cbr_per_in_ler crp

451: --
452: cursor c_get_quald_bnf is
453: select cqb.*
454: from ben_cbr_quald_bnf cqb
455: ,ben_cbr_per_in_ler crp
456: ,ben_per_in_ler pil
457: where cqb.quald_bnf_person_id = p_person_id
458: and cqb.business_group_id = p_business_group_id
459: and cqb.cbr_elig_perd_end_dt >= p_lf_evt_ocrd_dt

Line 522: ,ben_cbr_per_in_ler crp

518: cursor c_get_prvs_elig_end_dt(p_cbr_quald_bnf_id in number) is
519: select crp.prvs_elig_perd_end_dt
520: from ben_ler_f ler
521: ,ben_per_in_ler pil
522: ,ben_cbr_per_in_ler crp
523: where ler.ler_id = pil.ler_id
524: and pil.per_in_ler_id = crp.per_in_ler_id
525: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
526: and pil.business_group_id = p_business_group_id

Line 532: from ben_cbr_per_in_ler crp2

528: and crp.cbr_quald_bnf_id = p_cbr_quald_bnf_id
529: and crp.business_group_id = ler.business_group_id
530: and ler.typ_cd = 'DSBLTY'
531: and crp.cnt_num = (select max(crp2.cnt_num)
532: from ben_cbr_per_in_ler crp2
533: ,ben_per_in_ler pil2
534: ,ben_ler_f ler2
535: where crp2.cbr_quald_bnf_id = p_cbr_quald_bnf_id
536: and crp2.business_group_id = pil2.business_group_id

Line 551: ,ben_cbr_per_in_ler crp

547: select peo.*
548: ,pil.lf_evt_ocrd_dt
549: from ben_ler_f ler
550: ,ben_per_in_ler pil
551: ,ben_cbr_per_in_ler crp
552: ,ben_elig_to_prte_rsn_f peo
553: where ler.ler_id = pil.ler_id
554: and pil.per_in_ler_id = crp.per_in_ler_id
555: and crp.cbr_quald_bnf_id = p_cbr_quald_bnf_id

Line 1697: ,ben_cbr_per_in_ler crp

1693: cursor c_get_cbr_quald_bnf
1694: is
1695: select cqb.*
1696: from ben_cbr_quald_bnf cqb
1697: ,ben_cbr_per_in_ler crp
1698: ,ben_per_in_ler pil
1699: where cqb.quald_bnf_person_id = p_person_id
1700: and nvl(cqb.cbr_elig_perd_end_dt,l_lf_evt_ocrd_dt) >= l_lf_evt_ocrd_dt
1701: and cqb.pgm_id = l_pgm_id

Line 1725: ,ben_cbr_per_in_ler crp

1721: cursor c_get_cvrd_emp_person_id
1722: is
1723: select cqb.cvrd_emp_person_id
1724: from ben_cbr_quald_bnf cqb
1725: ,ben_cbr_per_in_ler crp
1726: ,ben_per_in_ler pil
1727: where cqb.quald_bnf_person_id = l_enrld_person_id
1728: and cqb.cbr_elig_perd_end_dt > l_lf_evt_ocrd_dt
1729: and crp.cbr_quald_bnf_id = cqb.cbr_quald_bnf_id

Line 2140: ,ben_cbr_per_in_ler crp

2136: cursor c_get_cbr_quald_bnf(p_quald_bnf_person_id in number)
2137: is
2138: select cqb.*
2139: from ben_cbr_quald_bnf cqb
2140: ,ben_cbr_per_in_ler crp
2141: ,ben_per_in_ler pil
2142: where cqb.quald_bnf_person_id = p_quald_bnf_person_id
2143: and cqb.quald_bnf_flag = 'Y'
2144: and cqb.cbr_elig_perd_end_dt >= p_lf_evt_ocrd_dt

Line 2165: from ben_cbr_per_in_ler crp

2161: and pdp.business_group_id = p_business_group_id;
2162: --
2163: cursor c_chk_init_evt is
2164: select crp.*
2165: from ben_cbr_per_in_ler crp
2166: where crp.per_in_ler_id = p_per_in_ler_id
2167: and crp.init_evt_flag = 'Y'
2168: and crp.business_group_id = p_business_group_id;
2169: --

Line 2346: l_cnt_num ben_cbr_per_in_ler.cnt_num%type;

2342: l_cbr_quald_bnf_id ben_cbr_quald_bnf.cbr_quald_bnf_id%type;
2343: l_quald_bnf_flag ben_cbr_quald_bnf.quald_bnf_flag%type;
2344: l_cvrd_emp_end_date date;
2345: l_cbr_elig_perd_end_dt date;
2346: l_cnt_num ben_cbr_per_in_ler.cnt_num%type;
2347: l_cbr_per_in_ler_id ben_cbr_per_in_ler.cbr_per_in_ler_id%type;
2348: l_crp_object_version_number ben_cbr_per_in_ler.object_version_number%type;
2349: l_cqb_object_version_number ben_cbr_per_in_ler.object_version_number%type;
2350: l_object_version_number ben_cbr_quald_bnf.object_version_number%type;

Line 2347: l_cbr_per_in_ler_id ben_cbr_per_in_ler.cbr_per_in_ler_id%type;

2343: l_quald_bnf_flag ben_cbr_quald_bnf.quald_bnf_flag%type;
2344: l_cvrd_emp_end_date date;
2345: l_cbr_elig_perd_end_dt date;
2346: l_cnt_num ben_cbr_per_in_ler.cnt_num%type;
2347: l_cbr_per_in_ler_id ben_cbr_per_in_ler.cbr_per_in_ler_id%type;
2348: l_crp_object_version_number ben_cbr_per_in_ler.object_version_number%type;
2349: l_cqb_object_version_number ben_cbr_per_in_ler.object_version_number%type;
2350: l_object_version_number ben_cbr_quald_bnf.object_version_number%type;
2351: --

Line 2348: l_crp_object_version_number ben_cbr_per_in_ler.object_version_number%type;

2344: l_cvrd_emp_end_date date;
2345: l_cbr_elig_perd_end_dt date;
2346: l_cnt_num ben_cbr_per_in_ler.cnt_num%type;
2347: l_cbr_per_in_ler_id ben_cbr_per_in_ler.cbr_per_in_ler_id%type;
2348: l_crp_object_version_number ben_cbr_per_in_ler.object_version_number%type;
2349: l_cqb_object_version_number ben_cbr_per_in_ler.object_version_number%type;
2350: l_object_version_number ben_cbr_quald_bnf.object_version_number%type;
2351: --
2352: cursor c_chk_cvrd_emp is

Line 2349: l_cqb_object_version_number ben_cbr_per_in_ler.object_version_number%type;

2345: l_cbr_elig_perd_end_dt date;
2346: l_cnt_num ben_cbr_per_in_ler.cnt_num%type;
2347: l_cbr_per_in_ler_id ben_cbr_per_in_ler.cbr_per_in_ler_id%type;
2348: l_crp_object_version_number ben_cbr_per_in_ler.object_version_number%type;
2349: l_cqb_object_version_number ben_cbr_per_in_ler.object_version_number%type;
2350: l_object_version_number ben_cbr_quald_bnf.object_version_number%type;
2351: --
2352: cursor c_chk_cvrd_emp is
2353: select null

Line 2392: from ben_cbr_per_in_ler crp

2388: and ler.qualg_evt_flag = 'Y';
2389: --
2390: cursor c_check_cbr_per_in_ler is
2391: select crp.*
2392: from ben_cbr_per_in_ler crp
2393: where (crp.per_in_ler_id = p_per_in_ler_id
2394: or (crp.per_in_ler_id
2395: in (select distinct crp2.per_in_ler_id
2396: from ben_cbr_per_in_ler crp2

Line 2396: from ben_cbr_per_in_ler crp2

2392: from ben_cbr_per_in_ler crp
2393: where (crp.per_in_ler_id = p_per_in_ler_id
2394: or (crp.per_in_ler_id
2395: in (select distinct crp2.per_in_ler_id
2396: from ben_cbr_per_in_ler crp2
2397: ,ben_cbr_quald_bnf cqb
2398: ,ben_per_in_ler pil
2399: where cqb.cvrd_emp_person_id = p_cvrd_emp_person_id
2400: and cqb.cbr_quald_bnf_id = crp2.cbr_quald_bnf_id

Line 2412: from ben_cbr_per_in_ler crp

2408: and crp.cbr_quald_bnf_id = p_cbr_quald_bnf_id;
2409: --
2410: cursor c_get_cnt_num(p_cbr_quald_bnf_id in number) is
2411: select max(crp.cnt_num)
2412: from ben_cbr_per_in_ler crp
2413: ,ben_per_in_ler pil
2414: where crp.cbr_quald_bnf_id = p_cbr_quald_bnf_id
2415: and crp.business_group_id = p_business_group_id
2416: and crp.per_in_ler_id = pil.per_in_ler_id

Line 2423: ,ben_cbr_per_in_ler crp

2419: --
2420: cursor c_get_all_quald_dpnts is
2421: select cqb.*
2422: from ben_cbr_quald_bnf cqb
2423: ,ben_cbr_per_in_ler crp
2424: ,ben_per_in_ler pil
2425: where cqb.cvrd_emp_person_id = l_cvrd_emp_person_id
2426: and cqb.quald_bnf_person_id <> p_person_id
2427: and cqb.quald_bnf_flag = 'Y'

Line 2452: ,ben_cbr_per_in_ler crp

2448: --
2449: cursor c_get_cvrd_emp_pil(p_cvrd_emp_person_id in number) is
2450: select crp.*
2451: from ben_cbr_quald_bnf cqb
2452: ,ben_cbr_per_in_ler crp
2453: ,ben_per_in_ler pil
2454: where cqb.cvrd_emp_person_id = p_cvrd_emp_person_id
2455: and cqb.quald_bnf_person_id = cqb.cvrd_emp_person_id
2456: and cqb.pgm_id = nvl(p_pgm_id, cqb.pgm_id)

Line 2546: ben_cbr_per_in_ler_api.create_cbr_per_in_ler

2542: if p_quald_bnf_flag = 'Y' then
2543: --
2544: -- Write COBRA per in ler row.
2545: --
2546: ben_cbr_per_in_ler_api.create_cbr_per_in_ler
2547: (p_validate => p_validate
2548: ,p_cbr_per_in_ler_id => l_cbr_per_in_ler_id
2549: ,p_init_evt_flag => 'Y'
2550: ,p_cnt_num => 1

Line 2592: ben_cbr_per_in_ler_api.create_cbr_per_in_ler

2588: fetch c_get_cvrd_emp_pil into l_crp2_rec;
2589: if c_get_cvrd_emp_pil%found then
2590: close c_get_cvrd_emp_pil;
2591: --
2592: ben_cbr_per_in_ler_api.create_cbr_per_in_ler
2593: (p_validate => p_validate
2594: ,p_cbr_per_in_ler_id => l_cbr_per_in_ler_id
2595: ,p_init_evt_flag => 'Y'
2596: ,p_cnt_num => 1

Line 2706: ben_cbr_per_in_ler_api.create_cbr_per_in_ler

2702: fetch c_get_cnt_num into l_cnt_num;
2703: close c_get_cnt_num;
2704: --
2705: hr_utility.set_location('l_cnt_num : ' || l_cnt_num, 10);
2706: ben_cbr_per_in_ler_api.create_cbr_per_in_ler
2707: (p_validate => p_validate
2708: ,p_cbr_per_in_ler_id => l_cbr_per_in_ler_id
2709: ,p_init_evt_flag => 'N'
2710: ,p_cnt_num => l_cnt_num + 1

Line 2751: ben_cbr_per_in_ler_api.create_cbr_per_in_ler

2747: fetch c_get_cnt_num into l_cnt_num;
2748: close c_get_cnt_num;
2749: --
2750: hr_utility.set_location('l_cnt_num : ' || l_cnt_num, 10);
2751: ben_cbr_per_in_ler_api.create_cbr_per_in_ler
2752: (p_validate => p_validate
2753: ,p_cbr_per_in_ler_id => l_cbr_per_in_ler_id
2754: ,p_init_evt_flag => 'N'
2755: ,p_cnt_num => l_cnt_num + 1

Line 2793: l_cbr_per_in_ler_id ben_cbr_per_in_ler.cbr_per_in_ler_id%type;

2789: l_cbr_inelg_rsn_cd ben_cbr_quald_bnf.cbr_inelg_rsn_cd%type;
2790: l_effective_date date;
2791: l_dpnt_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%type;
2792: l_cbr_quald_bnf_id ben_cbr_quald_bnf.cbr_quald_bnf_id%type;
2793: l_cbr_per_in_ler_id ben_cbr_per_in_ler.cbr_per_in_ler_id%type;
2794: l_cqb_object_version_number ben_cbr_quald_bnf.object_version_number%type;
2795: l_cqb_quald_bnf_flag ben_cbr_quald_bnf.quald_bnf_flag%type;
2796: l_crp_object_version_number ben_cbr_quald_bnf.object_version_number%type;
2797: l_cbr_elig_perd_end_dt ben_pil_elctbl_chc_popl.cbr_elig_perd_end_dt%type;

Line 2805: ,ben_cbr_per_in_ler crp

2801: cursor c_get_cbr_quald_bnf
2802: is
2803: select cqb.*
2804: from ben_cbr_quald_bnf cqb
2805: ,ben_cbr_per_in_ler crp
2806: ,ben_per_in_ler pil
2807: where cqb.quald_bnf_person_id = p_person_id
2808: and cqb.quald_bnf_flag = 'Y'
2809: and cqb.cbr_elig_perd_end_dt >= l_effective_date

Line 2820: from ben_cbr_per_in_ler crp

2816: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');
2817: --
2818: cursor c_get_cnt_num is
2819: select max(crp.cnt_num)
2820: from ben_cbr_per_in_ler crp
2821: ,ben_per_in_ler pil
2822: where crp.cbr_quald_bnf_id = l_cbr_quald_bnf_id
2823: and crp.business_group_id = p_business_group_id
2824: and crp.per_in_ler_id = pil.per_in_ler_id

Line 2988: l_crp_object_version_number ben_cbr_per_in_ler.object_version_number%type;

2984: ,p_validate in boolean default false) is
2985: --
2986: l_effective_date ben_per_in_ler.lf_evt_ocrd_dt%type;
2987: l_cqb_object_version_number ben_cbr_quald_bnf.object_version_number%type;
2988: l_crp_object_version_number ben_cbr_per_in_ler.object_version_number%type;
2989: l_cbr_per_in_ler_id ben_cbr_per_in_ler.cbr_per_in_ler_id%type;
2990: l_cnt_num ben_cbr_per_in_ler.cnt_num%type;
2991: l_exists varchar2(1);
2992: l_proc varchar2(80) := g_package||'.end_cobra_eligibility';

Line 2989: l_cbr_per_in_ler_id ben_cbr_per_in_ler.cbr_per_in_ler_id%type;

2985: --
2986: l_effective_date ben_per_in_ler.lf_evt_ocrd_dt%type;
2987: l_cqb_object_version_number ben_cbr_quald_bnf.object_version_number%type;
2988: l_crp_object_version_number ben_cbr_per_in_ler.object_version_number%type;
2989: l_cbr_per_in_ler_id ben_cbr_per_in_ler.cbr_per_in_ler_id%type;
2990: l_cnt_num ben_cbr_per_in_ler.cnt_num%type;
2991: l_exists varchar2(1);
2992: l_proc varchar2(80) := g_package||'.end_cobra_eligibility';
2993: --

Line 2990: l_cnt_num ben_cbr_per_in_ler.cnt_num%type;

2986: l_effective_date ben_per_in_ler.lf_evt_ocrd_dt%type;
2987: l_cqb_object_version_number ben_cbr_quald_bnf.object_version_number%type;
2988: l_crp_object_version_number ben_cbr_per_in_ler.object_version_number%type;
2989: l_cbr_per_in_ler_id ben_cbr_per_in_ler.cbr_per_in_ler_id%type;
2990: l_cnt_num ben_cbr_per_in_ler.cnt_num%type;
2991: l_exists varchar2(1);
2992: l_proc varchar2(80) := g_package||'.end_cobra_eligibility';
2993: --
2994: cursor c_get_cnt_num is

Line 2996: from ben_cbr_per_in_ler crp

2992: l_proc varchar2(80) := g_package||'.end_cobra_eligibility';
2993: --
2994: cursor c_get_cnt_num is
2995: select max(crp.cnt_num)
2996: from ben_cbr_per_in_ler crp
2997: ,ben_per_in_ler pil
2998: where crp.cbr_quald_bnf_id = p_cbr_quald_bnf_id
2999: and crp.business_group_id = p_business_group_id
3000: and crp.per_in_ler_id = pil.per_in_ler_id

Line 3007: from ben_cbr_per_in_ler crp

3003:
3004: --
3005: cursor c_chk_cbr_per_in_ler is
3006: select null
3007: from ben_cbr_per_in_ler crp
3008: where crp.cbr_quald_bnf_id = p_cbr_quald_bnf_id
3009: and crp.per_in_ler_id = p_per_in_ler_id;
3010: --
3011: begin

Line 3029: ben_cbr_per_in_ler_api.create_cbr_per_in_ler

3025: open c_get_cnt_num;
3026: fetch c_get_cnt_num into l_cnt_num;
3027: close c_get_cnt_num;
3028: --
3029: ben_cbr_per_in_ler_api.create_cbr_per_in_ler
3030: (p_validate => p_validate
3031: ,p_cbr_per_in_ler_id => l_cbr_per_in_ler_id
3032: ,p_init_evt_flag => 'N'
3033: ,p_cnt_num => l_cnt_num + 1