View: BEN_PRTT_VSTG_V

Product:	BEN - Advanced Benefits
Description:	- Retrofitted
Implementation/DBA Data:	APPS.BEN_PRTT_VSTG_V

View Text

SELECT PVS.ROWID ROW_ID
, 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
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN PVS.EFFECTIVE_START_DATE
AND PVS.EFFECTIVE_END_DATE

Columns