APPS.BEN_DETERMINE_ACTUAL_PREMIUM dependencies on BEN_ENRT_BNFT

Line 129: 3-Jan-2012 velvanop 115.58 Bug 16013053 - If Premium setup is 'Multiple of Coverage' and VAL column is NULL in BEN_ENRT_BNFT table after

125: should allow the user to enter a value during enrollment.
126: 14-Dec-2009 sallumwa 115.56 Bug 9135034 : Get the FONM coverage date if the current LE is an
127: FONM Event.
128: 14-Jun-2010 sagnanas 115.57 Bug 9774358 - Passed eletable choice info
129: 3-Jan-2012 velvanop 115.58 Bug 16013053 - If Premium setup is 'Multiple of Coverage' and VAL column is NULL in BEN_ENRT_BNFT table after
130: processing the LE, consider DFLT_VAL while calculating coverage
131: */
132: --------------------------------------------------------------------------------
133: --

Line 883: select nvl(val,dflt_val) into l_dflt_value from ben_enrt_bnft

879: /* Bug Bug 16013053; If val is NULL, then fetch the value of DFLT_VAL*/
880: if(l_currepe_set(epe_elenum).enrt_bnft_id is NOT NULL
881: and l_currepe_set(epe_elenum).val is NULL and NOT p_calc_only_rt_val_flag) then
882: begin
883: select nvl(val,dflt_val) into l_dflt_value from ben_enrt_bnft
884: where enrt_bnft_id=l_currepe_set(epe_elenum).enrt_bnft_id;
885: exception
886: when others then
887: l_dflt_value:=null;