Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_ACTL_PREM_VRBL_RT_X |
SELECT APV.ACTL_PREM_VRBL_RT_ID
, APV.EFFECTIVE_START_DATE
, APV.EFFECTIVE_END_DATE
, APV.ACTL_PREM_ID
, APV.VRBL_RT_PRFL_ID
, APV.ORDR_NUM
, APV.BUSINESS_GROUP_ID
, APV.APV_ATTRIBUTE_CATEGORY
, APV.APV_ATTRIBUTE1
, APV.APV_ATTRIBUTE2
, APV.APV_ATTRIBUTE3
, APV.APV_ATTRIBUTE4
, APV.APV_ATTRIBUTE5
, APV.APV_ATTRIBUTE6
, APV.APV_ATTRIBUTE7
, APV.APV_ATTRIBUTE8
, APV.APV_ATTRIBUTE9
, APV.APV_ATTRIBUTE10
, APV.APV_ATTRIBUTE11
, APV.APV_ATTRIBUTE12
, APV.APV_ATTRIBUTE13
, APV.APV_ATTRIBUTE14
, APV.APV_ATTRIBUTE15
, APV.APV_ATTRIBUTE16
, APV.APV_ATTRIBUTE17
, APV.APV_ATTRIBUTE18
, APV.APV_ATTRIBUTE19
, APV.APV_ATTRIBUTE20
, APV.APV_ATTRIBUTE21
, APV.APV_ATTRIBUTE22
, APV.APV_ATTRIBUTE23
, APV.APV_ATTRIBUTE24
, APV.APV_ATTRIBUTE25
, APV.APV_ATTRIBUTE26
, APV.APV_ATTRIBUTE27
, APV.APV_ATTRIBUTE28
, APV.APV_ATTRIBUTE29
, APV.APV_ATTRIBUTE30
, APV.LAST_UPDATE_DATE
, APV.LAST_UPDATED_BY
, APV.LAST_UPDATE_LOGIN
, APV.CREATED_BY
, APV.CREATION_DATE
, APV.OBJECT_VERSION_NUMBER
FROM BEN_ACTL_PREM_VRBL_RT_F APV
WHERE TRUNC(SYSDATE) BETWEEN APV.EFFECTIVE_START_DATE
AND APV.EFFECTIVE_END_DATE