Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_DSBLD_RT_X |
SELECT DBR.DSBLD_RT_ID
, DBR.DSBLD_CD
, DBR.EFFECTIVE_START_DATE
, DBR.EFFECTIVE_END_DATE
, DBR.ORDR_NUM
, DBR.EXCLD_FLAG
, DBR.VRBL_RT_PRFL_ID
, DBR.BUSINESS_GROUP_ID
, DBR.DBR_ATTRIBUTE_CATEGORY
, DBR.DBR_ATTRIBUTE1
, DBR.DBR_ATTRIBUTE2
, DBR.DBR_ATTRIBUTE3
, DBR.DBR_ATTRIBUTE4
, DBR.DBR_ATTRIBUTE5
, DBR.DBR_ATTRIBUTE6
, DBR.DBR_ATTRIBUTE7
, DBR.DBR_ATTRIBUTE8
, DBR.DBR_ATTRIBUTE9
, DBR.DBR_ATTRIBUTE10
, DBR.DBR_ATTRIBUTE11
, DBR.DBR_ATTRIBUTE12
, DBR.DBR_ATTRIBUTE13
, DBR.DBR_ATTRIBUTE14
, DBR.DBR_ATTRIBUTE15
, DBR.DBR_ATTRIBUTE16
, DBR.DBR_ATTRIBUTE17
, DBR.DBR_ATTRIBUTE18
, DBR.DBR_ATTRIBUTE19
, DBR.DBR_ATTRIBUTE20
, DBR.DBR_ATTRIBUTE21
, DBR.DBR_ATTRIBUTE22
, DBR.DBR_ATTRIBUTE23
, DBR.DBR_ATTRIBUTE24
, DBR.DBR_ATTRIBUTE25
, DBR.DBR_ATTRIBUTE26
, DBR.DBR_ATTRIBUTE27
, DBR.DBR_ATTRIBUTE28
, DBR.DBR_ATTRIBUTE29
, DBR.DBR_ATTRIBUTE30
, DBR.LAST_UPDATE_DATE
, DBR.LAST_UPDATED_BY
, DBR.LAST_UPDATE_LOGIN
, DBR.CREATED_BY
, DBR.CREATION_DATE
, DBR.OBJECT_VERSION_NUMBER
FROM BEN_DSBLD_RT_F DBR
WHERE TRUNC(SYSDATE) BETWEEN DBR.EFFECTIVE_START_DATE
AND DBR.EFFECTIVE_END_DATE