APPS.BEN_DETERMINE_VARIABLE_RATES dependencies on BEN_ACTL_PREM_VRBL_RT_RL_F

Line 141: 07-oct-05 nhunur 115.51 4657978 - added support for ben_actl_prem_vrbl_rt_rl_f.

137: 28-Jun-2005 kmahendr 115.49 Bug#4422269 - nvl used to get default
138: value of enrt bnft
139: 03-Oct-05 ssarkar 115.50 4644867 - Added order by clause to cursoe c_asg to Query 'E' assignment first
140: and then others .
141: 07-oct-05 nhunur 115.51 4657978 - added support for ben_actl_prem_vrbl_rt_rl_f.
142: 02-Feb-06 stee 115.52 Bug 4873847. CWB: If treatment code is RPLC,
143: calculate the dflt_val, elcn_mn_val and elcn_mx_val if
144: enter val at enrollment and mlt_cd is multiple of
145: compensation. Also round the values if rounding rule

Line 311: from ben_actl_prem_vrbl_rt_rl_f avr

307: --
308: -- FONM
309: cursor c_avrl(cv_effective_date date) is
310: select avr.formula_id, avr.RT_TRTMT_CD
311: from ben_actl_prem_vrbl_rt_rl_f avr
312: where avr.actl_prem_id = p_actl_prem_id
313: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)
314: between avr.effective_start_date
315: and avr.effective_end_date;