VIEW: APPS.BEN_ELIG_COMP_LVL_PRTE

Source

View Text - Preformatted

SELECT ECL.ELIG_COMP_LVL_PRTE_ID , ECL.EFFECTIVE_START_DATE , ECL.EFFECTIVE_END_DATE , ECL.BUSINESS_GROUP_ID , ECL.COMP_LVL_FCTR_ID , ECL.ELIGY_PRFL_ID , ECL.EXCLD_FLAG , ECL.ORDR_NUM ,ECL.CRITERIA_SCORE ,ECL.CRITERIA_WEIGHT , ECL.ECL_ATTRIBUTE_CATEGORY , ECL.ECL_ATTRIBUTE1 , ECL.ECL_ATTRIBUTE2 , ECL.ECL_ATTRIBUTE3 , ECL.ECL_ATTRIBUTE4 , ECL.ECL_ATTRIBUTE5 , ECL.ECL_ATTRIBUTE6 , ECL.ECL_ATTRIBUTE7 , ECL.ECL_ATTRIBUTE8 , ECL.ECL_ATTRIBUTE9 , ECL.ECL_ATTRIBUTE10 , ECL.ECL_ATTRIBUTE11 , ECL.ECL_ATTRIBUTE12 , ECL.ECL_ATTRIBUTE13 , ECL.ECL_ATTRIBUTE14 , ECL.ECL_ATTRIBUTE15 , ECL.ECL_ATTRIBUTE16 , ECL.ECL_ATTRIBUTE17 , ECL.ECL_ATTRIBUTE18 , ECL.ECL_ATTRIBUTE19 , ECL.ECL_ATTRIBUTE20 , ECL.ECL_ATTRIBUTE21 , ECL.ECL_ATTRIBUTE22 , ECL.ECL_ATTRIBUTE23 , ECL.ECL_ATTRIBUTE24 , ECL.ECL_ATTRIBUTE25 , ECL.ECL_ATTRIBUTE26 , ECL.ECL_ATTRIBUTE27 , ECL.ECL_ATTRIBUTE28 , ECL.ECL_ATTRIBUTE29 , ECL.ECL_ATTRIBUTE30 , ECL.LAST_UPDATE_DATE , ECL.LAST_UPDATED_BY , ECL.LAST_UPDATE_LOGIN , ECL.CREATED_BY , ECL.CREATION_DATE , ECL.OBJECT_VERSION_NUMBER FROM BEN_ELIG_COMP_LVL_PRTE_F ECL WHERE ECL.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid')) AND ECL.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid'))

View Text - HTML Formatted

SELECT ECL.ELIG_COMP_LVL_PRTE_ID
, ECL.EFFECTIVE_START_DATE
, ECL.EFFECTIVE_END_DATE
, ECL.BUSINESS_GROUP_ID
, ECL.COMP_LVL_FCTR_ID
, ECL.ELIGY_PRFL_ID
, ECL.EXCLD_FLAG
, ECL.ORDR_NUM
, ECL.CRITERIA_SCORE
, ECL.CRITERIA_WEIGHT
, ECL.ECL_ATTRIBUTE_CATEGORY
, ECL.ECL_ATTRIBUTE1
, ECL.ECL_ATTRIBUTE2
, ECL.ECL_ATTRIBUTE3
, ECL.ECL_ATTRIBUTE4
, ECL.ECL_ATTRIBUTE5
, ECL.ECL_ATTRIBUTE6
, ECL.ECL_ATTRIBUTE7
, ECL.ECL_ATTRIBUTE8
, ECL.ECL_ATTRIBUTE9
, ECL.ECL_ATTRIBUTE10
, ECL.ECL_ATTRIBUTE11
, ECL.ECL_ATTRIBUTE12
, ECL.ECL_ATTRIBUTE13
, ECL.ECL_ATTRIBUTE14
, ECL.ECL_ATTRIBUTE15
, ECL.ECL_ATTRIBUTE16
, ECL.ECL_ATTRIBUTE17
, ECL.ECL_ATTRIBUTE18
, ECL.ECL_ATTRIBUTE19
, ECL.ECL_ATTRIBUTE20
, ECL.ECL_ATTRIBUTE21
, ECL.ECL_ATTRIBUTE22
, ECL.ECL_ATTRIBUTE23
, ECL.ECL_ATTRIBUTE24
, ECL.ECL_ATTRIBUTE25
, ECL.ECL_ATTRIBUTE26
, ECL.ECL_ATTRIBUTE27
, ECL.ECL_ATTRIBUTE28
, ECL.ECL_ATTRIBUTE29
, ECL.ECL_ATTRIBUTE30
, ECL.LAST_UPDATE_DATE
, ECL.LAST_UPDATED_BY
, ECL.LAST_UPDATE_LOGIN
, ECL.CREATED_BY
, ECL.CREATION_DATE
, ECL.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_COMP_LVL_PRTE_F ECL
WHERE ECL.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND ECL.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))