Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_VSTG_FOR_ACTY_RT_X |
SELECT VRT.VSTG_FOR_ACTY_RT_ID
, VRT.EFFECTIVE_START_DATE
, VRT.EFFECTIVE_END_DATE
, VRT.BUSINESS_GROUP_ID
, VRT.VSTG_SCHED_ID
, VRT.AGE_DET_RL_OVRID_ALWD_FLAG
, VRT.BIS_RL_OVRID_ALWD_FLAG
, VRT.LOS_RL_OVRID_ALWD_FLAG
, VRT.AGE_DET_OVRID_RL
, VRT.BIS_OVRID_RL
, VRT.LOS_OVRID_RL
, VRT.VRT_ATTRIBUTE_CATEGORY
, VRT.VRT_ATTRIBUTE1
, VRT.VRT_ATTRIBUTE2
, VRT.VRT_ATTRIBUTE3
, VRT.VRT_ATTRIBUTE4
, VRT.VRT_ATTRIBUTE5
, VRT.VRT_ATTRIBUTE6
, VRT.VRT_ATTRIBUTE7
, VRT.VRT_ATTRIBUTE8
, VRT.VRT_ATTRIBUTE9
, VRT.VRT_ATTRIBUTE10
, VRT.VRT_ATTRIBUTE11
, VRT.VRT_ATTRIBUTE12
, VRT.VRT_ATTRIBUTE13
, VRT.VRT_ATTRIBUTE14
, VRT.VRT_ATTRIBUTE15
, VRT.VRT_ATTRIBUTE16
, VRT.VRT_ATTRIBUTE17
, VRT.VRT_ATTRIBUTE18
, VRT.VRT_ATTRIBUTE19
, VRT.VRT_ATTRIBUTE20
, VRT.VRT_ATTRIBUTE21
, VRT.VRT_ATTRIBUTE22
, VRT.VRT_ATTRIBUTE23
, VRT.VRT_ATTRIBUTE24
, VRT.VRT_ATTRIBUTE25
, VRT.VRT_ATTRIBUTE26
, VRT.VRT_ATTRIBUTE27
, VRT.VRT_ATTRIBUTE28
, VRT.VRT_ATTRIBUTE29
, VRT.VRT_ATTRIBUTE30
, VRT.LAST_UPDATE_DATE
, VRT.LAST_UPDATED_BY
, VRT.LAST_UPDATE_LOGIN
, VRT.CREATED_BY
, VRT.CREATION_DATE
, VRT.OBJECT_VERSION_NUMBER
FROM BEN_VSTG_FOR_ACTY_RT_F VRT
WHERE TRUNC(SYSDATE) BETWEEN VRT.EFFECTIVE_START_DATE
AND VRT.EFFECTIVE_END_DATE