VIEW: APPS.BEN_ELIG_ORG_UNIT_PRTE_X

Source

View Text - Preformatted

SELECT EOU.ELIG_ORG_UNIT_PRTE_ID , EOU.EFFECTIVE_START_DATE , EOU.EFFECTIVE_END_DATE , EOU.BUSINESS_GROUP_ID , EOU.ELIGY_PRFL_ID , EOU.ORGANIZATION_ID , EOU.EXCLD_FLAG , EOU.ORDR_NUM , EOU.CRITERIA_SCORE , EOU.CRITERIA_WEIGHT , EOU.EOU_ATTRIBUTE_CATEGORY , EOU.EOU_ATTRIBUTE1 , EOU.EOU_ATTRIBUTE2 , EOU.EOU_ATTRIBUTE3 , EOU.EOU_ATTRIBUTE4 , EOU.EOU_ATTRIBUTE5 , EOU.EOU_ATTRIBUTE6 , EOU.EOU_ATTRIBUTE7 , EOU.EOU_ATTRIBUTE8 , EOU.EOU_ATTRIBUTE9 , EOU.EOU_ATTRIBUTE10 , EOU.EOU_ATTRIBUTE11 , EOU.EOU_ATTRIBUTE12 , EOU.EOU_ATTRIBUTE13 , EOU.EOU_ATTRIBUTE14 , EOU.EOU_ATTRIBUTE15 , EOU.EOU_ATTRIBUTE16 , EOU.EOU_ATTRIBUTE17 , EOU.EOU_ATTRIBUTE18 , EOU.EOU_ATTRIBUTE19 , EOU.EOU_ATTRIBUTE20 , EOU.EOU_ATTRIBUTE21 , EOU.EOU_ATTRIBUTE22 , EOU.EOU_ATTRIBUTE23 , EOU.EOU_ATTRIBUTE24 , EOU.EOU_ATTRIBUTE25 , EOU.EOU_ATTRIBUTE26 , EOU.EOU_ATTRIBUTE27 , EOU.EOU_ATTRIBUTE28 , EOU.EOU_ATTRIBUTE29 , EOU.EOU_ATTRIBUTE30 , EOU.LAST_UPDATE_DATE , EOU.LAST_UPDATED_BY , EOU.LAST_UPDATE_LOGIN , EOU.CREATED_BY , EOU.CREATION_DATE , EOU.OBJECT_VERSION_NUMBER FROM BEN_ELIG_ORG_UNIT_PRTE_F EOU WHERE TRUNC(SYSDATE) BETWEEN EOU.EFFECTIVE_START_DATE AND EOU.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT EOU.ELIG_ORG_UNIT_PRTE_ID
, EOU.EFFECTIVE_START_DATE
, EOU.EFFECTIVE_END_DATE
, EOU.BUSINESS_GROUP_ID
, EOU.ELIGY_PRFL_ID
, EOU.ORGANIZATION_ID
, EOU.EXCLD_FLAG
, EOU.ORDR_NUM
, EOU.CRITERIA_SCORE
, EOU.CRITERIA_WEIGHT
, EOU.EOU_ATTRIBUTE_CATEGORY
, EOU.EOU_ATTRIBUTE1
, EOU.EOU_ATTRIBUTE2
, EOU.EOU_ATTRIBUTE3
, EOU.EOU_ATTRIBUTE4
, EOU.EOU_ATTRIBUTE5
, EOU.EOU_ATTRIBUTE6
, EOU.EOU_ATTRIBUTE7
, EOU.EOU_ATTRIBUTE8
, EOU.EOU_ATTRIBUTE9
, EOU.EOU_ATTRIBUTE10
, EOU.EOU_ATTRIBUTE11
, EOU.EOU_ATTRIBUTE12
, EOU.EOU_ATTRIBUTE13
, EOU.EOU_ATTRIBUTE14
, EOU.EOU_ATTRIBUTE15
, EOU.EOU_ATTRIBUTE16
, EOU.EOU_ATTRIBUTE17
, EOU.EOU_ATTRIBUTE18
, EOU.EOU_ATTRIBUTE19
, EOU.EOU_ATTRIBUTE20
, EOU.EOU_ATTRIBUTE21
, EOU.EOU_ATTRIBUTE22
, EOU.EOU_ATTRIBUTE23
, EOU.EOU_ATTRIBUTE24
, EOU.EOU_ATTRIBUTE25
, EOU.EOU_ATTRIBUTE26
, EOU.EOU_ATTRIBUTE27
, EOU.EOU_ATTRIBUTE28
, EOU.EOU_ATTRIBUTE29
, EOU.EOU_ATTRIBUTE30
, EOU.LAST_UPDATE_DATE
, EOU.LAST_UPDATED_BY
, EOU.LAST_UPDATE_LOGIN
, EOU.CREATED_BY
, EOU.CREATION_DATE
, EOU.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_ORG_UNIT_PRTE_F EOU
WHERE TRUNC(SYSDATE) BETWEEN EOU.EFFECTIVE_START_DATE
AND EOU.EFFECTIVE_END_DATE