APPS.BEN_DET_WAIT_PERD_CMPLTN dependencies on FND_DATE

Line 19: old cache routine. Added fnd_date.canonical

15: 115.1 14-Jun-99 Tmathers Fixed P1 nls to_date errors.
16: 115.2 23-JUN-98 G PERRY Performance fixes.
17: 115.3 20-JUL-99 Gperry genutils -> benutils package rename.
18: 115.4 10-AUG-99 Gperry Removed reference to ben_manage_life_events
19: old cache routine. Added fnd_date.canonical
20: _to_date for formula calls.
21: 115.5 26-AUG-99 Gperry Added call to benefits assignment cache when
22: employee assignment can not be found.
23: 115.6 18-JAN-00 pbodla Fixed bug 4146(WWBUG 1120687)

Line 238: l_adj_svc_dt := fnd_date.canonical_to_date(l_aei_rec.aei_information2);

234: --
235: ben_person_object.get_object(p_assignment_id => l_ass_rec.assignment_id,
236: p_rec => l_aei_rec);
237: --
238: l_adj_svc_dt := fnd_date.canonical_to_date(l_aei_rec.aei_information2);
239: l_orig_hire_dt := fnd_date.canonical_to_date(l_aei_rec.aei_information3);
240: --
241: -- Get the appropriate date based osn the date code passed in.
242: --

Line 239: l_orig_hire_dt := fnd_date.canonical_to_date(l_aei_rec.aei_information3);

235: ben_person_object.get_object(p_assignment_id => l_ass_rec.assignment_id,
236: p_rec => l_aei_rec);
237: --
238: l_adj_svc_dt := fnd_date.canonical_to_date(l_aei_rec.aei_information2);
239: l_orig_hire_dt := fnd_date.canonical_to_date(l_aei_rec.aei_information3);
240: --
241: -- Get the appropriate date based osn the date code passed in.
242: --
243: if p_date_code = 'OSD' then

Line 415: l_wait_st_date := fnd_date.canonical_to_date

411: -- Now we have executed the formula. We want to assign the output to
412: -- l_date_from
413: --
414: begin
415: l_wait_st_date := fnd_date.canonical_to_date
416: (l_outputs(l_outputs.first).value);
417: exception
418: when others then
419: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');