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_ELIG_PER_ELCTBL_CHC

Line 46: elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_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,
50: reinstate_flag varchar2(1) DEFAULT 'N',

Line 47: dpnt_cvg_strt_dt_cd ben_elig_per_elctbl_chc.dpnt_cvg_strt_dt_cd%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,
50: reinstate_flag varchar2(1) DEFAULT 'N',
51: enrt_mthd_cd varchar2(1) -- Bug 9045559

Line 48: dpnt_cvg_strt_dt_rl ben_elig_per_elctbl_chc.dpnt_cvg_strt_dt_rl%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,
50: reinstate_flag varchar2(1) DEFAULT 'N',
51: enrt_mthd_cd varchar2(1) -- Bug 9045559
52: );

Line 497: FROM ben_elig_per_elctbl_chc epe

493: ,c_oipl_id number
494: )
495: is
496: SELECT epe.elig_per_elctbl_chc_id
497: FROM ben_elig_per_elctbl_chc epe
498: WHERE epe.oipl_id = c_oipl_id
499: AND epe.pgm_id = c_pgm_id
500: AND epe.per_in_ler_id = c_per_in_ler_id;
501: --

Line 508: FROM ben_elig_per_elctbl_chc epe

504: ,c_oipl_id number
505: )
506: is
507: SELECT epe.elig_per_elctbl_chc_id
508: FROM ben_elig_per_elctbl_chc epe
509: WHERE epe.oipl_id = c_oipl_id
510: AND epe.pgm_id IS NULL
511: AND epe.per_in_ler_id = c_per_in_ler_id;
512: --

Line 520: FROM ben_elig_per_elctbl_chc epe

516: ,c_pl_id number
517: )
518: is
519: SELECT epe.elig_per_elctbl_chc_id
520: FROM ben_elig_per_elctbl_chc epe
521: WHERE epe.pl_id = c_pl_id
522: AND epe.oipl_id IS NULL
523: AND epe.pgm_id = c_pgm_id
524: AND epe.per_in_ler_id = c_per_in_ler_id;

Line 532: FROM ben_elig_per_elctbl_chc epe

528: ,c_pl_id number
529: )
530: is
531: SELECT epe.elig_per_elctbl_chc_id
532: FROM ben_elig_per_elctbl_chc epe
533: WHERE epe.pl_id = c_pl_id
534: AND epe.oipl_id IS NULL
535: AND epe.pgm_id IS NULL
536: AND epe.per_in_ler_id = c_per_in_ler_id;

Line 2102: -- ben_elig_per_elctbl_chc -- 9999 done

2098: -- find any differences exists between the two runs of same ler.
2099: --
2100: -- ben_elig_cvrd_dpnt_f
2101: -- ben_prtt_enrt_actn_f
2102: -- ben_elig_per_elctbl_chc -- 9999 done
2103: -- ben_enrt_bnft
2104: -- ben_enrt_rt
2105: -- ben_elctbl_chc_ctfn
2106: --

Line 2109: from ben_elig_per_elctbl_chc epe,

2105: -- ben_elctbl_chc_ctfn
2106: --
2107: cursor c_bckdt_epe_cnt is
2108: select count(*)
2109: from ben_elig_per_elctbl_chc epe,
2110: ben_per_in_ler pil
2111: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
2112: and pil.person_id = p_person_id
2113: and pil.business_group_id = p_business_group_id

Line 2119: from ben_elig_per_elctbl_chc epe,

2115: -- and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');
2116: --
2117: cursor c_curr_epe_cnt is
2118: select count(*)
2119: from ben_elig_per_elctbl_chc epe,
2120: ben_per_in_ler pil
2121: where pil.per_in_ler_id = p_per_in_ler_id
2122: and pil.person_id = p_person_id
2123: and pil.business_group_id = p_business_group_id

Line 2139: from ben_elig_per_elctbl_chc epe,

2135: l_diff_auto_flag boolean := true ;
2136: --
2137: cursor c_bckdt_epe_dat is
2138: select epe.*
2139: from ben_elig_per_elctbl_chc epe,
2140: ben_per_in_ler pil
2141: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
2142: and pil.person_id = p_person_id
2143: and pil.business_group_id = p_business_group_id

Line 2149: from ben_elig_per_elctbl_chc epe,

2145: -- and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');
2146: --
2147: cursor c_curr_epe_dat is
2148: select epe.*
2149: from ben_elig_per_elctbl_chc epe,
2150: ben_per_in_ler pil
2151: where pil.per_in_ler_id = p_per_in_ler_id
2152: and pil.person_id = p_person_id
2153: and pil.business_group_id = p_business_group_id

Line 2488: -- ben_elig_per_elctbl_chc

2484: -- find any differences exists between the two runs of same ler.
2485: --
2486: -- ben_elig_cvrd_dpnt_f
2487: -- ben_prtt_enrt_actn_f
2488: -- ben_elig_per_elctbl_chc
2489: -- ben_enrt_bnft
2490: -- ben_enrt_rt
2491: -- ben_elctbl_chc_ctfn
2492: --

Line 2495: from ben_elig_per_elctbl_chc epe,

2491: -- ben_elctbl_chc_ctfn
2492: --
2493: cursor c_bckdt_epe_cnt is
2494: select count(*)
2495: from ben_elig_per_elctbl_chc epe,
2496: ben_pil_elctbl_chc_popl pel,
2497: ben_per_in_ler pil
2498: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
2499: and pil.person_id = p_person_id

Line 2509: from ben_elig_per_elctbl_chc epe,

2505: and pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id;
2506: --
2507: cursor c_curr_epe_cnt is
2508: select count(*)
2509: from ben_elig_per_elctbl_chc epe,
2510: ben_pil_elctbl_chc_popl pel,
2511: ben_per_in_ler pil
2512: where pil.per_in_ler_id = p_per_in_ler_id
2513: and pil.person_id = p_person_id

Line 2532: from ben_elig_per_elctbl_chc epe,

2528: l_diff_auto_flag boolean := true ;
2529: --
2530: cursor c_bckdt_epe_dat is
2531: select epe.*
2532: from ben_elig_per_elctbl_chc epe,
2533: ben_pil_elctbl_chc_popl pel,
2534: ben_per_in_ler pil
2535: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
2536: and pil.person_id = p_person_id

Line 2546: from ben_elig_per_elctbl_chc epe,

2542: and pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id ;
2543: --
2544: cursor c_curr_epe_dat is
2545: select epe.*
2546: from ben_elig_per_elctbl_chc epe,
2547: ben_pil_elctbl_chc_popl pel,
2548: ben_per_in_ler pil
2549: where pil.per_in_ler_id = p_per_in_ler_id
2550: and pil.person_id = p_person_id

Line 6271: from ben_elig_per_elctbl_chc epe,

6267: pel.enrt_perd_end_dt,
6268: pel.enrt_perd_strt_dt,
6269: to_date('31-12-4712','DD-MM-YYYY') enrt_cvg_end_dt,
6270: pel.dflt_enrt_dt
6271: from ben_elig_per_elctbl_chc epe,
6272: ben_per_in_ler pil,
6273: ben_pil_elctbl_chc_popl pel
6274: where epe.per_in_ler_id = p_per_in_ler_id
6275: and epe.business_group_id = p_business_group_id

Line 6375: elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_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
6379: );

Line 6376: dpnt_cvg_strt_dt_cd ben_elig_per_elctbl_chc.dpnt_cvg_strt_dt_cd%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
6379: );
6380: --

Line 6377: dpnt_cvg_strt_dt_rl ben_elig_per_elctbl_chc.dpnt_cvg_strt_dt_rl%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
6379: );
6380: --
6381: type t_pgm_table is table of pgm_rec index by binary_integer;

Line 8214: select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc epe,

8210:
8211: /* Bug 9307262:Moved the fix done for Bug 7426609 from procedure 'reinstate_the_prev_enrt' to 'reinstate_prev_enrt_for_popl'*/
8212: /*Added for Bug 7426609*/
8213: cursor c_get_epe_id(c_prtt_enrt_rslt_id number,c_per_in_ler_id number) is
8214: select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc epe,
8215: ben_prtt_enrt_rslt_f pen
8216: where pen.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
8217: and pen.per_in_ler_id = c_per_in_ler_id
8218: and epe.per_in_ler_id=pen.per_in_ler_id

Line 8240: from ben_elig_per_elctbl_chc oldchc,

8236: l_sus_bnft_amt c_interim_bnft%rowtype;
8237:
8238: cursor c_get_new_epe_id( c_elig_per_elctbl_chc_id number) is
8239: select newchc.elig_per_elctbl_chc_id
8240: from ben_elig_per_elctbl_chc oldchc,
8241: ben_elig_per_elctbl_chc newchc
8242: where oldchc.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
8243: and newchc.per_in_ler_id = p_per_in_ler_id
8244: and newchc.pl_id = oldchc.pl_id

Line 8241: ben_elig_per_elctbl_chc newchc

8237:
8238: cursor c_get_new_epe_id( c_elig_per_elctbl_chc_id number) is
8239: select newchc.elig_per_elctbl_chc_id
8240: from ben_elig_per_elctbl_chc oldchc,
8241: ben_elig_per_elctbl_chc newchc
8242: where oldchc.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
8243: and newchc.per_in_ler_id = p_per_in_ler_id
8244: and newchc.pl_id = oldchc.pl_id
8245: and nvl(oldchc.pgm_id,-1) = nvl(newchc.pgm_id,-1)

Line 8276: from ben_elig_per_elctbl_chc prevepe,

8272: );
8273:
8274: cursor c_prev_pil_epe_id( c_elig_per_elctbl_chc_id number,c_per_in_ler_id number) is
8275: select prevepe.elig_per_elctbl_chc_id
8276: from ben_elig_per_elctbl_chc prevepe,
8277: ben_elig_per_elctbl_chc newepe,
8278: ben_prtt_enrt_rslt_f prevpen
8279: where newepe.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
8280: and prevepe.per_in_ler_id = c_per_in_ler_id

Line 8277: ben_elig_per_elctbl_chc newepe,

8273:
8274: cursor c_prev_pil_epe_id( c_elig_per_elctbl_chc_id number,c_per_in_ler_id number) is
8275: select prevepe.elig_per_elctbl_chc_id
8276: from ben_elig_per_elctbl_chc prevepe,
8277: ben_elig_per_elctbl_chc newepe,
8278: ben_prtt_enrt_rslt_f prevpen
8279: where newepe.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
8280: and prevepe.per_in_ler_id = c_per_in_ler_id
8281: and newepe.pl_id = prevepe.pl_id

Line 8308: ben_elig_per_elctbl_chc epe,

8304: pen.prtt_enrt_rslt_id,
8305: pen.bnft_amt,
8306: epe.object_version_number
8307: from
8308: ben_elig_per_elctbl_chc epe,
8309: ben_prtt_enrt_rslt_f pen,
8310: ben_enrt_bnft bnft
8311: where pen.per_in_ler_id = c_prev_pil_id
8312: and pen.pl_id = epe.pl_id

Line 9537: from ben_elig_per_elctbl_chc epe

9533: and bpp.effective_end_date ;
9534: --
9535: cursor c_flex_epe(c_per_in_ler_id number,c_pgm_id number, c_pl_id number) is
9536: select elig_per_elctbl_chc_id
9537: from ben_elig_per_elctbl_chc epe
9538: where epe.per_in_ler_id = c_per_in_ler_id
9539: and epe.pl_id = c_pl_id
9540: and epe.pgm_id = c_pgm_id ;
9541: --

Line 10001: (select 'Y' from ben_elig_per_elctbl_chc epe1

9997: (select '1' from ben_prtt_enrt_rslt_f pen1
9998: where pen1.RPLCS_SSPNDD_RSLT_ID = pen.prtt_enrt_rslt_id
9999: and pen1.per_in_ler_id = pen.per_in_ler_id)
10000: and exists
10001: (select 'Y' from ben_elig_per_elctbl_chc epe1
10002: where epe1.elctbl_flag = 'Y'
10003: and epe1.per_in_ler_id = l_prev_pil_id)
10004: and rownum = 1 ;
10005:

Line 11583: from ben_elig_per_elctbl_chc epe,

11579: pel.enrt_perd_end_dt,
11580: pel.enrt_perd_strt_dt,
11581: to_date('31-12-4712','DD-MM-YYYY') enrt_cvg_end_dt,
11582: pel.dflt_enrt_dt
11583: from ben_elig_per_elctbl_chc epe,
11584: ben_per_in_ler pil,
11585: ben_pil_elctbl_chc_popl pel
11586: where epe.per_in_ler_id = cp_per_in_ler_id
11587: and epe.business_group_id = p_business_group_id

Line 11691: elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_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
11695: );

Line 11692: dpnt_cvg_strt_dt_cd ben_elig_per_elctbl_chc.dpnt_cvg_strt_dt_cd%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
11695: );
11696: --

Line 11693: dpnt_cvg_strt_dt_rl ben_elig_per_elctbl_chc.dpnt_cvg_strt_dt_rl%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
11695: );
11696: --
11697: --

Line 11810: select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc epe,

11806: and pen.effective_end_date = hr_api.g_eot;
11807:
11808: /* Bug 8863079: Added cursor c_get_epe_id to determine the interim epe record */
11809: cursor c_get_epe_id(c_prtt_enrt_rslt_id number,c_per_in_ler_id number) is
11810: select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc epe,
11811: ben_prtt_enrt_rslt_f pen
11812: where pen.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
11813: and epe.per_in_ler_id = c_per_in_ler_id
11814: and epe.pl_id = pen.pl_id

Line 12848: ben_elig_per_elctbl_chc

12844: l_proc varchar2(72) := g_package||'.check_pl_typ_defaulted';
12845: l_flag varchar2(1) := 'N';
12846: cursor c_epe_det(c_elig_per_elctbl_chc_id number) is
12847: select pgm_id,pl_typ_id from
12848: ben_elig_per_elctbl_chc
12849: where elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id;
12850: l_epe_rec c_epe_det%rowtype;
12851: begin
12852: hr_utility.set_location ('Entering '||l_proc,10);