APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on FND_DATE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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