Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_ELIG_WK_LOC_PRTE_X |
SELECT EWL.ELIG_WK_LOC_PRTE_ID
, EWL.EFFECTIVE_START_DATE
, EWL.EFFECTIVE_END_DATE
, EWL.BUSINESS_GROUP_ID
, EWL.ORDR_NUM
, EWL.LOCATION_ID
, EWL.ELIGY_PRFL_ID
, EWL.EXCLD_FLAG
, EWL.EWL_ATTRIBUTE_CATEGORY
, EWL.EWL_ATTRIBUTE1
, EWL.EWL_ATTRIBUTE2
, EWL.EWL_ATTRIBUTE3
, EWL.EWL_ATTRIBUTE4
, EWL.EWL_ATTRIBUTE5
, EWL.EWL_ATTRIBUTE6
, EWL.EWL_ATTRIBUTE7
, EWL.EWL_ATTRIBUTE8
, EWL.EWL_ATTRIBUTE9
, EWL.EWL_ATTRIBUTE10
, EWL.EWL_ATTRIBUTE11
, EWL.EWL_ATTRIBUTE12
, EWL.EWL_ATTRIBUTE13
, EWL.EWL_ATTRIBUTE14
, EWL.EWL_ATTRIBUTE15
, EWL.EWL_ATTRIBUTE16
, EWL.EWL_ATTRIBUTE17
, EWL.EWL_ATTRIBUTE18
, EWL.EWL_ATTRIBUTE19
, EWL.EWL_ATTRIBUTE20
, EWL.EWL_ATTRIBUTE21
, EWL.EWL_ATTRIBUTE22
, EWL.EWL_ATTRIBUTE23
, EWL.EWL_ATTRIBUTE24
, EWL.EWL_ATTRIBUTE25
, EWL.EWL_ATTRIBUTE26
, EWL.EWL_ATTRIBUTE27
, EWL.EWL_ATTRIBUTE28
, EWL.EWL_ATTRIBUTE29
, EWL.EWL_ATTRIBUTE30
, EWL.LAST_UPDATE_DATE
, EWL.LAST_UPDATED_BY
, EWL.LAST_UPDATE_LOGIN
, EWL.CREATED_BY
, EWL.CREATION_DATE
, EWL.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_WK_LOC_PRTE_F EWL
WHERE TRUNC(SYSDATE) BETWEEN EWL.EFFECTIVE_START_DATE
AND EWL.EFFECTIVE_END_DATE