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_LE_CLSN_N_RSTR

Line 186: from ben_le_clsn_n_rstr pen_inner,

182: )
183: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
184: union
185: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)
186: from ben_le_clsn_n_rstr pen_inner,
187: ben_per_in_ler pil_inner
188: where pil_inner.per_in_ler_id = c_bckdt_per_in_ler_id
189: and pil_inner.person_id = c_person_id
190: AND pil_inner.per_in_ler_id = pen_inner.per_in_ler_id

Line 276: from ben_le_clsn_n_rstr pen,

272: pen.REQUEST_ID,
273: pen.RPLCS_SSPNDD_RSLT_ID,
274: pen.SSPNDD_FLAG,
275: pen.UOM
276: from ben_le_clsn_n_rstr pen,
277: ben_per_in_ler pil,
278: ben_pil_elctbl_chc_popl pel --Added for Bug 4423161
279: where pil.per_in_ler_id = c_bckdt_per_in_ler_id
280: and pil.person_id = c_person_id

Line 314: from ben_le_clsn_n_rstr pen_inner,

310: )
311: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
312: union
313: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)
314: from ben_le_clsn_n_rstr pen_inner,
315: ben_per_in_ler pil_inner
316: where pil_inner.per_in_ler_id = c_bckdt_per_in_ler_id
317: and pil_inner.person_id = c_person_id
318: AND pil_inner.per_in_ler_id = pen_inner.per_in_ler_id

Line 395: from ben_le_clsn_n_rstr pen_inner,

391: )
392: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
393: union
394: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)
395: from ben_le_clsn_n_rstr pen_inner,
396: ben_per_in_ler pil_inner
397: where pil_inner.per_in_ler_id = c_bckdt_per_in_ler_id
398: and pil_inner.person_id = c_person_id
399: AND pil_inner.per_in_ler_id = pen_inner.per_in_ler_id

Line 426: from ben_le_clsn_n_rstr pen,

422: pen.PRTT_ENRT_RSLT_STAT_CD,
423: pen.PTIP_ID,
424: pen.RPLCS_SSPNDD_RSLT_ID,
425: pen.SSPNDD_FLAG
426: from ben_le_clsn_n_rstr pen,
427: ben_per_in_ler pil,
428: ben_pil_elctbl_chc_popl pel --Added for Bug 4423161
429: where pil.per_in_ler_id = c_bckdt_per_in_ler_id
430: and pil.person_id = c_person_id

Line 461: from ben_le_clsn_n_rstr pen_inner,

457: )
458: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
459: union
460: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)
461: from ben_le_clsn_n_rstr pen_inner,
462: ben_per_in_ler pil_inner
463: where pil_inner.per_in_ler_id = c_bckdt_per_in_ler_id
464: and pil_inner.person_id = c_person_id
465: AND pil_inner.per_in_ler_id = pen_inner.per_in_ler_id

Line 743: from ben_le_clsn_n_rstr lcr

739: and pen.effective_end_date
740: /* 9999 complete this part from the backup table */
741: union
742: select 'Y'
743: from ben_le_clsn_n_rstr lcr
744: where lcr.per_in_ler_id = p_bckdt_per_in_ler_id
745: and lcr.business_group_id = p_business_group_id
746: and p_effective_date between lcr.effective_start_date
747: and lcr.effective_end_date;

Line 3000: from ben_le_clsn_n_rstr cqb

2996: and crp.business_group_id = p_business_group_id;
2997: --
2998: cursor c_bckdt_cqb is
2999: select cqb.*
3000: from ben_le_clsn_n_rstr cqb
3001: where cqb.per_in_ler_id = p_bckdt_per_in_ler_id
3002: and cqb.business_group_id = p_business_group_id
3003: and cqb.bkup_tbl_typ_cd = 'BEN_CBR_QUALD_BNF';
3004: --

Line 3058: delete from ben_le_clsn_n_rstr cqb

3054: --
3055: -- Delete all the backup rows from the backup table after the
3056: -- restoration of rows.
3057: --
3058: delete from ben_le_clsn_n_rstr cqb
3059: where cqb.per_in_ler_id = p_bckdt_per_in_ler_id
3060: and cqb.business_group_id = p_business_group_id
3061: and cqb.bkup_tbl_typ_cd = 'BEN_CBR_QUALD_BNF';
3062: --

Line 3430: from ben_le_clsn_n_rstr pen,

3426: pen.REQUEST_ID,
3427: pen.RPLCS_SSPNDD_RSLT_ID,
3428: pen.SSPNDD_FLAG,
3429: pen.UOM
3430: from ben_le_clsn_n_rstr pen,
3431: ben_per_in_ler pil
3432: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
3433: and pil.person_id = p_person_id
3434: and pil.business_group_id = p_business_group_id

Line 3480: from ben_le_clsn_n_rstr pen,

3476: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
3477: AND pil.per_in_ler_id = pen.per_in_ler_id;
3478: --
3479: select count(*) into l_bckdt_pen_cnt
3480: from ben_le_clsn_n_rstr pen,
3481: ben_per_in_ler pil
3482: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
3483: and pil.person_id = p_person_id
3484: and pil.business_group_id = p_business_group_id

Line 3866: from ben_le_clsn_n_rstr pen,

3862: pen.PGM_ID,
3863: pen.PL_ID,
3864: pen.PL_TYP_ID,
3865: pen.PTIP_ID
3866: from ben_le_clsn_n_rstr pen,
3867: ben_per_in_ler pil
3868: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
3869: and pil.person_id = p_person_id
3870: and pil.business_group_id = p_business_group_id

Line 4009: from ben_le_clsn_n_rstr bckdt_bpl

4005: ,bckdt_bpl.CREATION_DATE
4006: ,bckdt_bpl.OBJECT_VERSION_NUMBER
4007: ,bckdt_bpl.VAL -- Used for RLD_UP_VAL
4008: ,bckdt_bpl.PER_IN_LER_ID
4009: from ben_le_clsn_n_rstr bckdt_bpl
4010: where bckdt_bpl.per_in_ler_id = p_bckdt_per_in_ler_id
4011: and bckdt_bpl.business_group_id = p_business_group_id
4012: and bckdt_bpl.prtt_enrt_rslt_id = cp_bckdt_prtt_enrt_rslt_id
4013: and bckdt_bpl.BKUP_TBL_TYP_CD = 'BEN_BNFT_PRVDD_LDGR_F'

Line 4576: from ben_le_clsn_n_rstr pea

4572: -- and pea.ELIG_CVRD_DPNT_ID is null
4573: union
4574: select pea.OVRDN_THRU_DT, -- used as pea.CMPLTD_DT
4575: pea.PL_TYP_ID -- used as ACTN_TYP_ID
4576: from ben_le_clsn_n_rstr pea
4577: where pea.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
4578: and pea.business_group_id = p_business_group_id
4579: and pea.per_in_ler_id = p_bckdt_per_in_ler_id
4580: and p_effective_date between pea.effective_start_date

Line 4961: from ben_le_clsn_n_rstr pdp_old

4957: pdp_old.PROGRAM_UPDATE_DATE,
4958: pdp_old.OBJECT_VERSION_NUMBER,
4959: pdp_old.BKUP_TBL_ID,
4960: pdp_old.EFFECTIVE_START_DATE
4961: from ben_le_clsn_n_rstr pdp_old
4962: where pdp_old.per_in_ler_id = p_bckdt_per_in_ler_id
4963: and pdp_old.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
4964: and pdp_old.business_group_id = p_business_group_id
4965: and pdp_old.bkup_tbl_typ_cd = 'BEN_ELIG_CVRD_DPNT_F'

Line 4989: select '1' from ben_le_clsn_n_rstr

4985: and effective_end_date = hr_api.g_eot
4986: and cvg_thru_dt = hr_api.g_eot
4987: and per_in_ler_id = p_bckdt_per_in_ler_id
4988: union
4989: select '1' from ben_le_clsn_n_rstr
4990: where BKUP_TBL_ID = p_elig_cvrd_dpnt_id
4991: and prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
4992: and effective_end_date = hr_api.g_eot
4993: and cvg_thru_dt = hr_api.g_eot

Line 4999: from ben_le_clsn_n_rstr pdp_old

4995: and bkup_tbl_typ_cd = 'BEN_ELIG_CVRD_DPNT_F'
4996: )
4997: union
4998: select 'Y'
4999: from ben_le_clsn_n_rstr pdp_old
5000: where pdp_old.bkup_tbl_id = p_elig_cvrd_dpnt_id
5001: and pdp_old.bkup_tbl_typ_cd = 'BEN_ELIG_CVRD_DPNT_F'
5002: and pdp_old.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
5003: and ((pdp_old.cvg_thru_dt is null or pdp_old.cvg_thru_dt = hr_api.g_eot) and

Line 5528: (select 'Y' from ben_le_clsn_n_rstr pbn1

5524: pbn.PER_IN_LER_ID,
5525: pbn.LCR_ATTRIBUTE_CATEGORY,
5526: /* Bug 12964358: Check whether there are date track updated records after the effective_start_date*/
5527: decode( (select 'Y' from dual where exists
5528: (select 'Y' from ben_le_clsn_n_rstr pbn1
5529: where pbn1.per_in_ler_id = pbn.per_in_ler_id
5530: and pbn1.prtt_enrt_rslt_id = pbn.prtt_enrt_rslt_id
5531: and pbn1.business_group_id = pbn.business_group_id
5532: and pbn1.effective_start_date > pbn.effective_start_date

Line 5535: from ben_le_clsn_n_rstr pbn

5531: and pbn1.business_group_id = pbn.business_group_id
5532: and pbn1.effective_start_date > pbn.effective_start_date
5533: and pbn1.BKUP_TBL_ID = pbn.BKUP_TBL_ID)),
5534: 'Y','Y','N') ftr_rec
5535: from ben_le_clsn_n_rstr pbn
5536: where pbn.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
5537: and pbn.business_group_id = p_business_group_id
5538: and pbn.per_in_ler_id = p_bckdt_per_in_ler_id
5539: and p_effective_date between pbn.effective_start_date

Line 6128: from ben_le_clsn_n_rstr pen_inner,

6124: )
6125: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
6126: union
6127: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)
6128: from ben_le_clsn_n_rstr pen_inner,
6129: ben_per_in_ler pil_inner
6130: where pil_inner.per_in_ler_id = p_bckdt_per_in_ler_id
6131: and pil_inner.person_id = p_person_id
6132: and pil_inner.business_group_id = p_business_group_id

Line 6219: from ben_le_clsn_n_rstr pen,

6215: pen.REQUEST_ID,
6216: pen.RPLCS_SSPNDD_RSLT_ID,
6217: pen.SSPNDD_FLAG,
6218: pen.UOM
6219: from ben_le_clsn_n_rstr pen,
6220: ben_per_in_ler pil
6221: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
6222: and pil.person_id = p_person_id
6223: and pil.business_group_id = p_business_group_id

Line 6246: from ben_le_clsn_n_rstr pen_inner,

6242: )
6243: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
6244: union
6245: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)
6246: from ben_le_clsn_n_rstr pen_inner,
6247: ben_per_in_ler pil_inner
6248: where pil_inner.per_in_ler_id = p_bckdt_per_in_ler_id
6249: and pil_inner.person_id = p_person_id
6250: and pil_inner.business_group_id = p_business_group_id

Line 7902: from ben_le_clsn_n_rstr

7898: where pil.per_in_ler_id = p_per_in_ler_id;
7899: --
7900: cursor c_multiple_rate is
7901: select null
7902: from ben_le_clsn_n_rstr
7903: where BKUP_TBL_TYP_CD = 'MULTIPLE_RATE'
7904: and per_in_ler_id = p_bckdt_per_in_ler_id;
7905: --
7906: l_dummy varchar2(1);

Line 8790: delete from ben_le_clsn_n_rstr

8786: p_bnf_actn_warning => l_bnf_actn_warning,
8787: p_ctfn_actn_warning => l_ctfn_actn_warning);
8788: --
8789: -- changed 7176884 begin
8790: delete from ben_le_clsn_n_rstr
8791: where bkup_tbl_id = l_bckdt_pen_rec.prtt_enrt_rslt_id
8792: and per_in_ler_id = p_bckdt_per_in_ler_id
8793: and bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F'
8794: and person_id = p_person_id;

Line 9120: select '1' from ben_le_clsn_n_rstr pen_bckdt,

9116: and nvl(pen_int_bckdt.pgm_id,-1) = nvl(pen_int.pgm_id,-1)
9117: and nvl(pen_int_bckdt.pl_id,-1) = nvl(pen_int.pl_id,-1)
9118: and nvl(pen_int_bckdt.oipl_id,-1) = nvl(pen_int.oipl_id,-1)
9119: union
9120: select '1' from ben_le_clsn_n_rstr pen_bckdt,
9121: ben_le_clsn_n_rstr pen_int_bckdt
9122: where pen_bckdt.BKUP_TBL_ID = c_bckdt_prtt_enrt_rslt_id
9123: and pen_bckdt.per_in_ler_id = c_bckdt_per_in_ler_id
9124: and pen_bckdt.SSPNDD_FLAG = 'Y'

Line 9121: ben_le_clsn_n_rstr pen_int_bckdt

9117: and nvl(pen_int_bckdt.pl_id,-1) = nvl(pen_int.pl_id,-1)
9118: and nvl(pen_int_bckdt.oipl_id,-1) = nvl(pen_int.oipl_id,-1)
9119: union
9120: select '1' from ben_le_clsn_n_rstr pen_bckdt,
9121: ben_le_clsn_n_rstr pen_int_bckdt
9122: where pen_bckdt.BKUP_TBL_ID = c_bckdt_prtt_enrt_rslt_id
9123: and pen_bckdt.per_in_ler_id = c_bckdt_per_in_ler_id
9124: and pen_bckdt.SSPNDD_FLAG = 'Y'
9125: and pen_bckdt.RPLCS_SSPNDD_RSLT_ID is not NULL

Line 9941: from ben_le_clsn_n_rstr

9937: where pel.per_in_ler_id = p_per_in_ler_id;
9938: --
9939: cursor c_multiple_rate is
9940: select null
9941: from ben_le_clsn_n_rstr
9942: where BKUP_TBL_TYP_CD = 'MULTIPLE_RATE'
9943: and per_in_ler_id = p_bckdt_per_in_ler_id;
9944: --
9945: cursor c_bckdt_pil is

Line 10127: FROM ben_le_clsn_n_rstr pen_inner,

10123: pen_inner.effective_end_date,
10124: pen_inner.enrt_cvg_strt_dt,
10125: pen_inner.enrt_cvg_thru_dt,
10126: pen_inner.object_version_number
10127: FROM ben_le_clsn_n_rstr pen_inner,
10128: ben_per_in_ler pil_inner
10129: WHERE pil_inner.per_in_ler_id = p_bckdt_per_in_ler_id
10130: AND pil_inner.person_id = p_person_id
10131: AND pil_inner.business_group_id = p_business_group_id

Line 11530: from ben_le_clsn_n_rstr pen,

11526: pen.REQUEST_ID,
11527: pen.RPLCS_SSPNDD_RSLT_ID,
11528: pen.SSPNDD_FLAG,
11529: pen.UOM
11530: from ben_le_clsn_n_rstr pen,
11531: ben_per_in_ler pil
11532: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
11533: and pil.person_id = p_person_id
11534: and pil.business_group_id = p_business_group_id

Line 11557: from ben_le_clsn_n_rstr pen_inner,

11553: )
11554: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
11555: union
11556: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)
11557: from ben_le_clsn_n_rstr pen_inner,
11558: ben_per_in_ler pil_inner
11559: where pil_inner.per_in_ler_id = p_bckdt_per_in_ler_id
11560: and pil_inner.person_id = p_person_id
11561: and pil_inner.business_group_id = p_business_group_id