APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on FND_DATE

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

2326: p_effective_date => p_effective_date,
2327: p_param1 => 'BEN_ELP_I_ELIGY_PRFL_ID',
2328: p_param1_value => to_char(nvl(p_eligy_prfl_id, -1)),
2329: p_param2 => 'BEN_IV_RT_STRT_DT',
2330: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
2331: p_param3 => 'BEN_IV_CVG_STRT_DT',
2332: p_param3_value => fnd_date.date_to_canonical(l_fonm_cvg_strt_dt),
2333: p_param4 => 'BEN_IV_PERSON_ID', -- Bug 5331889 : Added person_id param as well
2334: p_param4_value => to_char(p_person_id)

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

2328: p_param1_value => to_char(nvl(p_eligy_prfl_id, -1)),
2329: p_param2 => 'BEN_IV_RT_STRT_DT',
2330: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
2331: p_param3 => 'BEN_IV_CVG_STRT_DT',
2332: p_param3_value => fnd_date.date_to_canonical(l_fonm_cvg_strt_dt),
2333: p_param4 => 'BEN_IV_PERSON_ID', -- Bug 5331889 : Added person_id param as well
2334: p_param4_value => to_char(p_person_id)
2335: );
2336:

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

4209: ,p_pl_typ_id => p_pl_typ_id
4210: ,p_opt_id => p_opt_id
4211: ,p_ler_id => p_ler_id
4212: ,p_param1 => 'BEN_IV_RT_STRT_DT'
4213: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
4214: ,p_param2 => 'BEN_IV_CVG_STRT_DT'
4215: ,p_param2_value => fnd_date.date_to_canonical(l_fonm_cvg_strt_dt)
4216:
4217: ,p_jurisdiction_code => p_jurisdiction_code);

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

4211: ,p_ler_id => p_ler_id
4212: ,p_param1 => 'BEN_IV_RT_STRT_DT'
4213: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
4214: ,p_param2 => 'BEN_IV_CVG_STRT_DT'
4215: ,p_param2_value => fnd_date.date_to_canonical(l_fonm_cvg_strt_dt)
4216:
4217: ,p_jurisdiction_code => p_jurisdiction_code);
4218:
4219: --

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

5578: (p_formula_id => l_inst_dets(l_count).formula_id,
5579: p_assignment_id => l_ass_rec.assignment_id,
5580: p_effective_date => p_effective_date,
5581: p_param1 => 'BEN_IV_RT_STRT_DT',
5582: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
5583: p_param2 => 'BEN_IV_CVG_STRT_DT',
5584: p_param2_value => fnd_date.date_to_canonical(l_fonm_cvg_strt_dt)
5585: );
5586: --

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

5580: p_effective_date => p_effective_date,
5581: p_param1 => 'BEN_IV_RT_STRT_DT',
5582: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
5583: p_param2 => 'BEN_IV_CVG_STRT_DT',
5584: p_param2_value => fnd_date.date_to_canonical(l_fonm_cvg_strt_dt)
5585: );
5586: --
5587: begin
5588: --