Line 14: and fnd_date.date_to_canonical(cp_report_date)between pei_information7 and pei_information8
10:
11: select 1 from per_people_extra_info pei
12: where pei.information_type = 'PER_US_VISA_DETAILS'
13: and pei.person_id = cp_person_id 14: and fnd_date.date_to_canonical(cp_report_date)between pei_information7 and pei_information8 15: and pei_information9 in ('04','05','06','07','12');
16:
17: l_count_nra varchar2(10);
18: