DBA Data[Home] [Help]

APPS.BEN_EVALUATE_RATE_PROFILES dependencies on FND_DATE

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

454: ,p_param1 => 'BEN_VPF_I_VRBL_RT_PRFL_ID'
455: ,p_param1_value => to_char(nvl(p_vrbl_rt_prfl_id, -1))
456: -- FONM
457: ,p_param2 => 'BEN_IV_RT_STRT_DT'
458: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
459: ,p_param3 => 'BEN_IV_CVG_STRT_DT'
460: ,p_param3_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt)
461: );
462: -- if the profile is AND and one of the rule fails #2508757

Line 460: ,p_param3_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt)

456: -- FONM
457: ,p_param2 => 'BEN_IV_RT_STRT_DT'
458: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
459: ,p_param3 => 'BEN_IV_CVG_STRT_DT'
460: ,p_param3_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt)
461: );
462: -- if the profile is AND and one of the rule fails #2508757
463: if nvl(l_ben_vapro_rul_cond,'A') = 'A' then
464:

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

1374: (p_formula_id => l_inst_dets(l_count).formula_id,
1375: p_assignment_id => l_ass_rec.assignment_id,
1376: p_effective_date => nvl(p_lf_evt_ocrd_dt, p_effective_date), -- FONM
1377: p_param1 => 'BEN_IV_RT_STRT_DT',
1378: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1379: p_param2 => 'BEN_IV_CVG_STRT_DT',
1380: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));
1381: --
1382: begin

Line 1380: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));

1376: p_effective_date => nvl(p_lf_evt_ocrd_dt, p_effective_date), -- FONM
1377: p_param1 => 'BEN_IV_RT_STRT_DT',
1378: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1379: p_param2 => 'BEN_IV_CVG_STRT_DT',
1380: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));
1381: --
1382: begin
1383: --
1384: if l_outputs(l_outputs.first).name = 'INCLUDE_FLAG' then

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

2458: ,p_opt_id => p_opt_id
2459: ,p_ler_id => p_ler_id
2460: ,p_jurisdiction_code => p_jurisdiction_code -- FONM
2461: ,p_param1 => 'BEN_IV_RT_STRT_DT'
2462: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
2463: ,p_param2 => 'BEN_IV_CVG_STRT_DT'
2464: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));
2465:
2466: --

Line 2464: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));

2460: ,p_jurisdiction_code => p_jurisdiction_code -- FONM
2461: ,p_param1 => 'BEN_IV_RT_STRT_DT'
2462: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
2463: ,p_param2 => 'BEN_IV_CVG_STRT_DT'
2464: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));
2465:
2466: --
2467: for l_count in l_output.first..l_output.last loop
2468: --