SELECT SHW.TIM_ID SUM_TIM_ID , SHW.DATE_WORKED SUM_DATE , NVL(SUM(SHW.HOURS) , 0) SUM_HOURS FROM HXT_SUM_HOURS_WORKED SHW WHERE EXISTS (SELECT 1 FROM HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV , PAY_ELEMENT_TYPES_F ELT , HXT_DET_HOURS_WORKED DHW WHERE DHW.PARENT_ID = SHW.ID AND ELT.ELEMENT_TYPE_ID = DHW.ELEMENT_TYPE_ID AND DHW.DATE_WORKED BETWEEN ELT.EFFECTIVE_START_DATE AND ELT.EFFECTIVE_END_DATE AND ELTV.ELEMENT_TYPE_ID = ELT.ELEMENT_TYPE_ID AND DHW.DATE_WORKED BETWEEN ELTV.EFFECTIVE_START_DATE AND ELTV.EFFECTIVE_END_DATE AND ELTV.HXT_EARNING_CATEGORY IN ('REG' , 'OVT')) GROUP BY SHW.TIM_ID , SHW.DATE_WORKED