Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_ELIG_ANTHR_PL_PRTE |
SELECT EOP.ROWID
, EOP.ELIG_ANTHR_PL_PRTE_ID
, EOP.PL_ID
, EOP.EFFECTIVE_START_DATE
, EOP.EFFECTIVE_END_DATE
, EOP.EXCLD_FLAG
, EOP.ELIGY_PRFL_ID
, EOP.BUSINESS_GROUP_ID
, EOP.EOP_ATTRIBUTE_CATEGORY
, EOP.EOP_ATTRIBUTE1
, EOP.EOP_ATTRIBUTE2
, EOP.EOP_ATTRIBUTE3
, EOP.EOP_ATTRIBUTE4
, EOP.EOP_ATTRIBUTE5
, EOP.EOP_ATTRIBUTE6
, EOP.EOP_ATTRIBUTE7
, EOP.EOP_ATTRIBUTE8
, EOP.EOP_ATTRIBUTE9
, EOP.EOP_ATTRIBUTE10
, EOP.EOP_ATTRIBUTE11
, EOP.EOP_ATTRIBUTE12
, EOP.EOP_ATTRIBUTE13
, EOP.EOP_ATTRIBUTE14
, EOP.EOP_ATTRIBUTE15
, EOP.EOP_ATTRIBUTE16
, EOP.EOP_ATTRIBUTE17
, EOP.EOP_ATTRIBUTE18
, EOP.EOP_ATTRIBUTE19
, EOP.EOP_ATTRIBUTE20
, EOP.EOP_ATTRIBUTE21
, EOP.EOP_ATTRIBUTE22
, EOP.EOP_ATTRIBUTE23
, EOP.EOP_ATTRIBUTE24
, EOP.EOP_ATTRIBUTE25
, EOP.EOP_ATTRIBUTE26
, EOP.EOP_ATTRIBUTE27
, EOP.EOP_ATTRIBUTE28
, EOP.EOP_ATTRIBUTE29
, EOP.EOP_ATTRIBUTE30
, EOP.LAST_UPDATE_DATE
, EOP.LAST_UPDATED_BY
, EOP.LAST_UPDATE_LOGIN
, EOP.CREATED_BY
, EOP.CREATION_DATE
, EOP.OBJECT_VERSION_NUMBER
, EOP.ORDR_NUM
FROM BEN_ELIG_ANTHR_PL_PRTE_F EOP
WHERE EOP.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EOP.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))