APPS.PER_US_HR_UTILITY_PKG dependencies on FND_DATE

Line 25: AND fnd_date.date_to_canonical(cp_report_date) BETWEEN pei_information7 AND pei_information8

21: SELECT 0
22: FROM per_people_extra_info pei
23: WHERE pei.person_id = cp_person_id
24: AND pei.information_type = 'PER_US_VISA_DETAILS'
25: AND fnd_date.date_to_canonical(cp_report_date) BETWEEN pei_information7 AND pei_information8
26: AND pei_information9 IN ('04','05','06','07','12');
27:
28: CURSOR csr_ethnic_origin(cp_person_id NUMBER)
29: IS