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_ELECTION_INFORMATION dependencies on BEN_PRTT_ENRT_RSLT_F

Line 770: from ben_prtt_enrt_rslt_f pen,

766: and elk.effective_end_date;
767: --
768: cursor c_comp_obj_name (p_prtt_enrt_rslt_id number) is
769: select rtrim(substr(pln.name||' '||opt.name,1,60)) -- 4203714 rtrim to chop off the trailing spaces
770: from ben_prtt_enrt_rslt_f pen,
771: ben_pl_f pln,
772: ben_oipl_f oipl,
773: ben_opt_f opt
774: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id

Line 1011: l_global_pen_rec ben_prtt_enrt_rslt_f%rowtype;

1007: l_prnt_ann_rt varchar2(1) := 'N';
1008: l_rounded_value number;
1009: l_cal_val_in number ;
1010: l_global_asg_rec ben_global_enrt.g_global_asg_rec_type;
1011: l_global_pen_rec ben_prtt_enrt_rslt_f%rowtype;
1012: l_ele_entry_val_cd varchar2(30);
1013: l_new_assignment_id number;
1014: l_new_payroll_id number;
1015: l_new_organization_id number;

Line 1356: ben_prtt_enrt_rslt_f pen

1352: eb.cvg_mlt_cd
1353: FROM ben_enrt_rt er,
1354: ben_enrt_bnft eb,
1355: ben_acty_base_rt_f abr,
1356: ben_prtt_enrt_rslt_f pen
1357: WHERE eb.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1358: AND pen.rplcs_sspndd_rslt_id = p_prtt_enrt_rslt_id
1359: AND eb.elig_per_elctbl_chc_id = cv_elig_per_elctbl_chc_id
1360: AND pen.per_in_ler_id = p_per_in_ler_id

Line 1421: from ben_prtt_enrt_rslt_f pen

1417: select prv.*
1418: ,abr.element_type_id
1419: ,abr.input_value_id
1420: ,pen.person_id
1421: from ben_prtt_enrt_rslt_f pen
1422: ,ben_prtt_rt_val prv
1423: ,ben_acty_base_rt_f abr
1424: where pen.effective_end_date = hr_api.g_eot
1425: and pen.enrt_cvg_thru_dt <> hr_api.g_eot

Line 4272: l_global_pen_rec ben_prtt_enrt_rslt_f%rowtype;

4268: l_global_epe_rec ben_global_enrt.g_global_epe_rec_type;
4269: l_global_pel_rec ben_global_enrt.g_global_pel_rec_type;
4270: l_global_pil_rec ben_global_enrt.g_global_pil_rec_type;
4271: l_global_enb_rec ben_global_enrt.g_global_enb_rec_type;
4272: l_global_pen_rec ben_prtt_enrt_rslt_f%rowtype;
4273:
4274: l_xenrt_cvg_strt_dt date;
4275: l_xenrt_cvg_strt_dt_cd varchar2(30);
4276: l_xenrt_cvg_strt_dt_rl number;

Line 4325: from ben_prtt_enrt_rslt_f pen

4321: pen.enrt_ovrid_thru_dt,
4322: pen.enrt_ovrid_rsn_cd,
4323: pen.enrt_ovridn_flag,
4324: pen.sspndd_flag
4325: from ben_prtt_enrt_rslt_f pen
4326: where pen.prtt_enrt_rslt_id=v_prtt_enrt_rslt_id and
4327: pen.business_group_id=p_business_group_id and
4328: pen.prtt_enrt_rslt_stat_cd is null and
4329: p_effective_date between

Line 4338: from ben_prtt_enrt_rslt_f pen

4334: -- Bug 2627078 fixes
4335: cursor c_delink_interim(v_prtt_enrt_rslt_id number, v_sspnd_result_id number ) is
4336: select pen.prtt_enrt_rslt_id ,
4337: pen.object_version_number
4338: from ben_prtt_enrt_rslt_f pen
4339: where pen.rplcs_sspndd_rslt_id = v_prtt_enrt_rslt_id and
4340: pen.prtt_enrt_rslt_id = v_sspnd_result_id and
4341: p_effective_date between
4342: pen.effective_start_date and pen.effective_end_date

Line 4419: ben_prtt_enrt_rslt_f pen

4415: --
4416: cursor c_enb_pen is
4417: select enb.prtt_enrt_rslt_id
4418: from ben_enrt_bnft enb,
4419: ben_prtt_enrt_rslt_f pen
4420: where enb.enrt_bnft_id = p_enrt_bnft_id
4421: and enb.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
4422: and pen.effective_end_date = hr_api.g_eot
4423: and pen.enrt_cvg_thru_dt = hr_api.g_eot

Line 4430: from ben_prtt_enrt_rslt_f pen

4426: --
4427: -- Bug 2600087 fixes to open future dated coverage
4428: cursor c_enrt_rslt is
4429: select pen.*
4430: from ben_prtt_enrt_rslt_f pen
4431: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4432: and pen.prtt_enrt_rslt_stat_cd is null
4433: and pen.effective_end_date = (select pen2.effective_start_date - 1
4434: from ben_prtt_enrt_rslt_f pen2

Line 4434: from ben_prtt_enrt_rslt_f pen2

4430: from ben_prtt_enrt_rslt_f pen
4431: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4432: and pen.prtt_enrt_rslt_stat_cd is null
4433: and pen.effective_end_date = (select pen2.effective_start_date - 1
4434: from ben_prtt_enrt_rslt_f pen2
4435: where pen2.enrt_cvg_thru_dt <> hr_api.g_eot
4436: and pen2.effective_end_date = hr_api.g_eot
4437: and pen2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4438: and pen2.prtt_enrt_rslt_stat_cd is null);

Line 4443: from ben_prtt_enrt_rslt_f pen

4439: --
4440: --bug#5032364
4441: cursor c_enrt_rslt2 is
4442: select pen.*
4443: from ben_prtt_enrt_rslt_f pen
4444: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4445: and pen.prtt_enrt_rslt_stat_cd is null
4446: and pen.effective_end_date = hr_api.g_eot;
4447: --

Line 4479: from ben_prtt_enrt_rslt_f pen

4475: and pdp.effective_end_date;
4476: --
4477: cursor c_pen_exists(v_prtt_enrt_rslt_id number) is
4478: select 'x'
4479: from ben_prtt_enrt_rslt_f pen
4480: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4481: and pen.business_group_id = p_business_group_id
4482: and p_effective_date between pen.effective_start_date
4483: and pen.effective_end_date ;

Line 4524: from ben_prtt_enrt_rslt_f pen

4520: -- Bug 5600697
4521: --
4522: cursor c_is_pen_valid(cv_prtt_enrt_rslt_id number) is
4523: select pen.prtt_enrt_Rslt_stat_Cd
4524: from ben_prtt_enrt_rslt_f pen
4525: where pen.prtt_enrt_rslt_id = cv_prtt_enrt_rslt_id and
4526: pen.business_group_id= p_business_group_id and
4527: p_effective_date between pen.effective_start_date and pen.effective_end_date;
4528: --

Line 4534: from ben_prtt_enrt_rslt_f pen

4530: --
4531: cursor c_pen_curr(v_prtt_enrt_rslt_id number,
4532: p_effective_date date) is
4533: select pen.*
4534: from ben_prtt_enrt_rslt_f pen
4535: where pen.prtt_enrt_rslt_id = v_prtt_enrt_rslt_id
4536: and p_effective_date between
4537: pen.effective_start_date and pen.effective_end_date
4538: and pen.effective_end_date <> hr_api.g_eot

Line 4612: from ben_prtt_enrt_rslt_f pen

4608: cursor c_get_enrt_rslts_for_pen(p_cvg_end_dt date
4609: ,p_ptip_id number
4610: ) is
4611: select pen.*, epe.per_in_ler_id pil_id
4612: from ben_prtt_enrt_rslt_f pen
4613: ,ben_ptip_f ptip
4614: ,ben_per_in_ler pil
4615: ,ben_elig_per_elctbl_chc epe
4616: where pen.effective_end_date = hr_api.g_eot -- '31-dec-4712'

Line 4632: where leclr.BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_RSLT_F_ADJ'

4628: --
4629: cursor c_prtt_enrt_rslt_adj (p_prtt_enrt_rslt_id number) is
4630: select null
4631: from ben_le_clsn_n_rstr leclr, ben_elig_per_elctbl_chc epe
4632: where leclr.BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_RSLT_F_ADJ'
4633: AND leclr.BKUP_TBL_ID = p_prtt_enrt_rslt_id
4634: AND leclr.PER_IN_LER_ID = epe.per_in_ler_id
4635: AND epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;
4636: --

Line 5259: from ben_prtt_enrt_rslt_f pen

5255: end if;
5256: -- 3733745
5257: select count(*)
5258: into l_interim_count
5259: from ben_prtt_enrt_rslt_f pen
5260: where pen.rplcs_sspndd_rslt_id = p_prtt_enrt_rslt_id
5261: and nvl(pen.sspndd_flag , 'N') = 'Y'
5262: and p_effective_date
5263: between pen.effective_start_date and pen.effective_end_date;

Line 5366: 'BEN_PRTT_ENRT_RSLT_F_CORR',

5362: PLIP_ORDR_NUM,
5363: PTIP_ORDR_NUM,
5364: OIPL_ORDR_NUM)
5365: values (
5366: 'BEN_PRTT_ENRT_RSLT_F_CORR',
5367: l_enrt_rslt2.COMP_LVL_CD,
5368: l_enrt_rslt2.PEN_ATTRIBUTE16,
5369: l_enrt_rslt2.PEN_ATTRIBUTE17,
5370: l_enrt_rslt2.PEN_ATTRIBUTE18,

Line 6172: 'BEN_PRTT_ENRT_RSLT_F_ADJ',

6168: ENRT_CVG_THRU_DT,
6169: business_group_id,
6170: object_version_number)
6171: values (
6172: 'BEN_PRTT_ENRT_RSLT_F_ADJ',
6173: l_get_enrt_rslts_for_pen.prtt_enrt_rslt_id,
6174: l_get_enrt_rslts_for_pen.pil_id,
6175: l_get_enrt_rslts_for_pen.person_id,
6176: l_get_enrt_rslts_for_pen.enrt_cvg_thru_dt,