View: BEN_ACTL_PREM_VRBL_RT_V

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

View Text

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

Columns