Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_AGE_RT_X |
SELECT ART.AGE_RT_ID
, ART.EFFECTIVE_START_DATE
, ART.EFFECTIVE_END_DATE
, ART.BUSINESS_GROUP_ID
, ART.VRBL_RT_PRFL_ID
, ART.AGE_FCTR_ID
, ART.ORDR_NUM
, ART.EXCLD_FLAG
, ART.ART_ATTRIBUTE_CATEGORY
, ART.ART_ATTRIBUTE1
, ART.ART_ATTRIBUTE2
, ART.ART_ATTRIBUTE3
, ART.ART_ATTRIBUTE4
, ART.ART_ATTRIBUTE5
, ART.ART_ATTRIBUTE6
, ART.ART_ATTRIBUTE7
, ART.ART_ATTRIBUTE8
, ART.ART_ATTRIBUTE9
, ART.ART_ATTRIBUTE10
, ART.ART_ATTRIBUTE11
, ART.ART_ATTRIBUTE12
, ART.ART_ATTRIBUTE13
, ART.ART_ATTRIBUTE14
, ART.ART_ATTRIBUTE15
, ART.ART_ATTRIBUTE16
, ART.ART_ATTRIBUTE17
, ART.ART_ATTRIBUTE18
, ART.ART_ATTRIBUTE19
, ART.ART_ATTRIBUTE20
, ART.ART_ATTRIBUTE21
, ART.ART_ATTRIBUTE22
, ART.ART_ATTRIBUTE23
, ART.ART_ATTRIBUTE24
, ART.ART_ATTRIBUTE25
, ART.ART_ATTRIBUTE26
, ART.ART_ATTRIBUTE27
, ART.ART_ATTRIBUTE28
, ART.ART_ATTRIBUTE29
, ART.ART_ATTRIBUTE30
, ART.LAST_UPDATE_DATE
, ART.LAST_UPDATED_BY
, ART.LAST_UPDATE_LOGIN
, ART.CREATED_BY
, ART.CREATION_DATE
, ART.OBJECT_VERSION_NUMBER
FROM BEN_AGE_RT_F ART
WHERE TRUNC(SYSDATE) BETWEEN ART.EFFECTIVE_START_DATE
AND ART.EFFECTIVE_END_DATE