VIEW: APPS.BEN_ELIG_PRTT_ANTHR_PL_PRTE

Source

View Text - Preformatted

SELECT EPP.ELIG_PRTT_ANTHR_PL_PRTE_ID , EPP.EFFECTIVE_START_DATE , EPP.EFFECTIVE_END_DATE , EPP.EXCLD_FLAG , EPP.ORDR_NUM , EPP.ELIGY_PRFL_ID , EPP.PL_ID , EPP.BUSINESS_GROUP_ID , EPP.EPP_ATTRIBUTE_CATEGORY , EPP.EPP_ATTRIBUTE1 , EPP.EPP_ATTRIBUTE2 , EPP.EPP_ATTRIBUTE3 , EPP.EPP_ATTRIBUTE4 , EPP.EPP_ATTRIBUTE5 , EPP.EPP_ATTRIBUTE6 , EPP.EPP_ATTRIBUTE7 , EPP.EPP_ATTRIBUTE8 , EPP.EPP_ATTRIBUTE9 , EPP.EPP_ATTRIBUTE10 , EPP.EPP_ATTRIBUTE11 , EPP.EPP_ATTRIBUTE12 , EPP.EPP_ATTRIBUTE13 , EPP.EPP_ATTRIBUTE14 , EPP.EPP_ATTRIBUTE15 , EPP.EPP_ATTRIBUTE16 , EPP.EPP_ATTRIBUTE17 , EPP.EPP_ATTRIBUTE18 , EPP.EPP_ATTRIBUTE19 , EPP.EPP_ATTRIBUTE20 , EPP.EPP_ATTRIBUTE21 , EPP.EPP_ATTRIBUTE22 , EPP.EPP_ATTRIBUTE23 , EPP.EPP_ATTRIBUTE24 , EPP.EPP_ATTRIBUTE25 , EPP.EPP_ATTRIBUTE26 , EPP.EPP_ATTRIBUTE27 , EPP.EPP_ATTRIBUTE28 , EPP.EPP_ATTRIBUTE29 , EPP.EPP_ATTRIBUTE30 , EPP.LAST_UPDATE_DATE , EPP.LAST_UPDATED_BY , EPP.LAST_UPDATE_LOGIN , EPP.CREATED_BY , EPP.CREATION_DATE , EPP.OBJECT_VERSION_NUMBER FROM BEN_ELIG_PRTT_ANTHR_PL_PRTE_F EPP WHERE EPP.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid')) AND EPP.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid'))

View Text - HTML Formatted

SELECT EPP.ELIG_PRTT_ANTHR_PL_PRTE_ID
, EPP.EFFECTIVE_START_DATE
, EPP.EFFECTIVE_END_DATE
, EPP.EXCLD_FLAG
, EPP.ORDR_NUM
, EPP.ELIGY_PRFL_ID
, EPP.PL_ID
, EPP.BUSINESS_GROUP_ID
, EPP.EPP_ATTRIBUTE_CATEGORY
, EPP.EPP_ATTRIBUTE1
, EPP.EPP_ATTRIBUTE2
, EPP.EPP_ATTRIBUTE3
, EPP.EPP_ATTRIBUTE4
, EPP.EPP_ATTRIBUTE5
, EPP.EPP_ATTRIBUTE6
, EPP.EPP_ATTRIBUTE7
, EPP.EPP_ATTRIBUTE8
, EPP.EPP_ATTRIBUTE9
, EPP.EPP_ATTRIBUTE10
, EPP.EPP_ATTRIBUTE11
, EPP.EPP_ATTRIBUTE12
, EPP.EPP_ATTRIBUTE13
, EPP.EPP_ATTRIBUTE14
, EPP.EPP_ATTRIBUTE15
, EPP.EPP_ATTRIBUTE16
, EPP.EPP_ATTRIBUTE17
, EPP.EPP_ATTRIBUTE18
, EPP.EPP_ATTRIBUTE19
, EPP.EPP_ATTRIBUTE20
, EPP.EPP_ATTRIBUTE21
, EPP.EPP_ATTRIBUTE22
, EPP.EPP_ATTRIBUTE23
, EPP.EPP_ATTRIBUTE24
, EPP.EPP_ATTRIBUTE25
, EPP.EPP_ATTRIBUTE26
, EPP.EPP_ATTRIBUTE27
, EPP.EPP_ATTRIBUTE28
, EPP.EPP_ATTRIBUTE29
, EPP.EPP_ATTRIBUTE30
, EPP.LAST_UPDATE_DATE
, EPP.LAST_UPDATED_BY
, EPP.LAST_UPDATE_LOGIN
, EPP.CREATED_BY
, EPP.CREATION_DATE
, EPP.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_PRTT_ANTHR_PL_PRTE_F EPP
WHERE EPP.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EPP.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))