APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on FND_DATE

Line 2341: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),

2337: p_effective_date => p_effective_date,
2338: p_param1 => 'BEN_ELP_I_ELIGY_PRFL_ID',
2339: p_param1_value => to_char(nvl(p_eligy_prfl_id, -1)),
2340: p_param2 => 'BEN_IV_RT_STRT_DT',
2341: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
2342: p_param3 => 'BEN_IV_CVG_STRT_DT',
2343: p_param3_value => fnd_date.date_to_canonical(l_fonm_cvg_strt_dt),
2344: p_param4 => 'BEN_IV_PERSON_ID', -- Bug 5331889 : Added person_id param as well
2345: p_param4_value => to_char(p_person_id)

Line 2343: p_param3_value => fnd_date.date_to_canonical(l_fonm_cvg_strt_dt),

2339: p_param1_value => to_char(nvl(p_eligy_prfl_id, -1)),
2340: p_param2 => 'BEN_IV_RT_STRT_DT',
2341: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
2342: p_param3 => 'BEN_IV_CVG_STRT_DT',
2343: p_param3_value => fnd_date.date_to_canonical(l_fonm_cvg_strt_dt),
2344: p_param4 => 'BEN_IV_PERSON_ID', -- Bug 5331889 : Added person_id param as well
2345: p_param4_value => to_char(p_person_id)
2346: );
2347:

Line 4224: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)

4220: ,p_pl_typ_id => p_pl_typ_id
4221: ,p_opt_id => p_opt_id
4222: ,p_ler_id => p_ler_id
4223: ,p_param1 => 'BEN_IV_RT_STRT_DT'
4224: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
4225: ,p_param2 => 'BEN_IV_CVG_STRT_DT'
4226: ,p_param2_value => fnd_date.date_to_canonical(l_fonm_cvg_strt_dt)
4227:
4228: ,p_jurisdiction_code => p_jurisdiction_code);

Line 4226: ,p_param2_value => fnd_date.date_to_canonical(l_fonm_cvg_strt_dt)

4222: ,p_ler_id => p_ler_id
4223: ,p_param1 => 'BEN_IV_RT_STRT_DT'
4224: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
4225: ,p_param2 => 'BEN_IV_CVG_STRT_DT'
4226: ,p_param2_value => fnd_date.date_to_canonical(l_fonm_cvg_strt_dt)
4227:
4228: ,p_jurisdiction_code => p_jurisdiction_code);
4229:
4230: --

Line 5594: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),

5590: (p_formula_id => l_inst_dets(l_count).formula_id,
5591: p_assignment_id => l_ass_rec.assignment_id,
5592: p_effective_date => p_effective_date,
5593: p_param1 => 'BEN_IV_RT_STRT_DT',
5594: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
5595: p_param2 => 'BEN_IV_CVG_STRT_DT',
5596: p_param2_value => fnd_date.date_to_canonical(l_fonm_cvg_strt_dt)
5597: );
5598: --

Line 5596: p_param2_value => fnd_date.date_to_canonical(l_fonm_cvg_strt_dt)

5592: p_effective_date => p_effective_date,
5593: p_param1 => 'BEN_IV_RT_STRT_DT',
5594: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
5595: p_param2 => 'BEN_IV_CVG_STRT_DT',
5596: p_param2_value => fnd_date.date_to_canonical(l_fonm_cvg_strt_dt)
5597: );
5598: --
5599: begin
5600: --