APPS.BEN_PRV_BUS dependencies on BEN_ACTY_BASE_RT_F

Line 1016: from ben_acty_base_rt_f abr

1012: -- 4272271
1013: /*
1014: cursor c_abr(c_acty_base_rt_id number) is
1015: select abr.ann_mn_elcn_val, abr.ann_mx_elcn_val
1016: from ben_acty_base_rt_f abr
1017: where abr.acty_base_rt_id = c_acty_base_rt_id
1018: and p_effective_date between abr.effective_start_date
1019: and abr.effective_end_date;
1020: */

Line 1055: -- ben_acty_base_rt_f, rather than enrt_rt to avoid proration happening on already prorated value.

1051: -- was created.
1052: -- Bug: 4272271. Commented out the prorate_min_max as proration was happening on already prorated values.
1053: /*
1054: -- Bug: 4272271. Pick l_ann_mn_elcn_val, l_ann_mx_elcn_val from
1055: -- ben_acty_base_rt_f, rather than enrt_rt to avoid proration happening on already prorated value.
1056: open c_abr(l_c1.acty_base_rt_id);
1057: fetch c_abr into l_ann_mn_elcn_val, l_ann_mx_elcn_val;
1058: if c_abr%notfound then
1059: l_ann_mn_elcn_val := l_c1.ann_mn_elcn_val;

Line 1236: from ben_acty_base_rt_f

1232:
1233:
1234: cursor c_abr (p_acty_base_rt_id number , p_effective_date date) is
1235: select use_calc_acty_bs_rt_flag
1236: from ben_acty_base_rt_f
1237: where acty_base_rt_id = p_acty_base_rt_id
1238: and p_effective_date between effective_start_date and effective_end_date ;
1239:
1240: cursor c_chc is

Line 1450: from ben_acty_base_rt_f

1446: l_dummy varchar2(1);
1447: --
1448: cursor c_abr is
1449: select null
1450: from ben_acty_base_rt_f
1451: where acty_base_rt_id = p_acty_base_rt_id
1452: and p_effective_date between effective_start_date
1453: and effective_end_date;
1454: Begin