=
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
]]>