APPS.BEN_REOPEN_ENDED_RESULTS dependencies on BEN_PRTT_RT_VAL

Line 278: from ben_prtt_rt_val prv

274: cursor c_ended_prv (p_per_in_ler_id number,
275: p_person_id number,
276: p_pgm_id number) is
277: select prv.*
278: from ben_prtt_rt_val prv
279: where prv.prtt_enrt_rslt_id in
280: (select pen.prtt_enrt_rslt_id
281: from ben_prtt_enrt_rslt_f pen
282: where pen.effective_end_date = hr_api.g_eot

Line 329: from ben_prtt_rt_val prv

325: cursor c_prv (p_per_in_ler_id number,
326: p_acty_base_rt_id number,
327: p_prtt_enrt_rslt_id number) is
328: select prv.*
329: from ben_prtt_rt_val prv
330: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
331: and prv.ended_per_in_ler_id = p_per_in_ler_id
332: and prv.acty_base_rt_id = p_acty_base_rt_id
333: and prv.prtt_rt_val_stat_cd is not null;

Line 340: from ben_prtt_rt_val prv

336: --
337: cursor c_get_prv (p_prtt_enrt_rslt_id number,
338: p_per_in_ler_id number) is
339: select prv.*
340: from ben_prtt_rt_val prv
341: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
342: and prv.rt_end_dt <> hr_api.g_eot
343: and prv.ended_per_in_ler_id = p_per_in_ler_id
344: and prv.prtt_rt_val_stat_cd is null;

Line 375: ,ben_prtt_rt_val prv

371: ,abr.element_type_id
372: ,abr.input_value_id
373: ,pen.person_id
374: from ben_prtt_enrt_rslt_f pen
375: ,ben_prtt_rt_val prv
376: ,ben_acty_base_rt_f abr
377: where pen.effective_end_date = hr_api.g_eot
378: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
379: and pen.prtt_enrt_rslt_stat_cd is null

Line 464: where BKUP_TBL_TYP_CD = 'BEN_PRTT_RT_VAL_ADJ'

460: cursor c_prtt_rt_val_adj (p_per_in_ler_id number,
461: p_prtt_rt_val_id number) is
462: select null
463: from ben_le_clsn_n_rstr
464: where BKUP_TBL_TYP_CD = 'BEN_PRTT_RT_VAL_ADJ'
465: AND BKUP_TBL_ID = p_prtt_rt_val_id
466: AND PER_IN_LER_ID = p_per_in_ler_id;
467: --
468: -- Added for bug 7206471

Line 934: ben_prtt_rt_val_api.update_prtt_rt_val

930: hr_utility.set_location('l_prv.rt_end_dt ' || l_prv.rt_end_dt ,121);
931: hr_utility.set_location('l_ended_prv.rt_end_dt ' || l_ended_prv.rt_end_dt ,121);
932: hr_utility.set_location('Rate should be ended with lesser date ',121);
933:
934: ben_prtt_rt_val_api.update_prtt_rt_val
935: (P_VALIDATE => FALSE
936: ,P_PRTT_RT_VAL_ID => l_ended_prv.prtt_rt_val_id
937: ,P_RT_END_DT => l_prv.rt_end_dt
938: ,p_person_id => p_person_id

Line 1153: 'BEN_PRTT_RT_VAL',

1149: BKUP_TBL_ID, -- prtt_rt_val_id
1150: OBJECT_VERSION_NUMBER)
1151:
1152: values (
1153: 'BEN_PRTT_RT_VAL',
1154: l_prv_rec.rt_end_dt,
1155: p_per_in_ler_id,
1156: l_prv_rec.ended_per_in_ler_id,
1157: l_prv_rec.prtt_rt_val_id,

Line 1439: 'BEN_PRTT_RT_VAL_ADJ',

1435: RT_END_DT,
1436: business_group_id,
1437: object_version_number)
1438: values (
1439: 'BEN_PRTT_RT_VAL_ADJ',
1440: l_pen.prtt_rt_val_id,
1441: p_per_in_ler_id,
1442: l_pen.person_id,
1443: l_pen.rt_end_dt,

Line 1450: ben_prtt_rt_val_api.update_prtt_rt_val

1446: );
1447: end if;
1448: close c_prtt_rt_val_adj;
1449: --
1450: ben_prtt_rt_val_api.update_prtt_rt_val
1451: (P_VALIDATE => FALSE
1452: ,P_PRTT_RT_VAL_ID => l_pen.prtt_rt_val_id
1453: ,P_RT_END_DT => l_epe.rt_strt_dt - 1
1454: ,p_person_id => l_pen.person_id