Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_SCHEDD_HRS_RT_V |
SELECT SHR.ROWID ROW_ID
, 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
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN SHR.EFFECTIVE_START_DATE
AND SHR.EFFECTIVE_END_DATE