APPS.BEN_DET_ENRT_RATES dependencies on BEN_PRTT_RT_VAL

Line 303: from ben_prtt_rt_val prv

299: -- The cursor below takes care of it. (maagrawa Mar 09, 2001)
300: --
301: cursor c_prv(v_prtt_enrt_rslt_id in number) is
302: select prv.prtt_rt_val_id
303: from ben_prtt_rt_val prv
304: where prv.prtt_rt_val_id = l_use_enrt_rec.prtt_rt_val_id
305: and prv.per_in_ler_id = p_per_in_ler_id
306: and prv.prtt_enrt_rslt_id = v_prtt_enrt_rslt_id
307: and prv.mlt_cd = 'FLFX'

Line 314: from ben_prtt_rt_val prv

310: --
311: cursor c_prv2(p_prtt_enrt_rslt_id in number,
312: p_acty_base_rt_id in number) is
313: select prv.prtt_rt_val_id
314: from ben_prtt_rt_val prv
315: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
316: and acty_base_rt_id = p_acty_base_rt_id
317: and prtt_rt_val_stat_cd is null;
318: --

Line 879: from ben_prtt_rt_val prv

875: prv.acty_base_rt_id,
876: prv.rt_strt_dt,
877: prv.per_in_ler_id,
878: prv.object_version_number
879: from ben_prtt_rt_val prv
880: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
881: and prv.rt_end_dt = hr_api.g_eot
882: and prv.prtt_rt_val_stat_cd is null;
883: --

Line 1129: ben_prtt_rt_val_api.update_prtt_rt_val

1125: ,p_acty_base_rt_id => l_prtt_rt_val.acty_base_rt_id
1126: ,p_effective_date => p_effective_date);
1127: --
1128: hr_utility.set_location('prtt rt val id'||l_prtt_rt_val.prtt_rt_val_id,11);
1129: ben_prtt_rt_val_api.update_prtt_rt_val
1130: (p_prtt_rt_val_id => l_prtt_rt_val.prtt_rt_val_id
1131: ,p_rt_end_dt => l_rt_end_dt
1132: ,p_ended_per_in_ler_id => p_per_in_ler_id
1133: ,p_person_id => p_person_id

Line 1164: from ben_prtt_rt_val prv

1160: prv.acty_base_rt_id,
1161: prv.rt_strt_dt,
1162: prv.per_in_ler_id,
1163: prv.object_version_number
1164: from ben_prtt_rt_val prv
1165: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1166: and prv.rt_end_dt = hr_api.g_eot
1167: and prv.prtt_rt_val_stat_cd is null;
1168: --

Line 1399: ben_prtt_rt_val_api.update_prtt_rt_val

1395: ,p_rt_end_dt_rl => l_dummy_number
1396: ,p_acty_base_rt_id => l_prtt_rt_val.acty_base_rt_id
1397: ,p_effective_date => p_effective_date);
1398: --
1399: ben_prtt_rt_val_api.update_prtt_rt_val
1400: (p_prtt_rt_val_id => l_prtt_rt_val.prtt_rt_val_id
1401: ,p_rt_end_dt => l_rt_end_dt
1402: ,p_ended_per_in_ler_id => p_per_in_ler_id
1403: ,p_person_id => p_person_id