View: BEN_WK_LOC_RT_V

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

View Text

SELECT WLR.ROWID ROW_ID
, WLR.WK_LOC_RT_ID
, WLR.EFFECTIVE_START_DATE
, WLR.EFFECTIVE_END_DATE
, WLR.BUSINESS_GROUP_ID
, WLR.VRBL_RT_PRFL_ID
, WLR.LOCATION_ID
, WLR.EXCLD_FLAG
, WLR.ORDR_NUM
, WLR.WLR_ATTRIBUTE_CATEGORY
, WLR.WLR_ATTRIBUTE1
, WLR.WLR_ATTRIBUTE2
, WLR.WLR_ATTRIBUTE3
, WLR.WLR_ATTRIBUTE4
, WLR.WLR_ATTRIBUTE5
, WLR.WLR_ATTRIBUTE6
, WLR.WLR_ATTRIBUTE7
, WLR.WLR_ATTRIBUTE8
, WLR.WLR_ATTRIBUTE9
, WLR.WLR_ATTRIBUTE10
, WLR.WLR_ATTRIBUTE11
, WLR.WLR_ATTRIBUTE12
, WLR.WLR_ATTRIBUTE13
, WLR.WLR_ATTRIBUTE14
, WLR.WLR_ATTRIBUTE15
, WLR.WLR_ATTRIBUTE16
, WLR.WLR_ATTRIBUTE17
, WLR.WLR_ATTRIBUTE18
, WLR.WLR_ATTRIBUTE19
, WLR.WLR_ATTRIBUTE20
, WLR.WLR_ATTRIBUTE21
, WLR.WLR_ATTRIBUTE22
, WLR.WLR_ATTRIBUTE23
, WLR.WLR_ATTRIBUTE24
, WLR.WLR_ATTRIBUTE25
, WLR.WLR_ATTRIBUTE26
, WLR.WLR_ATTRIBUTE27
, WLR.WLR_ATTRIBUTE28
, WLR.WLR_ATTRIBUTE29
, WLR.WLR_ATTRIBUTE30
, WLR.LAST_UPDATE_DATE
, WLR.LAST_UPDATED_BY
, WLR.LAST_UPDATE_LOGIN
, WLR.CREATED_BY
, WLR.CREATION_DATE
, WLR.OBJECT_VERSION_NUMBER
FROM BEN_WK_LOC_RT_F WLR
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN WLR.EFFECTIVE_START_DATE
AND WLR.EFFECTIVE_END_DATE

Columns