View: BEN_PRTN_ELIGY_RL

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

View Text

SELECT CER.PRTN_ELIGY_RL_ID
, CER.EFFECTIVE_START_DATE
, CER.EFFECTIVE_END_DATE
, CER.BUSINESS_GROUP_ID
, CER.PRTN_ELIG_ID
, CER.FORMULA_ID
, CER.DRVBL_FCTR_APLS_FLAG
, CER.MNDTRY_FLAG
, CER.ORDR_TO_APLY_NUM
, CER.CER_ATTRIBUTE_CATEGORY
, CER.CER_ATTRIBUTE1
, CER.CER_ATTRIBUTE2
, CER.CER_ATTRIBUTE3
, CER.CER_ATTRIBUTE4
, CER.CER_ATTRIBUTE5
, CER.CER_ATTRIBUTE6
, CER.CER_ATTRIBUTE7
, CER.CER_ATTRIBUTE8
, CER.CER_ATTRIBUTE9
, CER.CER_ATTRIBUTE10
, CER.CER_ATTRIBUTE11
, CER.CER_ATTRIBUTE12
, CER.CER_ATTRIBUTE13
, CER.CER_ATTRIBUTE14
, CER.CER_ATTRIBUTE15
, CER.CER_ATTRIBUTE16
, CER.CER_ATTRIBUTE17
, CER.CER_ATTRIBUTE18
, CER.CER_ATTRIBUTE19
, CER.CER_ATTRIBUTE20
, CER.CER_ATTRIBUTE21
, CER.CER_ATTRIBUTE22
, CER.CER_ATTRIBUTE23
, CER.CER_ATTRIBUTE24
, CER.CER_ATTRIBUTE25
, CER.CER_ATTRIBUTE26
, CER.CER_ATTRIBUTE27
, CER.CER_ATTRIBUTE28
, CER.CER_ATTRIBUTE29
, CER.CER_ATTRIBUTE30
, CER.LAST_UPDATE_DATE
, CER.LAST_UPDATED_BY
, CER.LAST_UPDATE_LOGIN
, CER.CREATED_BY
, CER.CREATION_DATE
, CER.OBJECT_VERSION_NUMBER
FROM BEN_PRTN_ELIGY_RL_F CER
WHERE CER.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND CER.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns