View: BEN_ELIG_PSTN_PRTE_X

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

View Text

SELECT ELIG_PSTN_PRTE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, ELIGY_PRFL_ID
, EXCLD_FLAG
, POSITION_ID
, EPS_ATTRIBUTE_CATEGORY
, EPS_ATTRIBUTE1
, EPS_ATTRIBUTE2
, EPS_ATTRIBUTE3
, EPS_ATTRIBUTE4
, EPS_ATTRIBUTE5
, EPS_ATTRIBUTE6
, EPS_ATTRIBUTE7
, EPS_ATTRIBUTE8
, EPS_ATTRIBUTE9
, EPS_ATTRIBUTE10
, EPS_ATTRIBUTE11
, EPS_ATTRIBUTE12
, EPS_ATTRIBUTE13
, EPS_ATTRIBUTE14
, EPS_ATTRIBUTE15
, EPS_ATTRIBUTE16
, EPS_ATTRIBUTE17
, EPS_ATTRIBUTE18
, EPS_ATTRIBUTE19
, EPS_ATTRIBUTE20
, EPS_ATTRIBUTE21
, EPS_ATTRIBUTE22
, EPS_ATTRIBUTE23
, EPS_ATTRIBUTE24
, EPS_ATTRIBUTE25
, EPS_ATTRIBUTE26
, EPS_ATTRIBUTE27
, EPS_ATTRIBUTE28
, EPS_ATTRIBUTE29
, EPS_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM BEN_ELIG_PSTN_PRTE_F EPS
WHERE TRUNC(SYSDATE) BETWEEN EPS.EFFECTIVE_START_DATE
AND EPS.EFFECTIVE_END_DATE

Columns