View: BEN_SCHEDD_HRS_RT_X

Product:	BEN - Advanced Benefits
Description:	- Retrofitted
Implementation/DBA Data:	APPS.BEN_SCHEDD_HRS_RT_X

View Text

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 TRUNC(SYSDATE) BETWEEN SHR.EFFECTIVE_START_DATE
AND SHR.EFFECTIVE_END_DATE

Columns