View: BEN_ELIG_AGE_PRTE_X

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

View Text

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 TRUNC(SYSDATE) BETWEEN EAP.EFFECTIVE_START_DATE
AND EAP.EFFECTIVE_END_DATE

Columns