Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_ASNT_SET_RT_X |
SELECT ASR.ASNT_SET_RT_ID
, ASR.EFFECTIVE_START_DATE
, ASR.EFFECTIVE_END_DATE
, ASR.VRBL_RT_PRFL_ID
, ASR.ASSIGNMENT_SET_ID
, ASR.ORDR_NUM
, ASR.EXCLD_FLAG
, ASR.BUSINESS_GROUP_ID
, ASR.ASR_ATTRIBUTE_CATEGORY
, ASR.ASR_ATTRIBUTE1
, ASR.ASR_ATTRIBUTE2
, ASR.ASR_ATTRIBUTE3
, ASR.ASR_ATTRIBUTE4
, ASR.ASR_ATTRIBUTE5
, ASR.ASR_ATTRIBUTE6
, ASR.ASR_ATTRIBUTE7
, ASR.ASR_ATTRIBUTE8
, ASR.ASR_ATTRIBUTE9
, ASR.ASR_ATTRIBUTE10
, ASR.ASR_ATTRIBUTE11
, ASR.ASR_ATTRIBUTE12
, ASR.ASR_ATTRIBUTE13
, ASR.ASR_ATTRIBUTE14
, ASR.ASR_ATTRIBUTE15
, ASR.ASR_ATTRIBUTE16
, ASR.ASR_ATTRIBUTE17
, ASR.ASR_ATTRIBUTE18
, ASR.ASR_ATTRIBUTE19
, ASR.ASR_ATTRIBUTE20
, ASR.ASR_ATTRIBUTE21
, ASR.ASR_ATTRIBUTE22
, ASR.ASR_ATTRIBUTE23
, ASR.ASR_ATTRIBUTE24
, ASR.ASR_ATTRIBUTE25
, ASR.ASR_ATTRIBUTE26
, ASR.ASR_ATTRIBUTE27
, ASR.ASR_ATTRIBUTE28
, ASR.ASR_ATTRIBUTE29
, ASR.ASR_ATTRIBUTE30
, ASR.LAST_UPDATE_DATE
, ASR.LAST_UPDATED_BY
, ASR.LAST_UPDATE_LOGIN
, ASR.CREATED_BY
, ASR.CREATION_DATE
, ASR.OBJECT_VERSION_NUMBER
FROM BEN_ASNT_SET_RT_F ASR
WHERE TRUNC(SYSDATE) BETWEEN ASR.EFFECTIVE_START_DATE
AND ASR.EFFECTIVE_END_DATE