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_LF_EVT_CLPS_RESTORE dependencies on BEN_LER_F

Line 45: ler_id ben_ler_f.ler_id%type,

41: new_oipl_id ben_prtt_enrt_rslt_f.oipl_id%type,
42: old_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%type,
43: new_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%type,
44: pgm_id ben_prtt_enrt_rslt_f.pgm_id%type,
45: ler_id ben_ler_f.ler_id%type,
46: elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%type,
47: dpnt_cvg_strt_dt_cd ben_elig_per_elctbl_chc.dpnt_cvg_strt_dt_cd%type,
48: dpnt_cvg_strt_dt_rl ben_elig_per_elctbl_chc.dpnt_cvg_strt_dt_rl%type,
49: effective_start_date ben_prtt_enrt_rslt_f.effective_start_date%type,

Line 656: ,ben_ler_f ler

652: ler.name,
653: pil.bckt_per_in_ler_id,
654: ler_cs_bckdt.name ler_cs_bckdt_name
655: from ben_per_in_ler pil
656: ,ben_ler_f ler
657: ,ben_per_in_ler pil_cs_bckdt
658: ,ben_ler_f ler_cs_bckdt
659: ,ben_ptnl_ler_for_per plr
660: where pil.person_id = p_person_id

Line 658: ,ben_ler_f ler_cs_bckdt

654: ler_cs_bckdt.name ler_cs_bckdt_name
655: from ben_per_in_ler pil
656: ,ben_ler_f ler
657: ,ben_per_in_ler pil_cs_bckdt
658: ,ben_ler_f ler_cs_bckdt
659: ,ben_ptnl_ler_for_per plr
660: where pil.person_id = p_person_id
661: and pil.business_group_id = p_business_group_id
662: and pil.ler_id = p_ler_id

Line 930: ben_ler_f ler

926: --
927: cursor c_inter_pil_cnt(cv_bckt_csd_lf_evt_ocrd_dt date) is
928: select pil.per_in_ler_id, pil.object_version_number
929: from ben_per_in_ler pil,
930: ben_ler_f ler
931: where pil.per_in_ler_id <> p_per_in_ler_id
932: and pil.per_in_ler_id <> p_bckdt_per_in_ler_id
933: and pil.person_id = p_person_id
934: and pil.ler_id = ler.ler_id

Line 1010: ben_ler_f ler

1006:
1007: cursor c_ele_md_for_inter_pil is
1008: select 'Y'
1009: from ben_prtt_enrt_rslt_f pen,
1010: ben_ler_f ler
1011: where pen.per_in_ler_id not in (p_per_in_ler_id,p_bckdt_per_in_ler_id)
1012: /* Bug 8305552: Added 'not in (p_per_in_ler_id)'. Do not check elections for the current LifeEvent,because for Automatic enrollments
1013: record will be present during validation of the cursor*/
1014: and pen.person_id = p_person_id

Line 1039: ben_ler_f ler

1035:
1036: cursor c_prev_pil(p_bckt_csd_lf_evt_ocrd_dt date,p_bckt_csd_per_in_ler_id number ) is
1037: select pil.per_in_ler_id
1038: from ben_per_in_ler pil,
1039: ben_ler_f ler
1040: where pil.per_in_ler_id not in (p_per_in_ler_id,p_bckt_csd_per_in_ler_id)
1041: and pil.person_id = p_person_id
1042: and pil.ler_id = ler.ler_id
1043: and p_effective_date between

Line 1070: ben_ler_f ler

1066: /*Cursor to get the latest Intervening per_in_ler_id that has been processed*/
1067: cursor c_prev_pil1 is
1068: select pil.per_in_ler_id
1069: from ben_per_in_ler pil,
1070: ben_ler_f ler
1071: where pil.per_in_ler_id not in (p_per_in_ler_id,p_bckdt_per_in_ler_id)
1072: and pil.person_id = p_person_id
1073: and pil.ler_id = ler.ler_id
1074: and p_effective_date between

Line 1080: ben_ler_f ler1

1076: and ler.typ_cd not in ('IREC', 'SCHEDDU', 'COMP', 'GSP', 'ABS')
1077: and pil.per_in_ler_stat_cd not in('BCKDT', 'VOIDD')
1078: and pil.lf_evt_ocrd_dt in (select lf_evt_ocrd_dt
1079: from ben_per_in_ler pil2,
1080: ben_ler_f ler1
1081: where pil2.per_in_ler_stat_cd not in ('BCKDT', 'VOIDD')
1082: and pil2.person_id = p_person_id
1083: and pil2.ler_id = ler1.ler_id
1084: and p_effective_date between

Line 3780: ben_ler_f ler

3776: --
3777: cursor c_inter_pil_cnt(cv_bckt_csd_lf_evt_ocrd_dt date) is
3778: select pil.per_in_ler_id, pil.object_version_number
3779: from ben_per_in_ler pil,
3780: ben_ler_f ler
3781: where pil.per_in_ler_id <> p_per_in_ler_id
3782: and pil.per_in_ler_id <> p_bckdt_per_in_ler_id
3783: and pil.person_id = p_person_id
3784: and pil.ler_id = ler.ler_id

Line 6374: ler_id ben_ler_f.ler_id%type,

6370: new_oipl_id ben_prtt_enrt_rslt_f.oipl_id%type,
6371: old_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%type,
6372: new_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%type,
6373: pgm_id ben_prtt_enrt_rslt_f.pgm_id%type,
6374: ler_id ben_ler_f.ler_id%type,
6375: elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%type,
6376: dpnt_cvg_strt_dt_cd ben_elig_per_elctbl_chc.dpnt_cvg_strt_dt_cd%type,
6377: dpnt_cvg_strt_dt_rl ben_elig_per_elctbl_chc.dpnt_cvg_strt_dt_rl%type,
6378: effective_start_date ben_prtt_enrt_rslt_f.effective_start_date%type

Line 8253: ben_ler_f ler

8249:
8250: cursor c_prev_pil is
8251: select pil.per_in_ler_id
8252: from ben_per_in_ler pil,
8253: ben_ler_f ler
8254: where pil.per_in_ler_id not in (p_per_in_ler_id)
8255: and pil.person_id = p_person_id
8256: and pil.ler_id = ler.ler_id
8257: and p_effective_date between

Line 8263: ben_ler_f ler1

8259: and ler.typ_cd not in ('IREC', 'SCHEDDU', 'COMP', 'GSP', 'ABS')
8260: and pil.per_in_ler_stat_cd not in('BCKDT', 'VOIDD')
8261: and pil.lf_evt_ocrd_dt in (select max(lf_evt_ocrd_dt)
8262: from ben_per_in_ler pil2,
8263: ben_ler_f ler1
8264: where pil2.per_in_ler_stat_cd not in ('BCKDT', 'VOIDD')
8265: and pil2.person_id = p_person_id
8266: and pil2.ler_id = ler1.ler_id
8267: and p_effective_date between

Line 9948: ben_ler_f ler

9944: --
9945: cursor c_bckdt_pil is
9946: select ler.name, pil.PRVS_STAT_CD, pil.object_version_number, pil.BCKT_PER_IN_LER_ID
9947: from ben_per_in_ler pil,
9948: ben_ler_f ler
9949: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
9950: and ler.ler_id = pil.ler_id
9951: and p_effective_date between ler.effective_start_date
9952: and ler.effective_end_date ;

Line 9981: ben_ler_f ler

9977:
9978: cursor c_chk_exp_inter_pil is
9979: select 'Y'
9980: from ben_prtt_enrt_rslt_f pen,
9981: ben_ler_f ler
9982: where pen.per_in_ler_id not in (p_per_in_ler_id,p_bckdt_per_in_ler_id)
9983: and pen.person_id = p_person_id
9984: and pen.prtt_enrt_rslt_stat_cd is null
9985: and pen.enrt_cvg_thru_dt = hr_api.g_eot

Line 10022: ben_ler_f ler

10018:
10019: cursor c_future_pil is
10020: select pil.per_in_ler_id
10021: from ben_per_in_ler pil,
10022: ben_ler_f ler
10023: where pil.per_in_ler_id not in (p_per_in_ler_id,p_bckdt_per_in_ler_id)
10024: and pil.person_id = p_person_id
10025: and pil.ler_id = ler.ler_id
10026: and p_effective_date between

Line 10032: ben_ler_f ler1

10028: and ler.typ_cd not in ('IREC', 'SCHEDDU', 'COMP', 'GSP', 'ABS')
10029: and pil.per_in_ler_stat_cd not in('BCKDT', 'VOIDD')
10030: and pil.lf_evt_ocrd_dt in (select lf_evt_ocrd_dt
10031: from ben_per_in_ler pil2,
10032: ben_ler_f ler1
10033: where pil2.per_in_ler_stat_cd not in ('BCKDT', 'VOIDD')
10034: and pil2.person_id = p_person_id
10035: and pil2.ler_id = ler1.ler_id
10036: and p_effective_date between

Line 10048: from ben_ler_f le,ben_per_in_ler pil

10044: order by pil.lf_evt_ocrd_dt desc;
10045:
10046: cursor c_ler_id is
10047: select le.ler_id
10048: from ben_ler_f le,ben_per_in_ler pil
10049: where pil.ler_id=le.ler_id
10050: and p_effective_date between le.effective_start_date and le.effective_end_date
10051: and pil.per_in_ler_id = p_bckdt_per_in_ler_id;
10052:

Line 10148: from ben_ler_f ler, ben_per_in_ler pil

10144:
10145: cursor c_unres_per_in_ler
10146: is
10147: select 'x'
10148: from ben_ler_f ler, ben_per_in_ler pil
10149: where ler.ler_id = pil.ler_id
10150: and ler.business_group_id = pil.business_group_id
10151: and pil.per_in_ler_id = p_per_in_ler_id
10152: and pil.business_group_id = p_business_group_id

Line 11690: ler_id ben_ler_f.ler_id%type,

11686: new_oipl_id ben_prtt_enrt_rslt_f.oipl_id%type,
11687: old_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%type,
11688: new_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%type,
11689: pgm_id ben_prtt_enrt_rslt_f.pgm_id%type,
11690: ler_id ben_ler_f.ler_id%type,
11691: elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%type,
11692: dpnt_cvg_strt_dt_cd ben_elig_per_elctbl_chc.dpnt_cvg_strt_dt_cd%type,
11693: dpnt_cvg_strt_dt_rl ben_elig_per_elctbl_chc.dpnt_cvg_strt_dt_rl%type,
11694: effective_start_date ben_prtt_enrt_rslt_f.effective_start_date%type

Line 12906: ben_ler_f ler

12902:
12903: cursor c_future_pil is
12904: select pil.per_in_ler_id
12905: from ben_per_in_ler pil,
12906: ben_ler_f ler
12907: where pil.per_in_ler_id not in (p_per_in_ler_id,p_bckdt_per_in_ler_id)
12908: and pil.person_id = p_person_id
12909: and pil.ler_id = ler.ler_id
12910: and p_effective_date between

Line 12916: ben_ler_f ler1

12912: and ler.typ_cd not in ('IREC', 'SCHEDDU', 'COMP', 'GSP', 'ABS')
12913: and pil.per_in_ler_stat_cd not in('BCKDT', 'VOIDD')
12914: and pil.lf_evt_ocrd_dt in (select lf_evt_ocrd_dt
12915: from ben_per_in_ler pil2,
12916: ben_ler_f ler1
12917: where pil2.per_in_ler_stat_cd not in ('BCKDT', 'VOIDD')
12918: and pil2.person_id = p_person_id
12919: and pil2.ler_id = ler1.ler_id
12920: and p_effective_date between