SELECT 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_START_DATE ,EFFECTIVE_END_DATE ,PROJECT_ID ,PREV_WAGE_CODE ,JOB_ID ,EARN_POL_ID ,STATE_NAME ,COUNTY_NAME ,CITY_NAME ,ZIP_CODE ,ATTRIBUTE_CATEGORY ,ATTRIBUTE1 ,ATTRIBUTE2 ,ATTRIBUTE3 ,ATTRIBUTE4 ,ATTRIBUTE5 ,ATTRIBUTE6 ,ATTRIBUTE7 ,ATTRIBUTE8 ,ATTRIBUTE9 ,ATTRIBUTE10 ,ATTRIBUTE11 ,ATTRIBUTE12 ,ATTRIBUTE13 ,ATTRIBUTE14 ,ATTRIBUTE15 ,ATTRIBUTE16 ,ATTRIBUTE17 ,ATTRIBUTE18 ,ATTRIBUTE19 ,ATTRIBUTE20 ,ATTRIBUTE21 ,ATTRIBUTE22 ,ATTRIBUTE23 ,ATTRIBUTE24 ,ATTRIBUTE25 ,ATTRIBUTE26 ,ATTRIBUTE27 ,ATTRIBUTE28 ,ATTRIBUTE29 ,ATTRIBUTE30 ,OBJECT_VERSION_NUMBER ,TIME_BUILDING_BLOCK_ID ,TIME_BUILDING_BLOCK_OVN FROM HXT_SUM_HOURS_WORKED_F WHERE EFFECTIVE_START_DATE <= (SELECT EFFECTIVE_DATE FROM FND_SESSIONS FNDS WHERE FNDS.SESSION_ID = USERENV('SESSIONID')) AND EFFECTIVE_END_DATE >= (SELECT EFFECTIVE_DATE FROM FND_SESSIONS FNDS WHERE FNDS.SESSION_ID = USERENV('SESSIONID'))
SELECT 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_START_DATE
, EFFECTIVE_END_DATE
, PROJECT_ID
, PREV_WAGE_CODE
, JOB_ID
, EARN_POL_ID
, STATE_NAME
, COUNTY_NAME
, CITY_NAME
, ZIP_CODE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
, OBJECT_VERSION_NUMBER
, TIME_BUILDING_BLOCK_ID
, TIME_BUILDING_BLOCK_OVN
FROM HXT_SUM_HOURS_WORKED_F
WHERE EFFECTIVE_START_DATE <= (SELECT EFFECTIVE_DATE
FROM FND_SESSIONS FNDS
WHERE FNDS.SESSION_ID = USERENV('SESSIONID'))
AND EFFECTIVE_END_DATE >= (SELECT EFFECTIVE_DATE
FROM FND_SESSIONS FNDS
WHERE FNDS.SESSION_ID = USERENV('SESSIONID'))
|
|
|