228: --
229: --
230: -- Task 131 (pbodla): Elig dependent records are created soon after
231: -- person is found eligible. This procedure is called from
232: -- ben_manage_life_events.process_comp_objects(benmngle.pkb).
233: -- Then electable choice record is created in bendenrr.pkb.
234: -- Essentially elig dependent rows are created before creating
235: -- the electable choice row.
236: -- All elig dependent rows which belongs to a electable choice
698: hr_utility.set_location ('Entering '||l_proc,10);
699: end if;
700: --
701: if g_debug then
702: hr_utility.set_location ('Fonm '|| ben_manage_life_events.fonm ,10);
703: hr_utility.set_location ('Fonm '|| ben_manage_life_events.g_fonm_cvg_strt_dt ,10);
704: end if;
705: l_sysdate := sysdate;
706: -- fonm
699: end if;
700: --
701: if g_debug then
702: hr_utility.set_location ('Fonm '|| ben_manage_life_events.fonm ,10);
703: hr_utility.set_location ('Fonm '|| ben_manage_life_events.g_fonm_cvg_strt_dt ,10);
704: end if;
705: l_sysdate := sysdate;
706: -- fonm
707: l_lf_evt_ocrd_dt := nvl(p_lf_evt_ocrd_dt, p_effective_date);
704: end if;
705: l_sysdate := sysdate;
706: -- fonm
707: l_lf_evt_ocrd_dt := nvl(p_lf_evt_ocrd_dt, p_effective_date);
708: if ben_manage_life_events.fonm = 'Y'
709: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
710: --
711: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
712: l_lf_evt_ocrd_dt := nvl(l_fonm_cvg_strt_dt,l_lf_evt_ocrd_dt ) ;
705: l_sysdate := sysdate;
706: -- fonm
707: l_lf_evt_ocrd_dt := nvl(p_lf_evt_ocrd_dt, p_effective_date);
708: if ben_manage_life_events.fonm = 'Y'
709: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
710: --
711: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
712: l_lf_evt_ocrd_dt := nvl(l_fonm_cvg_strt_dt,l_lf_evt_ocrd_dt ) ;
713:
707: l_lf_evt_ocrd_dt := nvl(p_lf_evt_ocrd_dt, p_effective_date);
708: if ben_manage_life_events.fonm = 'Y'
709: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
710: --
711: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
712: l_lf_evt_ocrd_dt := nvl(l_fonm_cvg_strt_dt,l_lf_evt_ocrd_dt ) ;
713:
714: --
715: hr_utility.set_location ('Fonm Date '||l_lf_evt_ocrd_dt ,10);