VIEW: APPS.BEN_ELIG_ANTHR_PL_PRTE_X

Source

View Text - Preformatted

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

View Text - HTML Formatted

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