APPS.BEN_ELPRO_CHECK_ELIGIBILITY dependencies on BEN_MANAGE_LIFE_EVENTS

Line 192: if ben_manage_life_events.fonm = 'Y'

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

Line 193: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

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

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

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

Line 453: if ben_manage_life_events.fonm = 'Y'

449: hr_utility.set_location('Entering: '||l_proc, 10);
450: --
451: -- fonm
452: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date) ;
453: if ben_manage_life_events.fonm = 'Y'
454: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
455: --
456: l_effective_date := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,l_effective_date);
457: --

Line 454: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

450: --
451: -- fonm
452: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date) ;
453: if ben_manage_life_events.fonm = 'Y'
454: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
455: --
456: l_effective_date := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,l_effective_date);
457: --
458: END IF;

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

452: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date) ;
453: if ben_manage_life_events.fonm = 'Y'
454: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
455: --
456: l_effective_date := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,l_effective_date);
457: --
458: END IF;
459: hr_utility.set_location('FONM : '||l_effective_date, 10);
460: --