= to_date(nvl(?{reviewStartFrom}, '01/01/2000'), 'mm/dd/yyyy') and fd.FORM_DATA_REVIEWSTART < nvl(TO_DATE(?{reviewStartTo}, 'mm/dd/yyyy'), ADD_MONTHS(SYSDATE, 60)) + 1 and fd.FORM_DATA_REVIEWEND >= to_date(nvl(?{reviewEndFrom}, '01/01/2000'), 'mm/dd/yyyy') and fd.FORM_DATA_REVIEWEND < nvl(TO_DATE(?{reviewEndTo}, 'mm/dd/yyyy'), ADD_MONTHS(SYSDATE, 60)) + 1 and fd.FORM_DATA_DUEDATE >= to_date(nvl(?{reviewDueFrom}, '01/01/2000'), 'mm/dd/yyyy') and fd.FORM_DATA_DUEDATE < nvl(TO_DATE(?{reviewDueTo}, 'mm/dd/yyyy'), ADD_MONTHS(SYSDATE, 60)) + 1 and u.USERS_SYS_DIVISION in (?{selectedDiv}) and u.USERS_SYS_DEPARTMENT in (?{selectedDept}) and u.USERS_SYS_LOCATION in (?{selectedLoc}) and ( ( SELECT count(*) FROM change_on_setup.usrgrp_map ugmap, change_on_setup.grpperm_map gpmap, change_on_setup.permission perm WHERE ugmap.users_sys_id = '${whoami}' AND ugmap.users_group_id = gpmap.users_group_id AND gpmap.permission_id = perm.permission_id AND perm.permission_type = 'report' AND perm.permisSion_string_value = 'detail_report_hr' ) > 0 OR (u.USERS_SYS_HRUID = '${whoami}') ) and ('yes' <> ?{activeUsersOnly} OR u.USERS_SYS_VALID = 't') order by ft.form_template_name, fd.form_data_title, fd.form_data_id, re.step_order, re.step_last_routed ]]>