View: BEN_ELIG_OTHR_PTIP_PRTE_X

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

View Text

SELECT EOY.ELIG_OTHR_PTIP_PRTE_ID
, EOY.EFFECTIVE_START_DATE
, EOY.EFFECTIVE_END_DATE
, EOY.EXCLD_FLAG
, EOY.ORDR_NUM
, EOY.ONLY_PLS_SUBJ_COBRA_FLAG
, EOY.ELIGY_PRFL_ID
, EOY.PTIP_ID
, EOY.BUSINESS_GROUP_ID
, EOY.EOY_ATTRIBUTE_CATEGORY
, EOY.EOY_ATTRIBUTE1
, EOY.EOY_ATTRIBUTE2
, EOY.EOY_ATTRIBUTE3
, EOY.EOY_ATTRIBUTE4
, EOY.EOY_ATTRIBUTE5
, EOY.EOY_ATTRIBUTE6
, EOY.EOY_ATTRIBUTE7
, EOY.EOY_ATTRIBUTE8
, EOY.EOY_ATTRIBUTE9
, EOY.EOY_ATTRIBUTE10
, EOY.EOY_ATTRIBUTE11
, EOY.EOY_ATTRIBUTE12
, EOY.EOY_ATTRIBUTE13
, EOY.EOY_ATTRIBUTE14
, EOY.EOY_ATTRIBUTE15
, EOY.EOY_ATTRIBUTE16
, EOY.EOY_ATTRIBUTE17
, EOY.EOY_ATTRIBUTE18
, EOY.EOY_ATTRIBUTE19
, EOY.EOY_ATTRIBUTE20
, EOY.EOY_ATTRIBUTE21
, EOY.EOY_ATTRIBUTE22
, EOY.EOY_ATTRIBUTE23
, EOY.EOY_ATTRIBUTE24
, EOY.EOY_ATTRIBUTE25
, EOY.EOY_ATTRIBUTE26
, EOY.EOY_ATTRIBUTE27
, EOY.EOY_ATTRIBUTE28
, EOY.EOY_ATTRIBUTE29
, EOY.EOY_ATTRIBUTE30
, EOY.LAST_UPDATE_DATE
, EOY.LAST_UPDATED_BY
, EOY.LAST_UPDATE_LOGIN
, EOY.CREATED_BY
, EOY.CREATION_DATE
, EOY.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_OTHR_PTIP_PRTE_F EOY
WHERE TRUNC(SYSDATE) BETWEEN EOY.EFFECTIVE_START_DATE
AND EOY.EFFECTIVE_END_DATE

Columns