VIEW: APPS.BEN_SCHEDD_HRS_RT

Source

View Text - Preformatted

SELECT SHR.SCHEDD_HRS_RT_ID , SHR.EFFECTIVE_START_DATE , SHR.EFFECTIVE_END_DATE , SHR.VRBL_RT_PRFL_ID , SHR.EXCLD_FLAG , SHR.ORDR_NUM , SHR.FREQ_CD , SHR.HRS_NUM , SHR.BUSINESS_GROUP_ID , SHR.MAX_HRS_NUM , SHR.SCHEDD_HRS_RL , SHR.DETERMINATION_CD , SHR.DETERMINATION_RL , SHR.ROUNDING_CD , SHR.ROUNDING_RL , SHR.SHR_ATTRIBUTE_CATEGORY , SHR.SHR_ATTRIBUTE1 , SHR.SHR_ATTRIBUTE2 , SHR.SHR_ATTRIBUTE3 , SHR.SHR_ATTRIBUTE4 , SHR.SHR_ATTRIBUTE5 , SHR.SHR_ATTRIBUTE6 , SHR.SHR_ATTRIBUTE7 , SHR.SHR_ATTRIBUTE8 , SHR.SHR_ATTRIBUTE9 , SHR.SHR_ATTRIBUTE10 , SHR.SHR_ATTRIBUTE11 , SHR.SHR_ATTRIBUTE12 , SHR.SHR_ATTRIBUTE13 , SHR.SHR_ATTRIBUTE14 , SHR.SHR_ATTRIBUTE15 , SHR.SHR_ATTRIBUTE16 , SHR.SHR_ATTRIBUTE17 , SHR.SHR_ATTRIBUTE18 , SHR.SHR_ATTRIBUTE19 , SHR.SHR_ATTRIBUTE20 , SHR.SHR_ATTRIBUTE21 , SHR.SHR_ATTRIBUTE22 , SHR.SHR_ATTRIBUTE23 , SHR.SHR_ATTRIBUTE24 , SHR.SHR_ATTRIBUTE25 , SHR.SHR_ATTRIBUTE26 , SHR.SHR_ATTRIBUTE27 , SHR.SHR_ATTRIBUTE28 , SHR.SHR_ATTRIBUTE29 , SHR.SHR_ATTRIBUTE30 , SHR.LAST_UPDATE_DATE , SHR.LAST_UPDATED_BY , SHR.LAST_UPDATE_LOGIN , SHR.CREATED_BY , SHR.CREATION_DATE , SHR.OBJECT_VERSION_NUMBER FROM BEN_SCHEDD_HRS_RT_F SHR WHERE SHR.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid')) AND SHR.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid'))

View Text - HTML Formatted

SELECT SHR.SCHEDD_HRS_RT_ID
, SHR.EFFECTIVE_START_DATE
, SHR.EFFECTIVE_END_DATE
, SHR.VRBL_RT_PRFL_ID
, SHR.EXCLD_FLAG
, SHR.ORDR_NUM
, SHR.FREQ_CD
, SHR.HRS_NUM
, SHR.BUSINESS_GROUP_ID
, SHR.MAX_HRS_NUM
, SHR.SCHEDD_HRS_RL
, SHR.DETERMINATION_CD
, SHR.DETERMINATION_RL
, SHR.ROUNDING_CD
, SHR.ROUNDING_RL
, SHR.SHR_ATTRIBUTE_CATEGORY
, SHR.SHR_ATTRIBUTE1
, SHR.SHR_ATTRIBUTE2
, SHR.SHR_ATTRIBUTE3
, SHR.SHR_ATTRIBUTE4
, SHR.SHR_ATTRIBUTE5
, SHR.SHR_ATTRIBUTE6
, SHR.SHR_ATTRIBUTE7
, SHR.SHR_ATTRIBUTE8
, SHR.SHR_ATTRIBUTE9
, SHR.SHR_ATTRIBUTE10
, SHR.SHR_ATTRIBUTE11
, SHR.SHR_ATTRIBUTE12
, SHR.SHR_ATTRIBUTE13
, SHR.SHR_ATTRIBUTE14
, SHR.SHR_ATTRIBUTE15
, SHR.SHR_ATTRIBUTE16
, SHR.SHR_ATTRIBUTE17
, SHR.SHR_ATTRIBUTE18
, SHR.SHR_ATTRIBUTE19
, SHR.SHR_ATTRIBUTE20
, SHR.SHR_ATTRIBUTE21
, SHR.SHR_ATTRIBUTE22
, SHR.SHR_ATTRIBUTE23
, SHR.SHR_ATTRIBUTE24
, SHR.SHR_ATTRIBUTE25
, SHR.SHR_ATTRIBUTE26
, SHR.SHR_ATTRIBUTE27
, SHR.SHR_ATTRIBUTE28
, SHR.SHR_ATTRIBUTE29
, SHR.SHR_ATTRIBUTE30
, SHR.LAST_UPDATE_DATE
, SHR.LAST_UPDATED_BY
, SHR.LAST_UPDATE_LOGIN
, SHR.CREATED_BY
, SHR.CREATION_DATE
, SHR.OBJECT_VERSION_NUMBER
FROM BEN_SCHEDD_HRS_RT_F SHR
WHERE SHR.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND SHR.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))