Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_EE_STAT_RT_X |
SELECT ESR.EE_STAT_RT_ID
, ESR.EFFECTIVE_START_DATE
, ESR.EFFECTIVE_END_DATE
, ESR.VRBL_RT_PRFL_ID
, ESR.ASSIGNMENT_STATUS_TYPE_ID
, ESR.EXCLD_FLAG
, ESR.ORDR_NUM
, ESR.BUSINESS_GROUP_ID
, ESR.ESR_ATTRIBUTE_CATEGORY
, ESR.ESR_ATTRIBUTE1
, ESR.ESR_ATTRIBUTE2
, ESR.ESR_ATTRIBUTE3
, ESR.ESR_ATTRIBUTE4
, ESR.ESR_ATTRIBUTE5
, ESR.ESR_ATTRIBUTE6
, ESR.ESR_ATTRIBUTE7
, ESR.ESR_ATTRIBUTE8
, ESR.ESR_ATTRIBUTE9
, ESR.ESR_ATTRIBUTE10
, ESR.ESR_ATTRIBUTE11
, ESR.ESR_ATTRIBUTE12
, ESR.ESR_ATTRIBUTE13
, ESR.ESR_ATTRIBUTE14
, ESR.ESR_ATTRIBUTE15
, ESR.ESR_ATTRIBUTE16
, ESR.ESR_ATTRIBUTE17
, ESR.ESR_ATTRIBUTE18
, ESR.ESR_ATTRIBUTE19
, ESR.ESR_ATTRIBUTE20
, ESR.ESR_ATTRIBUTE21
, ESR.ESR_ATTRIBUTE22
, ESR.ESR_ATTRIBUTE23
, ESR.ESR_ATTRIBUTE24
, ESR.ESR_ATTRIBUTE25
, ESR.ESR_ATTRIBUTE26
, ESR.ESR_ATTRIBUTE27
, ESR.ESR_ATTRIBUTE28
, ESR.ESR_ATTRIBUTE29
, ESR.ESR_ATTRIBUTE30
, ESR.LAST_UPDATE_DATE
, ESR.LAST_UPDATED_BY
, ESR.LAST_UPDATE_LOGIN
, ESR.CREATED_BY
, ESR.CREATION_DATE
, ESR.OBJECT_VERSION_NUMBER
FROM BEN_EE_STAT_RT_F ESR
WHERE TRUNC(SYSDATE) BETWEEN ESR.EFFECTIVE_START_DATE
AND ESR.EFFECTIVE_END_DATE