APPS.GHR_SS_ASG_EIT dependencies on FND_DATE

Line 216: fnd_date.canonical_to_date(get_tel_info.aei_information9) >= fnd_date.canonical_to_date(get_tel_info.aei_information5) THEN

212:
213: FOR get_tel_info in c_tel_asg_info
214: LOOP
215: IF get_tel_info.aei_information9 IS NOT NULL AND get_tel_info.aei_information5 IS NOT NULL AND
216: fnd_date.canonical_to_date(get_tel_info.aei_information9) >= fnd_date.canonical_to_date(get_tel_info.aei_information5) THEN
217: hr_utility.set_message(8301, 'GHR_37613_ALL_PROCEDURE_FAIL');
218: hr_utility.raise_error;
219: END IF;
220:

Line 227: fnd_date.canonical_to_date(NVL(get_tel_info.aei_information5,get_tel_info.aei_information6))

223: hr_utility.raise_error;
224: END IF;
225:
226: IF get_tel_info.aei_information6 IS NOT NULL AND
227: fnd_date.canonical_to_date(NVL(get_tel_info.aei_information5,get_tel_info.aei_information6))
228: >= fnd_date.canonical_to_date(get_tel_info.aei_information6) THEN
229: hr_utility.set_message(8301, 'GHR_37699_ALL_PROCEDURE_FAIL');
230: hr_utility.set_message_token('ITEM','Telework Agreement');
231: hr_utility.raise_error;

Line 228: >= fnd_date.canonical_to_date(get_tel_info.aei_information6) THEN

224: END IF;
225:
226: IF get_tel_info.aei_information6 IS NOT NULL AND
227: fnd_date.canonical_to_date(NVL(get_tel_info.aei_information5,get_tel_info.aei_information6))
228: >= fnd_date.canonical_to_date(get_tel_info.aei_information6) THEN
229: hr_utility.set_message(8301, 'GHR_37699_ALL_PROCEDURE_FAIL');
230: hr_utility.set_message_token('ITEM','Telework Agreement');
231: hr_utility.raise_error;
232: END IF;