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 178: from ben_le_clsn_n_rstr pen_inner,

174: )
175: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
176: union
177: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)
178: from ben_le_clsn_n_rstr pen_inner,
179: ben_per_in_ler pil_inner
180: where pil_inner.per_in_ler_id = c_bckdt_per_in_ler_id
181: and pil_inner.person_id = c_person_id
182: AND pil_inner.per_in_ler_id = pen_inner.per_in_ler_id

Line 268: from ben_le_clsn_n_rstr pen,

264: pen.REQUEST_ID,
265: pen.RPLCS_SSPNDD_RSLT_ID,
266: pen.SSPNDD_FLAG,
267: pen.UOM
268: from ben_le_clsn_n_rstr pen,
269: ben_per_in_ler pil,
270: ben_pil_elctbl_chc_popl pel --Added for Bug 4423161
271: where pil.per_in_ler_id = c_bckdt_per_in_ler_id
272: and pil.person_id = c_person_id

Line 305: from ben_le_clsn_n_rstr pen_inner,

301: )
302: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
303: union
304: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)
305: from ben_le_clsn_n_rstr pen_inner,
306: ben_per_in_ler pil_inner
307: where pil_inner.per_in_ler_id = c_bckdt_per_in_ler_id
308: and pil_inner.person_id = c_person_id
309: AND pil_inner.per_in_ler_id = pen_inner.per_in_ler_id

Line 585: from ben_le_clsn_n_rstr lcr

581: and pen.effective_end_date
582: /* 9999 complete this part from the backup table */
583: union
584: select 'Y'
585: from ben_le_clsn_n_rstr lcr
586: where lcr.per_in_ler_id = p_bckdt_per_in_ler_id
587: and lcr.business_group_id = p_business_group_id
588: and p_effective_date between lcr.effective_start_date
589: and lcr.effective_end_date;

Line 2770: from ben_le_clsn_n_rstr cqb

2766: and crp.business_group_id = p_business_group_id;
2767: --
2768: cursor c_bckdt_cqb is
2769: select cqb.*
2770: from ben_le_clsn_n_rstr cqb
2771: where cqb.per_in_ler_id = p_bckdt_per_in_ler_id
2772: and cqb.business_group_id = p_business_group_id
2773: and cqb.bkup_tbl_typ_cd = 'BEN_CBR_QUALD_BNF';
2774: --

Line 2828: delete from ben_le_clsn_n_rstr cqb

2824: --
2825: -- Delete all the backup rows from the backup table after the
2826: -- restoration of rows.
2827: --
2828: delete from ben_le_clsn_n_rstr cqb
2829: where cqb.per_in_ler_id = p_bckdt_per_in_ler_id
2830: and cqb.business_group_id = p_business_group_id
2831: and cqb.bkup_tbl_typ_cd = 'BEN_CBR_QUALD_BNF';
2832: --

Line 3200: from ben_le_clsn_n_rstr pen,

3196: pen.REQUEST_ID,
3197: pen.RPLCS_SSPNDD_RSLT_ID,
3198: pen.SSPNDD_FLAG,
3199: pen.UOM
3200: from ben_le_clsn_n_rstr pen,
3201: ben_per_in_ler pil
3202: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
3203: and pil.person_id = p_person_id
3204: and pil.business_group_id = p_business_group_id

Line 3250: from ben_le_clsn_n_rstr pen,

3246: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
3247: AND pil.per_in_ler_id = pen.per_in_ler_id;
3248: --
3249: select count(*) into l_bckdt_pen_cnt
3250: from ben_le_clsn_n_rstr pen,
3251: ben_per_in_ler pil
3252: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
3253: and pil.person_id = p_person_id
3254: and pil.business_group_id = p_business_group_id

Line 3636: from ben_le_clsn_n_rstr pen,

3632: pen.PGM_ID,
3633: pen.PL_ID,
3634: pen.PL_TYP_ID,
3635: pen.PTIP_ID
3636: from ben_le_clsn_n_rstr pen,
3637: ben_per_in_ler pil
3638: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
3639: and pil.person_id = p_person_id
3640: and pil.business_group_id = p_business_group_id

Line 3779: from ben_le_clsn_n_rstr bckdt_bpl

3775: ,bckdt_bpl.CREATION_DATE
3776: ,bckdt_bpl.OBJECT_VERSION_NUMBER
3777: ,bckdt_bpl.VAL -- Used for RLD_UP_VAL
3778: ,bckdt_bpl.PER_IN_LER_ID
3779: from ben_le_clsn_n_rstr bckdt_bpl
3780: where bckdt_bpl.per_in_ler_id = p_bckdt_per_in_ler_id
3781: and bckdt_bpl.business_group_id = p_business_group_id
3782: and bckdt_bpl.prtt_enrt_rslt_id = cp_bckdt_prtt_enrt_rslt_id
3783: and bckdt_bpl.BKUP_TBL_TYP_CD = 'BEN_BNFT_PRVDD_LDGR_F'

Line 4343: from ben_le_clsn_n_rstr pea

4339: -- and pea.ELIG_CVRD_DPNT_ID is null
4340: union
4341: select pea.OVRDN_THRU_DT, -- used as pea.CMPLTD_DT
4342: pea.PL_TYP_ID -- used as ACTN_TYP_ID
4343: from ben_le_clsn_n_rstr pea
4344: where pea.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
4345: and pea.business_group_id = p_business_group_id
4346: and pea.per_in_ler_id = p_bckdt_per_in_ler_id
4347: and p_effective_date between pea.effective_start_date

Line 4728: from ben_le_clsn_n_rstr pdp_old

4724: pdp_old.PROGRAM_UPDATE_DATE,
4725: pdp_old.OBJECT_VERSION_NUMBER,
4726: pdp_old.BKUP_TBL_ID,
4727: pdp_old.EFFECTIVE_START_DATE
4728: from ben_le_clsn_n_rstr pdp_old
4729: where pdp_old.per_in_ler_id = p_bckdt_per_in_ler_id
4730: and pdp_old.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
4731: and pdp_old.business_group_id = p_business_group_id
4732: and pdp_old.bkup_tbl_typ_cd = 'BEN_ELIG_CVRD_DPNT_F'

Line 4749: from ben_le_clsn_n_rstr pdp_old

4745: and prtt_enrt_rslt_id = pdp_old.prtt_enrt_rslt_id))
4746: and (pdp_old.cvg_thru_dt is null or pdp_old.cvg_thru_dt = hr_api.g_eot)
4747: union
4748: select 'Y'
4749: from ben_le_clsn_n_rstr pdp_old
4750: where pdp_old.bkup_tbl_id = p_elig_cvrd_dpnt_id
4751: and pdp_old.bkup_tbl_typ_cd = 'BEN_ELIG_CVRD_DPNT_F'
4752: and pdp_old.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
4753: and ((pdp_old.cvg_thru_dt is null or pdp_old.cvg_thru_dt = hr_api.g_eot) and

Line 5266: from ben_le_clsn_n_rstr pbn

5262: pbn.PERSON_TTEE_ID,
5263: pbn.BUSINESS_GROUP_ID,
5264: pbn.PER_IN_LER_ID,
5265: pbn.LCR_ATTRIBUTE_CATEGORY
5266: from ben_le_clsn_n_rstr pbn
5267: where pbn.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
5268: and pbn.business_group_id = p_business_group_id
5269: and pbn.per_in_ler_id = p_bckdt_per_in_ler_id
5270: and p_effective_date between pbn.effective_start_date

Line 5737: from ben_le_clsn_n_rstr pen_inner,

5733: )
5734: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
5735: union
5736: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)
5737: from ben_le_clsn_n_rstr pen_inner,
5738: ben_per_in_ler pil_inner
5739: where pil_inner.per_in_ler_id = p_bckdt_per_in_ler_id
5740: and pil_inner.person_id = p_person_id
5741: and pil_inner.business_group_id = p_business_group_id

Line 5828: from ben_le_clsn_n_rstr pen,

5824: pen.REQUEST_ID,
5825: pen.RPLCS_SSPNDD_RSLT_ID,
5826: pen.SSPNDD_FLAG,
5827: pen.UOM
5828: from ben_le_clsn_n_rstr pen,
5829: ben_per_in_ler pil
5830: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
5831: and pil.person_id = p_person_id
5832: and pil.business_group_id = p_business_group_id

Line 5855: from ben_le_clsn_n_rstr pen_inner,

5851: )
5852: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
5853: union
5854: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)
5855: from ben_le_clsn_n_rstr pen_inner,
5856: ben_per_in_ler pil_inner
5857: where pil_inner.per_in_ler_id = p_bckdt_per_in_ler_id
5858: and pil_inner.person_id = p_person_id
5859: and pil_inner.business_group_id = p_business_group_id

Line 7508: from ben_le_clsn_n_rstr

7504: where pil.per_in_ler_id = p_per_in_ler_id;
7505: --
7506: cursor c_multiple_rate is
7507: select null
7508: from ben_le_clsn_n_rstr
7509: where BKUP_TBL_TYP_CD = 'MULTIPLE_RATE'
7510: and per_in_ler_id = p_bckdt_per_in_ler_id;
7511: --
7512: l_dummy varchar2(1);

Line 8138: delete from ben_le_clsn_n_rstr

8134: p_bnf_actn_warning => l_bnf_actn_warning,
8135: p_ctfn_actn_warning => l_ctfn_actn_warning);
8136: --
8137: -- changed 7176884 begin
8138: delete from ben_le_clsn_n_rstr
8139: where bkup_tbl_id = l_bckdt_pen_rec.prtt_enrt_rslt_id
8140: and per_in_ler_id = p_bckdt_per_in_ler_id
8141: and bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F'
8142: and person_id = p_person_id;

Line 9135: from ben_le_clsn_n_rstr

9131: where pel.per_in_ler_id = p_per_in_ler_id;
9132: --
9133: cursor c_multiple_rate is
9134: select null
9135: from ben_le_clsn_n_rstr
9136: where BKUP_TBL_TYP_CD = 'MULTIPLE_RATE'
9137: and per_in_ler_id = p_bckdt_per_in_ler_id;
9138: --
9139: cursor c_bckdt_pil is

Line 9204: FROM ben_le_clsn_n_rstr pen_inner,

9200: pen_inner.effective_end_date,
9201: pen_inner.enrt_cvg_strt_dt,
9202: pen_inner.enrt_cvg_thru_dt,
9203: pen_inner.object_version_number
9204: FROM ben_le_clsn_n_rstr pen_inner,
9205: ben_per_in_ler pil_inner
9206: WHERE pil_inner.per_in_ler_id = p_bckdt_per_in_ler_id
9207: AND pil_inner.person_id = p_person_id
9208: AND pil_inner.business_group_id = p_business_group_id

Line 10049: from ben_le_clsn_n_rstr pen,

10045: pen.REQUEST_ID,
10046: pen.RPLCS_SSPNDD_RSLT_ID,
10047: pen.SSPNDD_FLAG,
10048: pen.UOM
10049: from ben_le_clsn_n_rstr pen,
10050: ben_per_in_ler pil
10051: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
10052: and pil.person_id = p_person_id
10053: and pil.business_group_id = p_business_group_id

Line 10076: from ben_le_clsn_n_rstr pen_inner,

10072: )
10073: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
10074: union
10075: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)
10076: from ben_le_clsn_n_rstr pen_inner,
10077: ben_per_in_ler pil_inner
10078: where pil_inner.per_in_ler_id = p_bckdt_per_in_ler_id
10079: and pil_inner.person_id = p_person_id
10080: and pil_inner.business_group_id = p_business_group_id