VIEW: APPS.BEN_ELIG_PSTN_PRTE

Source

View Text - Preformatted

SELECT elig_pstn_prte_id ,effective_START_DATE ,effective_END_DATE ,BUSINESS_GROUP_ID ,eligy_prfl_id ,excld_flag ,POSITION_ID , EPS.CRITERIA_SCORE , EPS.CRITERIA_WEIGHT,EPS_attribute_CATEGORY ,EPS_ATTRIBUTE1 ,EPS_ATTRIBUTE2 ,EPS_ATTRIBUTE3 ,EPS_ATTRIBUTE4 ,EPS_ATTRIBUTE5 ,EPS_ATTRIBUTE6 ,EPS_ATTRIBUTE7 ,EPS_ATTRIBUTE8 ,EPS_ATTRIBUTE9 ,EPS_ATTRIBUTE10 ,EPS_ATTRIBUTE11 ,EPS_ATTRIBUTE12 ,EPS_ATTRIBUTE13 ,EPS_ATTRIBUTE14 ,EPS_ATTRIBUTE15 ,EPS_ATTRIBUTE16 ,EPS_ATTRIBUTE17 ,EPS_ATTRIBUTE18 ,EPS_ATTRIBUTE19 ,EPS_ATTRIBUTE20 ,EPS_ATTRIBUTE21 ,EPS_ATTRIBUTE22 ,EPS_ATTRIBUTE23 ,EPS_ATTRIBUTE24 ,EPS_ATTRIBUTE25 ,EPS_ATTRIBUTE26 ,EPS_ATTRIBUTE27 ,EPS_ATTRIBUTE28 ,EPS_ATTRIBUTE29 ,EPS_ATTRIBUTE30 ,LAST_UPDATE_DATE ,LAST_UPDATED_BY ,LAST_UPDATE_LOGIN ,CREATED_BY ,CREATION_DATE ,OBJECT_VERSION_NUMBER from ben_elig_pstn_prte_f EPS WHERE EPS.effective_START_DATE <= (SELECT SS.effective_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid')) AND EPS.effective_END_DATE >= (SELECT SS.effective_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid'))

View Text - HTML Formatted

SELECT ELIG_PSTN_PRTE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, ELIGY_PRFL_ID
, EXCLD_FLAG
, POSITION_ID
, EPS.CRITERIA_SCORE
, EPS.CRITERIA_WEIGHT
, EPS_ATTRIBUTE_CATEGORY
, EPS_ATTRIBUTE1
, EPS_ATTRIBUTE2
, EPS_ATTRIBUTE3
, EPS_ATTRIBUTE4
, EPS_ATTRIBUTE5
, EPS_ATTRIBUTE6
, EPS_ATTRIBUTE7
, EPS_ATTRIBUTE8
, EPS_ATTRIBUTE9
, EPS_ATTRIBUTE10
, EPS_ATTRIBUTE11
, EPS_ATTRIBUTE12
, EPS_ATTRIBUTE13
, EPS_ATTRIBUTE14
, EPS_ATTRIBUTE15
, EPS_ATTRIBUTE16
, EPS_ATTRIBUTE17
, EPS_ATTRIBUTE18
, EPS_ATTRIBUTE19
, EPS_ATTRIBUTE20
, EPS_ATTRIBUTE21
, EPS_ATTRIBUTE22
, EPS_ATTRIBUTE23
, EPS_ATTRIBUTE24
, EPS_ATTRIBUTE25
, EPS_ATTRIBUTE26
, EPS_ATTRIBUTE27
, EPS_ATTRIBUTE28
, EPS_ATTRIBUTE29
, EPS_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM BEN_ELIG_PSTN_PRTE_F EPS
WHERE EPS.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EPS.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))