Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_ELIG_DSBLTY_RSN_PRTE |
SELECT ELIG_DSBLTY_RSN_PRTE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, ELIGY_PRFL_ID
, EXCLD_FLAG
, REASON
, EDR_ATTRIBUTE_CATEGORY
, EDR_ATTRIBUTE1
, EDR_ATTRIBUTE2
, EDR_ATTRIBUTE3
, EDR_ATTRIBUTE4
, EDR_ATTRIBUTE5
, EDR_ATTRIBUTE6
, EDR_ATTRIBUTE7
, EDR_ATTRIBUTE8
, EDR_ATTRIBUTE9
, EDR_ATTRIBUTE10
, EDR_ATTRIBUTE11
, EDR_ATTRIBUTE12
, EDR_ATTRIBUTE13
, EDR_ATTRIBUTE14
, EDR_ATTRIBUTE15
, EDR_ATTRIBUTE16
, EDR_ATTRIBUTE17
, EDR_ATTRIBUTE18
, EDR_ATTRIBUTE19
, EDR_ATTRIBUTE20
, EDR_ATTRIBUTE21
, EDR_ATTRIBUTE22
, EDR_ATTRIBUTE23
, EDR_ATTRIBUTE24
, EDR_ATTRIBUTE25
, EDR_ATTRIBUTE26
, EDR_ATTRIBUTE27
, EDR_ATTRIBUTE28
, EDR_ATTRIBUTE29
, EDR_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM BEN_ELIG_DSBLTY_RSN_PRTE_F EDR
WHERE EDR.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EDR.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))