SELECT s.employee#,
                   paypoint,
                   s.award,
                   REPLACE (street_address, ',') AS Street_address,
                   e.first_name,
                   e.surname,
                   pt.nr_dependants AS Dependents
              FROM substantive s, employee e, peemptax pt
             WHERE     s.employee# = e.employee#
                   AND e.employee# = pt.employee#
                   AND pt.end_date IS NULL
                   AND commence_date =
                          (SELECT MAX (commence_date)
                             FROM substantive
                            WHERE employee# = s.employee#
                                  AND commence_date between to_date(date1,'dd-mon-rrrr') and to_date(date2,'dd-mon-rrrr')))
                               

select from your_view