VIEW: APPS.BEN_LEE_RSN_RL

Source

View Text - Preformatted

SELECT LRR.LEE_RSN_RL_ID , LRR.EFFECTIVE_START_DATE , LRR.EFFECTIVE_END_DATE , LRR.BUSINESS_GROUP_ID , LRR.FORMULA_ID , LRR.ORDR_TO_APLY_NUM , LRR.LEE_RSN_ID , LRR.LRR_ATTRIBUTE_CATEGORY , LRR.LRR_ATTRIBUTE1 , LRR.LRR_ATTRIBUTE2 , LRR.LRR_ATTRIBUTE3 , LRR.LRR_ATTRIBUTE4 , LRR.LRR_ATTRIBUTE5 , LRR.LRR_ATTRIBUTE6 , LRR.LRR_ATTRIBUTE7 , LRR.LRR_ATTRIBUTE8 , LRR.LRR_ATTRIBUTE9 , LRR.LRR_ATTRIBUTE10 , LRR.LRR_ATTRIBUTE11 , LRR.LRR_ATTRIBUTE12 , LRR.LRR_ATTRIBUTE13 , LRR.LRR_ATTRIBUTE14 , LRR.LRR_ATTRIBUTE15 , LRR.LRR_ATTRIBUTE16 , LRR.LRR_ATTRIBUTE17 , LRR.LRR_ATTRIBUTE18 , LRR.LRR_ATTRIBUTE19 , LRR.LRR_ATTRIBUTE20 , LRR.LRR_ATTRIBUTE21 , LRR.LRR_ATTRIBUTE22 , LRR.LRR_ATTRIBUTE23 , LRR.LRR_ATTRIBUTE24 , LRR.LRR_ATTRIBUTE25 , LRR.LRR_ATTRIBUTE26 , LRR.LRR_ATTRIBUTE27 , LRR.LRR_ATTRIBUTE28 , LRR.LRR_ATTRIBUTE29 , LRR.LRR_ATTRIBUTE30 , LRR.LAST_UPDATE_DATE , LRR.LAST_UPDATED_BY , LRR.LAST_UPDATE_LOGIN , LRR.CREATED_BY , LRR.CREATION_DATE , LRR.OBJECT_VERSION_NUMBER FROM BEN_LEE_RSN_RL_F LRR WHERE LRR.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid')) AND LRR.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid'))

View Text - HTML Formatted

SELECT LRR.LEE_RSN_RL_ID
, LRR.EFFECTIVE_START_DATE
, LRR.EFFECTIVE_END_DATE
, LRR.BUSINESS_GROUP_ID
, LRR.FORMULA_ID
, LRR.ORDR_TO_APLY_NUM
, LRR.LEE_RSN_ID
, LRR.LRR_ATTRIBUTE_CATEGORY
, LRR.LRR_ATTRIBUTE1
, LRR.LRR_ATTRIBUTE2
, LRR.LRR_ATTRIBUTE3
, LRR.LRR_ATTRIBUTE4
, LRR.LRR_ATTRIBUTE5
, LRR.LRR_ATTRIBUTE6
, LRR.LRR_ATTRIBUTE7
, LRR.LRR_ATTRIBUTE8
, LRR.LRR_ATTRIBUTE9
, LRR.LRR_ATTRIBUTE10
, LRR.LRR_ATTRIBUTE11
, LRR.LRR_ATTRIBUTE12
, LRR.LRR_ATTRIBUTE13
, LRR.LRR_ATTRIBUTE14
, LRR.LRR_ATTRIBUTE15
, LRR.LRR_ATTRIBUTE16
, LRR.LRR_ATTRIBUTE17
, LRR.LRR_ATTRIBUTE18
, LRR.LRR_ATTRIBUTE19
, LRR.LRR_ATTRIBUTE20
, LRR.LRR_ATTRIBUTE21
, LRR.LRR_ATTRIBUTE22
, LRR.LRR_ATTRIBUTE23
, LRR.LRR_ATTRIBUTE24
, LRR.LRR_ATTRIBUTE25
, LRR.LRR_ATTRIBUTE26
, LRR.LRR_ATTRIBUTE27
, LRR.LRR_ATTRIBUTE28
, LRR.LRR_ATTRIBUTE29
, LRR.LRR_ATTRIBUTE30
, LRR.LAST_UPDATE_DATE
, LRR.LAST_UPDATED_BY
, LRR.LAST_UPDATE_LOGIN
, LRR.CREATED_BY
, LRR.CREATION_DATE
, LRR.OBJECT_VERSION_NUMBER
FROM BEN_LEE_RSN_RL_F LRR
WHERE LRR.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND LRR.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))