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_PER_IN_LER

Line 191: from ben_per_in_ler pil

187: --
188: cursor c_get_lf_evt_ocrd_dt
189: is
190: select pil.lf_evt_ocrd_dt
191: from ben_per_in_ler pil
192: where pil.per_in_ler_id = p_per_in_ler_id
193: and pil.business_group_id = p_business_group_id;
194: --
195: begin

Line 323: l_dsblty_ler_id ben_per_in_ler.ler_id%type;

319: ,p_effective_date in date
320: ,p_business_group_id in number) return date is
321: --
322: l_proc varchar2(80) := g_package||'.get_dsblty_elig_perd_end_dt';
323: l_dsblty_ler_id ben_per_in_ler.ler_id%type;
324: l_dsblty_elig_perd_end_dt date default null;
325: --
326: cursor c_get_dsblty_ler
327: is

Line 434: ,ben_per_in_ler pil

430: select peo.*
431: ,ler.typ_cd
432: ,pil.lf_evt_ocrd_dt
433: from ben_elig_to_prte_rsn_f peo
434: ,ben_per_in_ler pil
435: ,ben_ler_f ler
436: where pil.ler_id = peo.ler_id
437: and pil.per_in_ler_id = p_per_in_ler_id
438: and pil.business_group_id = p_business_group_id

Line 456: ,ben_per_in_ler pil

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
460: and cqb.cbr_quald_bnf_id = crp.cbr_quald_bnf_id

Line 511: ,ben_per_in_ler pil

507: --
508: cursor c_get_enddsblty_ler is
509: select null
510: from ben_ler_f ler
511: ,ben_per_in_ler pil
512: where ler.ler_id = pil.ler_id
513: and pil.per_in_ler_id = p_per_in_ler_id
514: and ler.typ_cd = 'ENDDSBLTY'
515: and p_effective_date between

Line 521: ,ben_per_in_ler pil

517: --
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')

Line 533: ,ben_per_in_ler pil2

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
537: and crp2.business_group_id = ler2.business_group_id

Line 550: ,ben_per_in_ler pil

546: cursor c_get_init_ler(p_cbr_quald_bnf_id in number) is
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

Line 1670: l_effective_date ben_per_in_ler.lf_evt_ocrd_dt%type;

1666: ,p_effective_date in date
1667: ,p_prtt_enrt_rslt_id in number
1668: ,p_validate in boolean default false) is
1669: --
1670: l_effective_date ben_per_in_ler.lf_evt_ocrd_dt%type;
1671: l_quald_bnf_flag ben_cbr_quald_bnf.quald_bnf_flag%type;
1672: l_cvrd_emp_person_id ben_cbr_quald_bnf.cvrd_emp_person_id%type;
1673: l_dsbld_apls boolean;
1674: l_update boolean;

Line 1677: l_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type;

1673: l_dsbld_apls boolean;
1674: l_update boolean;
1675: l_cbr_elig_perd_strt_dt ben_cbr_quald_bnf.cbr_elig_perd_strt_dt%type;
1676: l_cbr_elig_perd_end_dt ben_cbr_quald_bnf.cbr_elig_perd_end_dt%type;
1677: l_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type;
1678: l_old_cbr_elig_perd_end_dt ben_cbr_quald_bnf.cbr_elig_perd_end_dt%type;
1679: l_cbr_quald_bnf_id ben_cbr_quald_bnf.cbr_quald_bnf_id%type;
1680: l_cqb_object_version_number ben_cbr_quald_bnf.object_version_number%type;
1681:

Line 1682: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;

1678: l_old_cbr_elig_perd_end_dt ben_cbr_quald_bnf.cbr_elig_perd_end_dt%type;
1679: l_cbr_quald_bnf_id ben_cbr_quald_bnf.cbr_quald_bnf_id%type;
1680: l_cqb_object_version_number ben_cbr_quald_bnf.object_version_number%type;
1681:
1682: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
1683: l_exists varchar2(1);
1684: l_init_evt boolean := false;
1685: l_pgm_id ben_pgm_f.pgm_id%type;
1686: l_ptip_id ben_ptip_f.ptip_id%type;

Line 1698: ,ben_per_in_ler pil

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
1702: and nvl(cqb.ptip_id,l_ptip_id) = l_ptip_id

Line 1726: ,ben_per_in_ler pil

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
1730: and cqb.business_group_id = p_business_group_id

Line 2122: l_effective_date ben_per_in_ler.lf_evt_ocrd_dt%type;

2118: ,p_business_group_id in number
2119: ,p_effective_date in date
2120: ,p_validate in boolean default false) is
2121: --
2122: l_effective_date ben_per_in_ler.lf_evt_ocrd_dt%type;
2123: l_update boolean := false;
2124: l_cbr_elig_perd_strt_dt ben_cbr_quald_bnf.cbr_elig_perd_strt_dt%type;
2125: l_cqb_object_version_number ben_cbr_quald_bnf.object_version_number%type;
2126: l_crp_object_version_number ben_cbr_quald_bnf.object_version_number%type;

Line 2141: ,ben_per_in_ler pil

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
2145: and cqb.cbr_quald_bnf_id = crp.cbr_quald_bnf_id

Line 2335: l_effective_date ben_per_in_ler.lf_evt_ocrd_dt%type;

2331: ,p_ptip_id in number default null
2332: ,p_pl_typ_id in number default null
2333: ,p_validate in boolean default false) is
2334: --
2335: l_effective_date ben_per_in_ler.lf_evt_ocrd_dt%type;
2336: l_proc varchar2(80) := g_package||'.update_cobra_info';
2337: l_exists varchar2(1);
2338: l_init_evt boolean := false;
2339: l_cvrd_emp_person_id ben_cbr_quald_bnf.cvrd_emp_person_id%type;

Line 2381: ,ben_per_in_ler pil

2377: --
2378: cursor c_get_qualg_evt is
2379: select null
2380: from ben_ler_f ler
2381: ,ben_per_in_ler pil
2382: where ler.ler_id = pil.ler_id
2383: and pil.per_in_ler_id = p_per_in_ler_id
2384: and p_effective_date between
2385: ler.effective_start_date and ler.effective_end_date

Line 2398: ,ben_per_in_ler pil

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
2401: and crp2.per_in_ler_id = pil.per_in_ler_id
2402: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')

Line 2413: ,ben_per_in_ler pil

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
2417: and crp.business_group_id = pil.business_group_id

Line 2424: ,ben_per_in_ler pil

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'
2428: and cqb.cbr_elig_perd_end_dt >= p_lf_evt_ocrd_dt

Line 2453: ,ben_per_in_ler pil

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)
2457: and nvl(cqb.ptip_id,-1) = nvl(p_ptip_id, -1)

Line 2787: l_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type;

2783: ,p_effective_date in date
2784: ,p_validate in boolean default false) is
2785: --
2786: l_update boolean := false;
2787: l_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type;
2788: l_typ_cd ben_ler_f.typ_cd%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;

Line 2806: ,ben_per_in_ler pil

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
2810: and crp.cbr_quald_bnf_id = cqb.cbr_quald_bnf_id

Line 2821: ,ben_per_in_ler pil

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
2825: and crp.business_group_id = pil.business_group_id

Line 2831: ,ben_per_in_ler pil

2827: --
2828: cursor c_get_ler_type is
2829: select ler.typ_cd
2830: from ben_ler_f ler
2831: ,ben_per_in_ler pil
2832: where ler.ler_id = pil.ler_id
2833: and pil.per_in_ler_id = p_per_in_ler_id
2834: and ler.business_group_id = p_business_group_id
2835: and ler.business_group_id = pil.business_group_id

Line 2986: l_effective_date ben_per_in_ler.lf_evt_ocrd_dt%type;

2982: ,p_business_group_id in number
2983: ,p_effective_date in date
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;

Line 2997: ,ben_per_in_ler pil

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
3001: and crp.business_group_id = pil.business_group_id