SELECT div.division, 
       DEP.department, 
       E.employeecode, 
       E.name empname, 
       DES.designation, 
       i.idate, 
       To_char (Min(i.intime), 'HH:MI:SS AM'), 
       To_char (Max(I.outtime), 'HH:MI:SS AM'), 
       Round(i.btime / 60), 
       e.shift 
FROM   hrm_employees E, 
       hrm_department DEP, 
       hrm_designation DES, 
       hrm_inout i, 
       hrm_division div 
WHERE  E.employeecode = i.employeecode 
       AND DEP.departmentcode = E.departmentcode 
       AND DES.designationcode = E.designationcode 
       AND div.divisioncode = e.divisioncode 
       AND ( div.divisioncode = :p_divcode 
              OR :p_divcode IS NULL ) 
       AND ( i.idate BETWEEN :from_date AND :to_date ) 
       AND des.designationcode NOT IN ( 11, 25 ) 
GROUP  BY div.division, 
          DEP.department, 
          E.employeecode, 
          E.name, 
          DES.designation, 
          i.idate, 
          To_char(i.intime, 'HH:MI:SS AM'), 
          To_char(I.outtime, 'HH:MI:SS AM'), 
          Round(i.btime / 60), 
          e.shift, 
          Trunc(E.employeecode) 
ORDER  BY E.employeecode; 

SELECT COUNT(*)
FROM HRM_INOUT
WHERE idate != trunc(idate);