View: HXT_HDP_SUM_HOURS_WORKED_V

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

View Text

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

Columns