Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_PRTT_VSTG_X |
SELECT PVS.PRTT_VSTG_ID
, PVS.EFFECTIVE_START_DATE
, PVS.EFFECTIVE_END_DATE
, PVS.BUSINESS_GROUP_ID
, PVS.PCT_VSTD_VAL
, PVS.AGE_MOS_NUM
, PVS.AGE_YRS_NUM
, PVS.LGTH_OF_SVC_YRS_NUM
, PVS.AGE_DET_AS_OF_DT
, PVS.LGTH_OF_SVC_MOS_NUM
, PVS.LGTH_OF_SVC_DET_AS_OF_DT
, PVS.PVS_ATTRIBUTE_CATEGORY
, PVS.PVS_ATTRIBUTE1
, PVS.PVS_ATTRIBUTE2
, PVS.PVS_ATTRIBUTE3
, PVS.PVS_ATTRIBUTE4
, PVS.PVS_ATTRIBUTE5
, PVS.PVS_ATTRIBUTE6
, PVS.PVS_ATTRIBUTE7
, PVS.PVS_ATTRIBUTE8
, PVS.PVS_ATTRIBUTE9
, PVS.PVS_ATTRIBUTE10
, PVS.PVS_ATTRIBUTE11
, PVS.PVS_ATTRIBUTE12
, PVS.PVS_ATTRIBUTE13
, PVS.PVS_ATTRIBUTE14
, PVS.PVS_ATTRIBUTE15
, PVS.PVS_ATTRIBUTE16
, PVS.PVS_ATTRIBUTE17
, PVS.PVS_ATTRIBUTE18
, PVS.PVS_ATTRIBUTE19
, PVS.PVS_ATTRIBUTE20
, PVS.PVS_ATTRIBUTE21
, PVS.PVS_ATTRIBUTE22
, PVS.PVS_ATTRIBUTE23
, PVS.PVS_ATTRIBUTE24
, PVS.PVS_ATTRIBUTE25
, PVS.PVS_ATTRIBUTE26
, PVS.PVS_ATTRIBUTE27
, PVS.PVS_ATTRIBUTE28
, PVS.PVS_ATTRIBUTE29
, PVS.PVS_ATTRIBUTE30
, PVS.LAST_UPDATE_DATE
, PVS.LAST_UPDATED_BY
, PVS.LAST_UPDATE_LOGIN
, PVS.CREATED_BY
, PVS.CREATION_DATE
, PVS.OBJECT_VERSION_NUMBER
FROM BEN_PRTT_VSTG_F PVS
WHERE TRUNC(SYSDATE) BETWEEN PVS.EFFECTIVE_START_DATE
AND PVS.EFFECTIVE_END_DATE