select
    emp_code as code,
    emp_last_name as surname,
    emp_first_name as name
from
    emp
where
    valid_flg = 1
    and
    emp_last_name = emp_last_name
    and
    emp_first_name = emp_first_name
order by
    surname asc,
    emp_code asc
;