VIEW: APPS.BEN_ELIG_LBR_MMBR_PRTE

Source

View Text - Preformatted

SELECT ELU.ELIG_LBR_MMBR_PRTE_ID , ELU.EFFECTIVE_START_DATE , ELU.EFFECTIVE_END_DATE , ELU.ELIGY_PRFL_ID , ELU.EXCLD_FLAG , ELU.LBR_MMBR_FLAG , ELU.ORDR_NUM , ELU.BUSINESS_GROUP_ID , ELU.CRITERIA_SCORE , ELU.CRITERIA_WEIGHT , ELU.ELU_ATTRIBUTE_CATEGORY , ELU.ELU_ATTRIBUTE1 , ELU.ELU_ATTRIBUTE2 , ELU.ELU_ATTRIBUTE3 , ELU.ELU_ATTRIBUTE4 , ELU.ELU_ATTRIBUTE5 , ELU.ELU_ATTRIBUTE6 , ELU.ELU_ATTRIBUTE7 , ELU.ELU_ATTRIBUTE8 , ELU.ELU_ATTRIBUTE9 , ELU.ELU_ATTRIBUTE10 , ELU.ELU_ATTRIBUTE11 , ELU.ELU_ATTRIBUTE12 , ELU.ELU_ATTRIBUTE13 , ELU.ELU_ATTRIBUTE14 , ELU.ELU_ATTRIBUTE15 , ELU.ELU_ATTRIBUTE16 , ELU.ELU_ATTRIBUTE17 , ELU.ELU_ATTRIBUTE18 , ELU.ELU_ATTRIBUTE19 , ELU.ELU_ATTRIBUTE20 , ELU.ELU_ATTRIBUTE21 , ELU.ELU_ATTRIBUTE22 , ELU.ELU_ATTRIBUTE23 , ELU.ELU_ATTRIBUTE24 , ELU.ELU_ATTRIBUTE25 , ELU.ELU_ATTRIBUTE26 , ELU.ELU_ATTRIBUTE27 , ELU.ELU_ATTRIBUTE28 , ELU.ELU_ATTRIBUTE29 , ELU.ELU_ATTRIBUTE30 , ELU.LAST_UPDATE_DATE , ELU.LAST_UPDATED_BY , ELU.LAST_UPDATE_LOGIN , ELU.CREATED_BY , ELU.CREATION_DATE , ELU.OBJECT_VERSION_NUMBER FROM BEN_ELIG_LBR_MMBR_PRTE_F ELU WHERE ELU.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid')) AND ELU.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid'))

View Text - HTML Formatted

SELECT ELU.ELIG_LBR_MMBR_PRTE_ID
, ELU.EFFECTIVE_START_DATE
, ELU.EFFECTIVE_END_DATE
, ELU.ELIGY_PRFL_ID
, ELU.EXCLD_FLAG
, ELU.LBR_MMBR_FLAG
, ELU.ORDR_NUM
, ELU.BUSINESS_GROUP_ID
, ELU.CRITERIA_SCORE
, ELU.CRITERIA_WEIGHT
, ELU.ELU_ATTRIBUTE_CATEGORY
, ELU.ELU_ATTRIBUTE1
, ELU.ELU_ATTRIBUTE2
, ELU.ELU_ATTRIBUTE3
, ELU.ELU_ATTRIBUTE4
, ELU.ELU_ATTRIBUTE5
, ELU.ELU_ATTRIBUTE6
, ELU.ELU_ATTRIBUTE7
, ELU.ELU_ATTRIBUTE8
, ELU.ELU_ATTRIBUTE9
, ELU.ELU_ATTRIBUTE10
, ELU.ELU_ATTRIBUTE11
, ELU.ELU_ATTRIBUTE12
, ELU.ELU_ATTRIBUTE13
, ELU.ELU_ATTRIBUTE14
, ELU.ELU_ATTRIBUTE15
, ELU.ELU_ATTRIBUTE16
, ELU.ELU_ATTRIBUTE17
, ELU.ELU_ATTRIBUTE18
, ELU.ELU_ATTRIBUTE19
, ELU.ELU_ATTRIBUTE20
, ELU.ELU_ATTRIBUTE21
, ELU.ELU_ATTRIBUTE22
, ELU.ELU_ATTRIBUTE23
, ELU.ELU_ATTRIBUTE24
, ELU.ELU_ATTRIBUTE25
, ELU.ELU_ATTRIBUTE26
, ELU.ELU_ATTRIBUTE27
, ELU.ELU_ATTRIBUTE28
, ELU.ELU_ATTRIBUTE29
, ELU.ELU_ATTRIBUTE30
, ELU.LAST_UPDATE_DATE
, ELU.LAST_UPDATED_BY
, ELU.LAST_UPDATE_LOGIN
, ELU.CREATED_BY
, ELU.CREATION_DATE
, ELU.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_LBR_MMBR_PRTE_F ELU
WHERE ELU.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND ELU.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))