SELECT DISTINCT paaf.assignment_id, hshwf.date_worked, TO_CHAR (hshwf.date_worked, 'YYYY') YEAR, TO_CHAR (hshwf.date_worked, 'Month') MONTH, papf.employee_number, hshwf.time_in, hshwf.time_out, hshwf.hours, --petf.element_name, (select petf1.element_name from hr.pay_element_types_f petf1 ...