View: BEN_ELIG_BENFTS_GRP_PRTE

Product:	BEN - Advanced Benefits
Description:	- Retrofitted
Implementation/DBA Data:	APPS.BEN_ELIG_BENFTS_GRP_PRTE

View Text

SELECT ELIG_BENFTS_GRP_PRTE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, EXCLD_FLAG
, ORDR_NUM
, BENFTS_GRP_ID
, ELIGY_PRFL_ID
, BUSINESS_GROUP_ID
, EBN_ATTRIBUTE_CATEGORY
, EBN_ATTRIBUTE1
, EBN_ATTRIBUTE2
, EBN_ATTRIBUTE3
, EBN_ATTRIBUTE4
, EBN_ATTRIBUTE5
, EBN_ATTRIBUTE6
, EBN_ATTRIBUTE7
, EBN_ATTRIBUTE8
, EBN_ATTRIBUTE9
, EBN_ATTRIBUTE10
, EBN_ATTRIBUTE11
, EBN_ATTRIBUTE12
, EBN_ATTRIBUTE13
, EBN_ATTRIBUTE14
, EBN_ATTRIBUTE15
, EBN_ATTRIBUTE16
, EBN_ATTRIBUTE17
, EBN_ATTRIBUTE18
, EBN_ATTRIBUTE19
, EBN_ATTRIBUTE20
, EBN_ATTRIBUTE21
, EBN_ATTRIBUTE22
, EBN_ATTRIBUTE23
, EBN_ATTRIBUTE24
, EBN_ATTRIBUTE25
, EBN_ATTRIBUTE26
, EBN_ATTRIBUTE27
, EBN_ATTRIBUTE28
, EBN_ATTRIBUTE29
, EBN_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM BEN_ELIG_BENFTS_GRP_PRTE_F EBN
WHERE EBN.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EBN.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns