VIEW: APPS.BEN_LOS_RT

Source

View Text - Preformatted

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'))

View Text - HTML Formatted

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'))