[Home] [Help]
View: HXC_TIMECARD_HOURS_V
View Text
SELECT TIME_BUILDING_BLOCK_ID
, OBJECT_VERSION_NUMBER
, HXC_TIME_CATEGORY_UTILS_PKG.CATEGORY_TIMECARD_HRS_IND(TIME_BUILDING_BLOCK_ID
, OBJECT_VERSION_NUMBER
, 'TOTAL1')
, HXC_TIME_CATEGORY_UTILS_PKG.CATEGORY_TIMECARD_HRS_IND(TIME_BUILDING_BLOCK_ID
, OBJECT_VERSION_NUMBER
, 'TOTAL2')
, HXC_TIME_CATEGORY_UTILS_PKG.CATEGORY_TIMECARD_HRS_IND(TIME_BUILDING_BLOCK_ID
, OBJECT_VERSION_NUMBER
, 'TOTAL3')
, HXC_TIME_CATEGORY_UTILS_PKG.CATEGORY_TIMECARD_HRS_IND(TIME_BUILDING_BLOCK_ID
, OBJECT_VERSION_NUMBER
, NULL)
FROM HXC_TIME_BUILDING_BLOCKS HTB
Columns
Name |
TIMECARD_ID |
TIMECARD_OVN |
REGULAR_HOURS |
PREMIUM_HOURS |
NON_WORKED_HOURS |
TOTAL_HOURS |