Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_ELIG_OTHR_PTIP_PRTE |
SELECT EOY.ELIG_OTHR_PTIP_PRTE_ID
, EOY.EFFECTIVE_START_DATE
, EOY.EFFECTIVE_END_DATE
, EOY.EXCLD_FLAG
, EOY.ORDR_NUM
, EOY.ONLY_PLS_SUBJ_COBRA_FLAG
, EOY.ELIGY_PRFL_ID
, EOY.PTIP_ID
, EOY.BUSINESS_GROUP_ID
, EOY.EOY_ATTRIBUTE_CATEGORY
, EOY.EOY_ATTRIBUTE1
, EOY.EOY_ATTRIBUTE2
, EOY.EOY_ATTRIBUTE3
, EOY.EOY_ATTRIBUTE4
, EOY.EOY_ATTRIBUTE5
, EOY.EOY_ATTRIBUTE6
, EOY.EOY_ATTRIBUTE7
, EOY.EOY_ATTRIBUTE8
, EOY.EOY_ATTRIBUTE9
, EOY.EOY_ATTRIBUTE10
, EOY.EOY_ATTRIBUTE11
, EOY.EOY_ATTRIBUTE12
, EOY.EOY_ATTRIBUTE13
, EOY.EOY_ATTRIBUTE14
, EOY.EOY_ATTRIBUTE15
, EOY.EOY_ATTRIBUTE16
, EOY.EOY_ATTRIBUTE17
, EOY.EOY_ATTRIBUTE18
, EOY.EOY_ATTRIBUTE19
, EOY.EOY_ATTRIBUTE20
, EOY.EOY_ATTRIBUTE21
, EOY.EOY_ATTRIBUTE22
, EOY.EOY_ATTRIBUTE23
, EOY.EOY_ATTRIBUTE24
, EOY.EOY_ATTRIBUTE25
, EOY.EOY_ATTRIBUTE26
, EOY.EOY_ATTRIBUTE27
, EOY.EOY_ATTRIBUTE28
, EOY.EOY_ATTRIBUTE29
, EOY.EOY_ATTRIBUTE30
, EOY.LAST_UPDATE_DATE
, EOY.LAST_UPDATED_BY
, EOY.LAST_UPDATE_LOGIN
, EOY.CREATED_BY
, EOY.CREATION_DATE
, EOY.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_OTHR_PTIP_PRTE_F EOY
WHERE EOY.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EOY.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))