Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_ELIG_ANTHR_PL_PRTE_X |
SELECT EOP.ELIG_ANTHR_PL_PRTE_ID
, EOP.PL_ID
, EOP.EFFECTIVE_START_DATE
, EOP.EFFECTIVE_END_DATE
, EOP.EXCLD_FLAG
, EOP.ELIGY_PRFL_ID
, EOP.BUSINESS_GROUP_ID
, EOP.EOP_ATTRIBUTE_CATEGORY
, EOP.EOP_ATTRIBUTE1
, EOP.EOP_ATTRIBUTE2
, EOP.EOP_ATTRIBUTE3
, EOP.EOP_ATTRIBUTE4
, EOP.EOP_ATTRIBUTE5
, EOP.EOP_ATTRIBUTE6
, EOP.EOP_ATTRIBUTE7
, EOP.EOP_ATTRIBUTE8
, EOP.EOP_ATTRIBUTE9
, EOP.EOP_ATTRIBUTE10
, EOP.EOP_ATTRIBUTE11
, EOP.EOP_ATTRIBUTE12
, EOP.EOP_ATTRIBUTE13
, EOP.EOP_ATTRIBUTE14
, EOP.EOP_ATTRIBUTE15
, EOP.EOP_ATTRIBUTE16
, EOP.EOP_ATTRIBUTE17
, EOP.EOP_ATTRIBUTE18
, EOP.EOP_ATTRIBUTE19
, EOP.EOP_ATTRIBUTE20
, EOP.EOP_ATTRIBUTE21
, EOP.EOP_ATTRIBUTE22
, EOP.EOP_ATTRIBUTE23
, EOP.EOP_ATTRIBUTE24
, EOP.EOP_ATTRIBUTE25
, EOP.EOP_ATTRIBUTE26
, EOP.EOP_ATTRIBUTE27
, EOP.EOP_ATTRIBUTE28
, EOP.EOP_ATTRIBUTE29
, EOP.EOP_ATTRIBUTE30
, EOP.LAST_UPDATE_DATE
, EOP.LAST_UPDATED_BY
, EOP.LAST_UPDATE_LOGIN
, EOP.CREATED_BY
, EOP.CREATION_DATE
, EOP.OBJECT_VERSION_NUMBER
, EOP.ORDR_NUM
FROM BEN_ELIG_ANTHR_PL_PRTE_F EOP
WHERE TRUNC(SYSDATE) BETWEEN EOP.EFFECTIVE_START_DATE
AND EOP.EFFECTIVE_END_DATE