APPS.BEN_ELPRO_CHECK_ELIGIBILITY dependencies on BEN_MANAGE_LIFE_EVENTS

Line 193: if ben_manage_life_events.fonm = 'Y'

189: --
190: -- Getting eligibility profile compensation level by eligibility profile
191: -- fonm
192: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date) ;
193: if ben_manage_life_events.fonm = 'Y'
194: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
195: --
196: l_effective_date := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,l_effective_date);
197: --

Line 194: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

190: -- Getting eligibility profile compensation level by eligibility profile
191: -- fonm
192: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date) ;
193: if ben_manage_life_events.fonm = 'Y'
194: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
195: --
196: l_effective_date := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,l_effective_date);
197: --
198: END IF;

Line 196: l_effective_date := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,l_effective_date);

192: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date) ;
193: if ben_manage_life_events.fonm = 'Y'
194: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
195: --
196: l_effective_date := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,l_effective_date);
197: --
198: END IF;
199:
200: hr_utility.set_location('FONM : '||l_effective_date, 10);

Line 440: if ben_manage_life_events.fonm = 'Y'

436: hr_utility.set_location('Entering: '||l_proc, 10);
437: --
438: -- fonm
439: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date) ;
440: if ben_manage_life_events.fonm = 'Y'
441: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
442: --
443: l_effective_date := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,l_effective_date);
444: --

Line 441: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

437: --
438: -- fonm
439: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date) ;
440: if ben_manage_life_events.fonm = 'Y'
441: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
442: --
443: l_effective_date := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,l_effective_date);
444: --
445: END IF;

Line 443: l_effective_date := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,l_effective_date);

439: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date) ;
440: if ben_manage_life_events.fonm = 'Y'
441: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
442: --
443: l_effective_date := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,l_effective_date);
444: --
445: END IF;
446: hr_utility.set_location('FONM : '||l_effective_date, 10);
447: --