APPS.HR_NL_DAILY_SICK_AND_RECOVERY dependencies on FND_DATE

Line 259: v_effective_date date := fnd_date.string_to_date(p_effective_date,'YYYY/MM/DD HH24:MI:SS');

255: ,p_retcode OUT nocopy varchar2
256: ,p_effective_date IN varchar2
257: ,p_business_group_id IN number) is
258: --
259: v_effective_date date := fnd_date.string_to_date(p_effective_date,'YYYY/MM/DD HH24:MI:SS');
260: --
261: begin
262: --
263: DELETE from per_nl_absence_changes pnac

Line 367: and l_effective_date between fnd_date.canonical_to_date(aei_information1) and

363: select aei.aei_INFORMATION3
364: from per_assignment_extra_info aei
365: where aei.assignment_id = l_assignment_id
366: AND aei_information_category = 'NL_TML'
367: and l_effective_date between fnd_date.canonical_to_date(aei_information1) and
368: NVL(fnd_date.canonical_to_date(aei_information2), to_date('31-12-4712','DD-MM-YYYY'));
369: --
370: l_standby_emp varchar2(10);
371: l_art_4_5 varchar2(10);

Line 368: NVL(fnd_date.canonical_to_date(aei_information2), to_date('31-12-4712','DD-MM-YYYY'));

364: from per_assignment_extra_info aei
365: where aei.assignment_id = l_assignment_id
366: AND aei_information_category = 'NL_TML'
367: and l_effective_date between fnd_date.canonical_to_date(aei_information1) and
368: NVL(fnd_date.canonical_to_date(aei_information2), to_date('31-12-4712','DD-MM-YYYY'));
369: --
370: l_standby_emp varchar2(10);
371: l_art_4_5 varchar2(10);
372: l_art_29 varchar2(10);