View: BEN_LOS_RT

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

View Text

SELECT LSR.LOS_RT_ID
, LSR.EFFECTIVE_START_DATE
, LSR.EFFECTIVE_END_DATE
, LSR.BUSINESS_GROUP_ID
, LSR.VRBL_RT_PRFL_ID
, LSR.LOS_FCTR_ID
, LSR.ORDR_NUM
, LSR.EXCLD_FLAG
, LSR.LSR_ATTRIBUTE_CATEGORY
, LSR.LSR_ATTRIBUTE1
, LSR.LSR_ATTRIBUTE2
, LSR.LSR_ATTRIBUTE3
, LSR.LSR_ATTRIBUTE4
, LSR.LSR_ATTRIBUTE5
, LSR.LSR_ATTRIBUTE6
, LSR.LSR_ATTRIBUTE7
, LSR.LSR_ATTRIBUTE8
, LSR.LSR_ATTRIBUTE9
, LSR.LSR_ATTRIBUTE10
, LSR.LSR_ATTRIBUTE11
, LSR.LSR_ATTRIBUTE12
, LSR.LSR_ATTRIBUTE13
, LSR.LSR_ATTRIBUTE14
, LSR.LSR_ATTRIBUTE15
, LSR.LSR_ATTRIBUTE16
, LSR.LSR_ATTRIBUTE17
, LSR.LSR_ATTRIBUTE18
, LSR.LSR_ATTRIBUTE19
, LSR.LSR_ATTRIBUTE20
, LSR.LSR_ATTRIBUTE21
, LSR.LSR_ATTRIBUTE22
, LSR.LSR_ATTRIBUTE23
, LSR.LSR_ATTRIBUTE24
, LSR.LSR_ATTRIBUTE25
, LSR.LSR_ATTRIBUTE26
, LSR.LSR_ATTRIBUTE27
, LSR.LSR_ATTRIBUTE28
, LSR.LSR_ATTRIBUTE29
, LSR.LSR_ATTRIBUTE30
, LSR.LAST_UPDATE_DATE
, LSR.LAST_UPDATED_BY
, LSR.LAST_UPDATE_LOGIN
, LSR.CREATED_BY
, LSR.CREATION_DATE
, LSR.OBJECT_VERSION_NUMBER
FROM BEN_LOS_RT_F LSR
WHERE LSR.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND LSR.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns