SELECT l.sys_id_emp_ins AS id_employee,
       pi.full_name,
       TRUNC(l.dt_start) AS dt_report,
       CASE
         WHEN (max(l.dt_end) - min(l.dt_start) > 1) then
          '24:00'
         ELSE
          trim(TO_CHAR(TRUNC((MAX(l.dt_end) - MIN(l.dt_start)) * 24), '00')) || ':' ||
          trim(TO_CHAR(ROUND(((MAX(l.dt_end) - MIN(l.dt_start)) * 24 -
                             TRUNC((MAX(l.dt_end) - MIN(l.dt_start)) * 24)) * 60),
                       '00'))
       END AS work_time,
       MIN(l.dt_start) AS work_time_start,
       MAX(l.dt_end) AS work_time_end,
       ROUND((MAX(l.dt_end) - MIN(l.dt_start)) * 24,1)  AS work_time2
  FROM prcore.lsess l
  JOIN prcore.employee emp
    ON emp.id_employee = l.sys_id_emp_ins
  JOIN prcore.part_info pi
    ON pi.id_part_info = emp.id_part_info
 WHERE ((:p1_id_employee IS NULL AND emp.id_org_tree = :p1_id_org_tree) OR
       ':' || :p1_id_employee || ':' LIKE '%:' || l.sys_id_emp_ins || ':%')
   AND dt_start BETWEEN :dt_start AND :dt_end
 GROUP BY l.sys_id_emp_ins, TRUNC(l.dt_start), pi.full_name
 ORDER BY dt_report, full_name