VIEW: APPS.BEN_ELIG_COMPTNCY_PRTE

Source

View Text - Preformatted

SELECT ECY.ROWID, ECY.ELIG_COMPTNCY_PRTE_ID , ECY.EFFECTIVE_START_DATE , ECY.EFFECTIVE_END_DATE , ECY.ORDR_NUM , ECY.EXCLD_FLAG , ECY.COMPETENCE_ID , ECY.RATING_LEVEL_ID , ECY.ELIGY_PRFL_ID , ECY.BUSINESS_GROUP_ID , ECY.OBJECT_VERSION_NUMBER , ECY.CRITERIA_SCORE, ECY.CRITERIA_WEIGHT, ECY.ECY_ATTRIBUTE_CATEGORY , ECY.ECY_ATTRIBUTE1 , ECY.ECY_ATTRIBUTE2 , ECY.ECY_ATTRIBUTE3 , ECY.ECY_ATTRIBUTE4 , ECY.ECY_ATTRIBUTE5 , ECY.ECY_ATTRIBUTE6 , ECY.ECY_ATTRIBUTE7 , ECY.ECY_ATTRIBUTE8 , ECY.ECY_ATTRIBUTE9 , ECY.ECY_ATTRIBUTE10 , ECY.ECY_ATTRIBUTE11 , ECY.ECY_ATTRIBUTE12 , ECY.ECY_ATTRIBUTE13 , ECY.ECY_ATTRIBUTE14 , ECY.ECY_ATTRIBUTE15 , ECY.ECY_ATTRIBUTE16 , ECY.ECY_ATTRIBUTE17 , ECY.ECY_ATTRIBUTE18 , ECY.ECY_ATTRIBUTE19 , ECY.ECY_ATTRIBUTE20 , ECY.ECY_ATTRIBUTE21 , ECY.ECY_ATTRIBUTE22 , ECY.ECY_ATTRIBUTE23 , ECY.ECY_ATTRIBUTE24 , ECY.ECY_ATTRIBUTE25 , ECY.ECY_ATTRIBUTE26 , ECY.ECY_ATTRIBUTE27 , ECY.ECY_ATTRIBUTE28 , ECY.ECY_ATTRIBUTE29 , ECY.ECY_ATTRIBUTE30 , ECY.LAST_UPDATE_DATE , ECY.LAST_UPDATED_BY , ECY.LAST_UPDATE_LOGIN , ECY.CREATED_BY , ECY.CREATION_DATE FROM BEN_ELIG_COMPTNCY_PRTE_F ECY WHERE ECY.effective_start_date <= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid')) and ECY.effective_end_date >= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid'))

View Text - HTML Formatted

SELECT ECY.ROWID
, ECY.ELIG_COMPTNCY_PRTE_ID
, ECY.EFFECTIVE_START_DATE
, ECY.EFFECTIVE_END_DATE
, ECY.ORDR_NUM
, ECY.EXCLD_FLAG
, ECY.COMPETENCE_ID
, ECY.RATING_LEVEL_ID
, ECY.ELIGY_PRFL_ID
, ECY.BUSINESS_GROUP_ID
, ECY.OBJECT_VERSION_NUMBER
, ECY.CRITERIA_SCORE
, ECY.CRITERIA_WEIGHT
, ECY.ECY_ATTRIBUTE_CATEGORY
, ECY.ECY_ATTRIBUTE1
, ECY.ECY_ATTRIBUTE2
, ECY.ECY_ATTRIBUTE3
, ECY.ECY_ATTRIBUTE4
, ECY.ECY_ATTRIBUTE5
, ECY.ECY_ATTRIBUTE6
, ECY.ECY_ATTRIBUTE7
, ECY.ECY_ATTRIBUTE8
, ECY.ECY_ATTRIBUTE9
, ECY.ECY_ATTRIBUTE10
, ECY.ECY_ATTRIBUTE11
, ECY.ECY_ATTRIBUTE12
, ECY.ECY_ATTRIBUTE13
, ECY.ECY_ATTRIBUTE14
, ECY.ECY_ATTRIBUTE15
, ECY.ECY_ATTRIBUTE16
, ECY.ECY_ATTRIBUTE17
, ECY.ECY_ATTRIBUTE18
, ECY.ECY_ATTRIBUTE19
, ECY.ECY_ATTRIBUTE20
, ECY.ECY_ATTRIBUTE21
, ECY.ECY_ATTRIBUTE22
, ECY.ECY_ATTRIBUTE23
, ECY.ECY_ATTRIBUTE24
, ECY.ECY_ATTRIBUTE25
, ECY.ECY_ATTRIBUTE26
, ECY.ECY_ATTRIBUTE27
, ECY.ECY_ATTRIBUTE28
, ECY.ECY_ATTRIBUTE29
, ECY.ECY_ATTRIBUTE30
, ECY.LAST_UPDATE_DATE
, ECY.LAST_UPDATED_BY
, ECY.LAST_UPDATE_LOGIN
, ECY.CREATED_BY
, ECY.CREATION_DATE
FROM BEN_ELIG_COMPTNCY_PRTE_F ECY
WHERE ECY.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND ECY.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))