VIEW: APPS.BEN_ELIG_WK_LOC_PRTE_X

Source

View Text - Preformatted

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.CRITERIA_SCORE , EWL.CRITERIA_WEIGHT , 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

View Text - HTML Formatted

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.CRITERIA_SCORE
, EWL.CRITERIA_WEIGHT
, 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