APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on FND_DATE

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

875: --RCHASE Bug#Fix - pass PERSON_ID
876: ,p_param1 => 'PERSON_ID'
877: ,p_param1_value => to_char(nvl(p_person_id,-1))
878: ,p_param2 => 'BEN_IV_RT_STRT_DT'
879: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
880: ,p_param3 => 'BEN_IV_CVG_STRT_DT'
881: ,p_param3_value => fnd_date.date_to_canonical(g_fonm_cvg_strt_dt)
882: );
883: --

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

877: ,p_param1_value => to_char(nvl(p_person_id,-1))
878: ,p_param2 => 'BEN_IV_RT_STRT_DT'
879: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
880: ,p_param3 => 'BEN_IV_CVG_STRT_DT'
881: ,p_param3_value => fnd_date.date_to_canonical(g_fonm_cvg_strt_dt)
882: );
883: --
884: IF p_rule_type = 'NUMBER' THEN
885: --

Line 916: fnd_date.canonical_to_date(l_outputs(l_outputs.FIRST).VALUE);

912: --
913: BEGIN
914: --
915: p_ret_date :=
916: fnd_date.canonical_to_date(l_outputs(l_outputs.FIRST).VALUE);
917: p_ret_val := NULL;
918: --
919: EXCEPTION
920: --

Line 2459: fnd_date.canonical_to_date(l_aei_rec.aei_information2);

2455: --
2456: IF l_subtract_date IS NULL THEN
2457: --
2458: l_subtract_date :=
2459: fnd_date.canonical_to_date(l_aei_rec.aei_information2);
2460: --
2461: END IF;
2462: --
2463: ELSE

Line 2466: fnd_date.canonical_to_date(l_aei_rec.aei_information2);

2462: --
2463: ELSE
2464: --
2465: l_subtract_date :=
2466: fnd_date.canonical_to_date(l_aei_rec.aei_information2);
2467: --
2468: END IF;
2469: --
2470: ELSIF p_rec.los_dt_to_use_cd = 'IDOH' THEN

Line 2481: fnd_date.canonical_to_date(l_aei_rec.aei_information13);

2477: --
2478: IF l_subtract_date IS NULL THEN
2479: --
2480: l_subtract_date :=
2481: fnd_date.canonical_to_date(l_aei_rec.aei_information13);
2482: --
2483: END IF;
2484: --
2485: ELSE

Line 2488: fnd_date.canonical_to_date(l_aei_rec.aei_information13);

2484: --
2485: ELSE
2486: --
2487: l_subtract_date :=
2488: fnd_date.canonical_to_date(l_aei_rec.aei_information13);
2489: --
2490: END IF;
2491: --
2492: ELSIF p_rec.los_dt_to_use_cd = 'IOHD' THEN

Line 2497: fnd_date.canonical_to_date(l_aei_rec.aei_information3);

2493: --
2494: -- inherited original hire date
2495: --
2496: l_subtract_date :=
2497: fnd_date.canonical_to_date(l_aei_rec.aei_information3);
2498: --
2499: ELSIF p_rec.los_dt_to_use_cd = 'RL' THEN
2500: --
2501: run_rule(p_formula_id => p_rec.los_dt_to_use_rl