select a.name, b.monthly_salary, b.created_date
  from a, b
 where a.emp_no = :emp
   and b.emp_no = a.emp_no
   and b.created_date = (select max(created_date)
                           from b b2
                          where b2.emp_no = b.emp_no);