VIEW: APPS.HXT_TIMECARDS

Source

View Text - Preformatted

SELECT ID ,FOR_PERSON_ID ,TIME_PERIOD_ID ,AUTO_GEN_FLAG ,BATCH_ID ,APPROV_PERSON_ID ,APPROVED_TIMESTAMP ,CREATED_BY ,CREATION_DATE ,LAST_UPDATED_BY ,LAST_UPDATE_DATE ,LAST_UPDATE_LOGIN ,PAYROLL_ID ,STATUS ,EFFECTIVE_END_DATE ,EFFECTIVE_START_DATE ,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 FROM HXT_TIMECARDS_F WHERE EFFECTIVE_START_DATE <= (SELECT TRUNC(EFFECTIVE_DATE) FROM FND_SESSIONS FNDS WHERE FNDS.SESSION_ID = USERENV('SESSIONID')) AND EFFECTIVE_END_DATE >= (SELECT TRUNC(EFFECTIVE_DATE) FROM FND_SESSIONS FNDS WHERE FNDS.SESSION_ID = USERENV('SESSIONID'))

View Text - HTML Formatted

SELECT ID
, FOR_PERSON_ID
, TIME_PERIOD_ID
, AUTO_GEN_FLAG
, BATCH_ID
, APPROV_PERSON_ID
, APPROVED_TIMESTAMP
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PAYROLL_ID
, STATUS
, EFFECTIVE_END_DATE
, EFFECTIVE_START_DATE
, 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
FROM HXT_TIMECARDS_F
WHERE EFFECTIVE_START_DATE <= (SELECT TRUNC(EFFECTIVE_DATE)
FROM FND_SESSIONS FNDS
WHERE FNDS.SESSION_ID = USERENV('SESSIONID'))
AND EFFECTIVE_END_DATE >= (SELECT TRUNC(EFFECTIVE_DATE)
FROM FND_SESSIONS FNDS
WHERE FNDS.SESSION_ID = USERENV('SESSIONID'))