Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_ELIG_COMPTNCY_PRTE |
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.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'))