From date and todate parameter not working

Hi Team,

I have developed the custom query but while add the From date and Todate parameter in the BI report getting the error unable to get the solution, please help me on this.

Query :

Select LTRIM (initcap(cppnf.title) || ' ')

|| LTRIM (cppnf.first_name || ' ')

|| LTRIM (cppnf.middle_names || ' ')

|| cppnf.last_name CONTACT_NAME,

(select (TRIM (initcap(ppnf.title) || ' ')

|| LTRIM (ppnf.first_name || ' ')

|| LTRIM (ppnf.middle_names || ' ')

|| ppnf.last_name) from per_person_names_f ppnf where ppnf.person_id=papf.person_id

                                               and ppnf.name_type='GLOBAL'

   AND SYSDATE BETWEEN PPNF.EFFECTIVE_START_DATE AND PPNF.EFFECTIVE_END_DATE AND ROWNUM<2) FULL_NAME,