Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_ELIG_DSBLD_PRTE |
SELECT EDB.ELIG_DSBLD_PRTE_ID
, EDB.DSBLD_CD
, EDB.EFFECTIVE_START_DATE
, EDB.EFFECTIVE_END_DATE
, EDB.EXCLD_FLAG
, EDB.ELIGY_PRFL_ID
, EDB.BUSINESS_GROUP_ID
, EDB.EDB_ATTRIBUTE_CATEGORY
, EDB.EDB_ATTRIBUTE1
, EDB.EDB_ATTRIBUTE2
, EDB.EDB_ATTRIBUTE3
, EDB.EDB_ATTRIBUTE4
, EDB.EDB_ATTRIBUTE5
, EDB.EDB_ATTRIBUTE6
, EDB.EDB_ATTRIBUTE7
, EDB.EDB_ATTRIBUTE8
, EDB.EDB_ATTRIBUTE9
, EDB.EDB_ATTRIBUTE10
, EDB.EDB_ATTRIBUTE11
, EDB.EDB_ATTRIBUTE12
, EDB.EDB_ATTRIBUTE13
, EDB.EDB_ATTRIBUTE14
, EDB.EDB_ATTRIBUTE15
, EDB.EDB_ATTRIBUTE16
, EDB.EDB_ATTRIBUTE17
, EDB.EDB_ATTRIBUTE18
, EDB.EDB_ATTRIBUTE19
, EDB.EDB_ATTRIBUTE20
, EDB.EDB_ATTRIBUTE21
, EDB.EDB_ATTRIBUTE22
, EDB.EDB_ATTRIBUTE23
, EDB.EDB_ATTRIBUTE24
, EDB.EDB_ATTRIBUTE25
, EDB.EDB_ATTRIBUTE26
, EDB.EDB_ATTRIBUTE27
, EDB.EDB_ATTRIBUTE28
, EDB.EDB_ATTRIBUTE29
, EDB.EDB_ATTRIBUTE30
, EDB.LAST_UPDATE_DATE
, EDB.LAST_UPDATED_BY
, EDB.LAST_UPDATE_LOGIN
, EDB.CREATED_BY
, EDB.CREATION_DATE
, EDB.OBJECT_VERSION_NUMBER
, EDB.ORDR_NUM
FROM BEN_ELIG_DSBLD_PRTE_F EDB
WHERE EDB.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EDB.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))