cursor cur_requests is
SELECT request_id, request_date,
       decode (wh_request_info.request_kind,'ÅÏÇÑÉ',[b](SELECT department_name FROM hr_departments WHERE department_id = wh_request_info.request_who_id and rownum = 1)[/b] ,site_name),
       emp_first_name || emp_all_name AS namess
  FROM hr_emp_info, wh_request_info, hr_sites_info
 WHERE (hr_emp_info.emp_id = wh_request_info.emp_id)
   AND (wh_request_info.request_who_id = hr_sites_info.site_id)
   AND request_date = '02/01/2010';

where view.date_column = to_date('15.06.2010', 'dd.mm.yyyy')