271: --
272: -- get values for rules and limit checking
273: --bof FONM
274: l_fonm_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
275: if ben_manage_life_events.fonm = 'Y' then
276: l_fonm_date := nvl(p_fonm_cvg_strt_dt, l_fonm_date ) ;
277: end if ;
278: --eof FONM
279: /* -- 4031733 - cursor used to populate l_state.region_2
716: l_opt c_opt%rowtype;
717: l_epr_elenum pls_integer;
718: -- Bof FONM
719: l_fonm_date date ;
720: l_fonm_flag varchar2(1) := ben_manage_life_events.fonm ;
721: l_fonm_cvg_strt_dt date ;
722: l_fonm_rt_strt_dt date ;
723: l_dummy_d date ;
724: l_fonm_per_rec per_all_people_f%rowtype;
832: l_FONM_flag := 'Y' ;
833: else
834: l_FONM_flag := 'N' ;
835: l_FONM_date := nvl(p_lf_evt_ocrd_dt, p_effective_date) ;
836: ben_manage_life_events.g_fonm_cvg_strt_dt := null ;
837: ben_manage_life_events.fonm := 'N' ;
838: end if ;
839: hr_utility.set_location ('premium fonm -> '||l_FONM_flag,50);
840:
833: else
834: l_FONM_flag := 'N' ;
835: l_FONM_date := nvl(p_lf_evt_ocrd_dt, p_effective_date) ;
836: ben_manage_life_events.g_fonm_cvg_strt_dt := null ;
837: ben_manage_life_events.fonm := 'N' ;
838: end if ;
839: hr_utility.set_location ('premium fonm -> '||l_FONM_flag,50);
840:
841: if l_FONM_flag = 'Y' then
842:
843: if l_currepe_set(epe_elenum).fonm_cvg_strt_dt is not null then
844: l_FONM_date := l_currepe_set(epe_elenum).fonm_cvg_strt_dt ;
845: l_fonm_cvg_strt_dt:= l_currepe_set(epe_elenum).fonm_cvg_strt_dt ;
846: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt ;
847: ben_manage_life_events.fonm := 'Y' ;
848: end if ;
849:
850: /* -- for future
843: if l_currepe_set(epe_elenum).fonm_cvg_strt_dt is not null then
844: l_FONM_date := l_currepe_set(epe_elenum).fonm_cvg_strt_dt ;
845: l_fonm_cvg_strt_dt:= l_currepe_set(epe_elenum).fonm_cvg_strt_dt ;
846: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt ;
847: ben_manage_life_events.fonm := 'Y' ;
848: end if ;
849:
850: /* -- for future
851: --- calcualte the rate start date
862: end if ;
863: */
864:
865: end if ;
866: hr_utility.set_location ('g_fonm_cvg_strt_dt '||ben_manage_life_events.g_fonm_cvg_strt_dt,50);
867: -- EOF FONM
868:
869: -- l_enrt_bnft_id := l_currepe_set(epe_elenum).enrt_bnft_id;
870: -- l_coverage_value := null;