View: HXT_HDP_DET_HOURS_WORKED_V

Product:	HXT - Time and Labor
Description:
Implementation/DBA Data:	APPS.HXT_HDP_DET_HOURS_WORKED_V

View Text

SELECT DHW.TIM_ID DET_TIM_ID
, DHW.DATE_WORKED DET_DATE
, NVL(SUM(DHW.HOURS)
, 0) DET_HOURS
FROM HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV
, PAY_ELEMENT_TYPES_F ELT
, HXT_DET_HOURS_WORKED DHW
WHERE 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 DHW.TIM_ID
, DHW.DATE_WORKED

Columns