eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.HXT_HDP_DET_HOURS_WORKED_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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