APPS.BEN_DETERMINE_RATE_CHG dependencies on BEN_PRTT_RT_VAL

Line 536: from ben_prtt_rt_val prv

532: prv.tx_typ_cd,
533: prv.element_entry_value_id,
534: prv.rt_ovridn_flag,
535: prv.rt_ovridn_thru_dt
536: from ben_prtt_rt_val prv
537: where prv.prtt_enrt_rslt_id = l_pen.prtt_enrt_rslt_id
538: and prv.acty_base_rt_id = v_acty_base_rt_id
539: and ((v_rt_strt_dt is not null and
540: v_rt_strt_dt between prv.rt_strt_dt and prv.rt_end_dt) or

Line 550: from ben_prtt_rt_val prv

546: --
547: cursor c_prv_min_dt(p_pen_id number,
548: p_abr_id number) is
549: select min(prv.rt_strt_dt)
550: from ben_prtt_rt_val prv
551: where prv.prtt_enrt_rslt_id = p_pen_id
552: and prv.acty_base_rt_id = p_abr_id
553: and prv.prtt_rt_val_stat_cd is null;
554:

Line 2194: from ben_prtt_rt_val prv

2190: select
2191: prv.rt_val,
2192: prv.rt_strt_dt,
2193: prv.object_version_number
2194: from ben_prtt_rt_val prv
2195: where prv.prtt_rt_val_id = p_prtt_rt_val_id and
2196: prv.business_group_id = p_business_group_id and
2197: prv.prtt_rt_val_stat_cd is null
2198: ;

Line 2205: from ben_prtt_rt_val prv

2201: --
2202: cursor c_prv_future is
2203: select
2204: prv.*
2205: from ben_prtt_rt_val prv
2206: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id and
2207: prv.business_group_id = p_business_group_id and
2208: prv.acty_base_rt_id = l_acty_base_rt_id and
2209: prv.prtt_rt_val_stat_cd is null

Line 2216: from ben_prtt_rt_val prv

2212: --
2213: cursor c_prv_past is
2214: select
2215: prv.*
2216: from ben_prtt_rt_val prv
2217: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id and
2218: prv.rt_end_dt = (l_prv.rt_strt_dt -1) and
2219: prv.business_group_id = p_business_group_id and
2220: prv.acty_base_rt_id = l_acty_base_rt_id and

Line 2267: ben_prtt_rt_val_api.delete_prtt_rt_val

2263: l_acty_base_rt_id := l_ecr.acty_base_rt_id;
2264: --
2265:
2266: if l_prv.rt_strt_dt < p_rt_strt_dt and p_mode = 'UPD' then
2267: ben_prtt_rt_val_api.delete_prtt_rt_val
2268: (p_prtt_rt_val_id => p_prtt_rt_val_id
2269: ,p_person_id => p_person_id
2270: ,p_business_group_id => p_business_group_id
2271: ,p_object_version_number => l_prv.object_version_number

Line 2299: ben_prtt_rt_val_api.delete_prtt_rt_val

2295: end if;
2296: --
2297: if l_prv_future.rt_strt_dt > p_rt_strt_dt then
2298: --
2299: ben_prtt_rt_val_api.delete_prtt_rt_val
2300: (p_prtt_rt_val_id => l_prv_future.prtt_rt_val_id
2301: ,p_person_id => p_person_id
2302: ,p_business_group_id => p_business_group_id
2303: ,p_object_version_number => l_prv_future.object_version_number

Line 2322: ben_prtt_rt_val_api.update_prtt_rt_val(

2318: -- do nothing for non recurring rate
2319: null;
2320: else
2321:
2322: ben_prtt_rt_val_api.update_prtt_rt_val(
2323: p_validate => FALSE
2324: ,p_prtt_rt_val_id => l_prv_future.prtt_rt_val_id
2325: ,p_person_id => p_person_id
2326: ,p_input_value_id => l_abr.input_value_id