Product: | HXT - Time and Labor |
---|---|
Description: | |
Implementation/DBA Data: | APPS.HXT_DET_HOURS_WORKED_X |
SELECT ID
, PARENT_ID
, LINE_STATUS
, TIM_ID
, DATE_WORKED
, ASSIGNMENT_ID
, HOURS
, TIME_IN
, TIME_OUT
, ELEMENT_TYPE_ID
, FCL_EARN_REASON_CODE
, FFV_COST_CENTER_ID
, FFV_LABOR_ACCOUNT_ID
, TAS_ID
, LOCATION_ID
, SHT_ID
, HRW_COMMENT
, FFV_RATE_CODE_ID
, RATE_MULTIPLE
, HOURLY_RATE
, AMOUNT
, FCL_TAX_RULE_CODE
, SEPARATE_CHECK_FLAG
, SEQNO
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ACTUAL_TIME_IN
, ACTUAL_TIME_OUT
, EFFECTIVE_END_DATE
, EFFECTIVE_START_DATE
, JOB_ID
, EARN_POL_ID
, PREV_WAGE_CODE
, PROJECT_ID
, RETRO_PBL_LINE_ID
, PBL_LINE_ID
, RETRO_BATCH_ID
, PAY_STATUS
, PA_STATUS
, STATE_NAME
, COUNTY_NAME
, CITY_NAME
, ZIP_CODE
, OBJECT_VERSION_NUMBER
FROM HXT_DET_HOURS_WORKED_F
WHERE EFFECTIVE_START_DATE <= TRUNC(SYSDATE)
AND EFFECTIVE_END_DATE >= TRUNC(SYSDATE)