APPS.BEN_REOPEN_ENDED_RESULTS dependencies on BEN_PRTT_RT_VAL

Line 254: from ben_prtt_rt_val prv

250: cursor c_ended_prv (p_per_in_ler_id number,
251: p_person_id number,
252: p_pgm_id number) is
253: select prv.*
254: from ben_prtt_rt_val prv
255: where prv.prtt_enrt_rslt_id in
256: (select pen.prtt_enrt_rslt_id
257: from ben_prtt_enrt_rslt_f pen
258: where pen.effective_end_date = hr_api.g_eot

Line 305: from ben_prtt_rt_val prv

301: cursor c_prv (p_per_in_ler_id number,
302: p_acty_base_rt_id number,
303: p_prtt_enrt_rslt_id number) is
304: select prv.*
305: from ben_prtt_rt_val prv
306: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
307: and prv.ended_per_in_ler_id = p_per_in_ler_id
308: and prv.acty_base_rt_id = p_acty_base_rt_id
309: and prv.prtt_rt_val_stat_cd is not null;

Line 337: ,ben_prtt_rt_val prv

333: ,abr.element_type_id
334: ,abr.input_value_id
335: ,pen.person_id
336: from ben_prtt_enrt_rslt_f pen
337: ,ben_prtt_rt_val prv
338: ,ben_acty_base_rt_f abr
339: where pen.effective_end_date = hr_api.g_eot
340: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
341: and pen.prtt_enrt_rslt_stat_cd is null

Line 426: where BKUP_TBL_TYP_CD = 'BEN_PRTT_RT_VAL_ADJ'

422: cursor c_prtt_rt_val_adj (p_per_in_ler_id number,
423: p_prtt_rt_val_id number) is
424: select null
425: from ben_le_clsn_n_rstr
426: where BKUP_TBL_TYP_CD = 'BEN_PRTT_RT_VAL_ADJ'
427: AND BKUP_TBL_ID = p_prtt_rt_val_id
428: AND PER_IN_LER_ID = p_per_in_ler_id;
429: --
430: -- Added for bug 7206471

Line 896: ben_prtt_rt_val_api.update_prtt_rt_val

892: hr_utility.set_location('l_prv.rt_end_dt ' || l_prv.rt_end_dt ,121);
893: hr_utility.set_location('l_ended_prv.rt_end_dt ' || l_ended_prv.rt_end_dt ,121);
894: hr_utility.set_location('Rate should be ended with lesser date ',121);
895:
896: ben_prtt_rt_val_api.update_prtt_rt_val
897: (P_VALIDATE => FALSE
898: ,P_PRTT_RT_VAL_ID => l_ended_prv.prtt_rt_val_id
899: ,P_RT_END_DT => l_prv.rt_end_dt
900: ,p_person_id => p_person_id

Line 1165: 'BEN_PRTT_RT_VAL_ADJ',

1161: RT_END_DT,
1162: business_group_id,
1163: object_version_number)
1164: values (
1165: 'BEN_PRTT_RT_VAL_ADJ',
1166: l_pen.prtt_rt_val_id,
1167: p_per_in_ler_id,
1168: l_pen.person_id,
1169: l_pen.rt_end_dt,

Line 1176: ben_prtt_rt_val_api.update_prtt_rt_val

1172: );
1173: end if;
1174: close c_prtt_rt_val_adj;
1175: --
1176: ben_prtt_rt_val_api.update_prtt_rt_val
1177: (P_VALIDATE => FALSE
1178: ,P_PRTT_RT_VAL_ID => l_pen.prtt_rt_val_id
1179: ,P_RT_END_DT => l_epe.rt_strt_dt - 1
1180: ,p_person_id => l_pen.person_id