Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_ELIG_AGE_PRTE |
SELECT EAP.ELIG_AGE_PRTE_ID
, EAP.EFFECTIVE_START_DATE
, EAP.EFFECTIVE_END_DATE
, EAP.BUSINESS_GROUP_ID
, EAP.AGE_FCTR_ID
, EAP.ELIGY_PRFL_ID
, EAP.ORDR_NUM
, EAP.EXCLD_FLAG
, EAP.EAP_ATTRIBUTE_CATEGORY
, EAP.EAP_ATTRIBUTE1
, EAP.EAP_ATTRIBUTE2
, EAP.EAP_ATTRIBUTE3
, EAP.EAP_ATTRIBUTE4
, EAP.EAP_ATTRIBUTE5
, EAP.EAP_ATTRIBUTE6
, EAP.EAP_ATTRIBUTE7
, EAP.EAP_ATTRIBUTE8
, EAP.EAP_ATTRIBUTE9
, EAP.EAP_ATTRIBUTE10
, EAP.EAP_ATTRIBUTE11
, EAP.EAP_ATTRIBUTE12
, EAP.EAP_ATTRIBUTE13
, EAP.EAP_ATTRIBUTE14
, EAP.EAP_ATTRIBUTE15
, EAP.EAP_ATTRIBUTE16
, EAP.EAP_ATTRIBUTE17
, EAP.EAP_ATTRIBUTE18
, EAP.EAP_ATTRIBUTE19
, EAP.EAP_ATTRIBUTE20
, EAP.EAP_ATTRIBUTE21
, EAP.EAP_ATTRIBUTE22
, EAP.EAP_ATTRIBUTE23
, EAP.EAP_ATTRIBUTE24
, EAP.EAP_ATTRIBUTE25
, EAP.EAP_ATTRIBUTE26
, EAP.EAP_ATTRIBUTE27
, EAP.EAP_ATTRIBUTE28
, EAP.EAP_ATTRIBUTE29
, EAP.EAP_ATTRIBUTE30
, EAP.LAST_UPDATE_DATE
, EAP.LAST_UPDATED_BY
, EAP.LAST_UPDATE_LOGIN
, EAP.CREATED_BY
, EAP.CREATION_DATE
, EAP.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_AGE_PRTE_F EAP
WHERE EAP.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EAP.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))