VIEW: APPS.BEN_ELIG_CMBN_AGE_LOS_PRTE

Source

View Text - Preformatted

SELECT ECP.ELIG_CMBN_AGE_LOS_PRTE_ID , ECP.EFFECTIVE_START_DATE , ECP.EFFECTIVE_END_DATE , ECP.BUSINESS_GROUP_ID , ECP.CMBN_AGE_LOS_FCTR_ID , ECP.ELIGY_PRFL_ID , ECP.EXCLD_FLAG , ECP.ORDR_NUM , ECP.MNDTRY_FLAG , ECP.CRITERIA_SCORE , ECP.CRITERIA_WEIGHT , ECP.ECP_ATTRIBUTE_CATEGORY , ECP.ECP_ATTRIBUTE1 , ECP.ECP_ATTRIBUTE2 , ECP.ECP_ATTRIBUTE3 , ECP.ECP_ATTRIBUTE4 , ECP.ECP_ATTRIBUTE5 , ECP.ECP_ATTRIBUTE6 , ECP.ECP_ATTRIBUTE7 , ECP.ECP_ATTRIBUTE8 , ECP.ECP_ATTRIBUTE9 , ECP.ECP_ATTRIBUTE10 , ECP.ECP_ATTRIBUTE11 , ECP.ECP_ATTRIBUTE12 , ECP.ECP_ATTRIBUTE13 , ECP.ECP_ATTRIBUTE14 , ECP.ECP_ATTRIBUTE15 , ECP.ECP_ATTRIBUTE16 , ECP.ECP_ATTRIBUTE17 , ECP.ECP_ATTRIBUTE18 , ECP.ECP_ATTRIBUTE19 , ECP.ECP_ATTRIBUTE20 , ECP.ECP_ATTRIBUTE21 , ECP.ECP_ATTRIBUTE22 , ECP.ECP_ATTRIBUTE23 , ECP.ECP_ATTRIBUTE24 , ECP.ECP_ATTRIBUTE25 , ECP.ECP_ATTRIBUTE26 , ECP.ECP_ATTRIBUTE27 , ECP.ECP_ATTRIBUTE28 , ECP.ECP_ATTRIBUTE29 , ECP.ECP_ATTRIBUTE30 , ECP.LAST_UPDATE_DATE , ECP.LAST_UPDATED_BY , ECP.LAST_UPDATE_LOGIN , ECP.CREATED_BY , ECP.CREATION_DATE , ECP.OBJECT_VERSION_NUMBER FROM BEN_ELIG_CMBN_AGE_LOS_PRTE_F ECP WHERE ECP.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid')) AND ECP.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid'))

View Text - HTML Formatted

SELECT ECP.ELIG_CMBN_AGE_LOS_PRTE_ID
, ECP.EFFECTIVE_START_DATE
, ECP.EFFECTIVE_END_DATE
, ECP.BUSINESS_GROUP_ID
, ECP.CMBN_AGE_LOS_FCTR_ID
, ECP.ELIGY_PRFL_ID
, ECP.EXCLD_FLAG
, ECP.ORDR_NUM
, ECP.MNDTRY_FLAG
, ECP.CRITERIA_SCORE
, ECP.CRITERIA_WEIGHT
, ECP.ECP_ATTRIBUTE_CATEGORY
, ECP.ECP_ATTRIBUTE1
, ECP.ECP_ATTRIBUTE2
, ECP.ECP_ATTRIBUTE3
, ECP.ECP_ATTRIBUTE4
, ECP.ECP_ATTRIBUTE5
, ECP.ECP_ATTRIBUTE6
, ECP.ECP_ATTRIBUTE7
, ECP.ECP_ATTRIBUTE8
, ECP.ECP_ATTRIBUTE9
, ECP.ECP_ATTRIBUTE10
, ECP.ECP_ATTRIBUTE11
, ECP.ECP_ATTRIBUTE12
, ECP.ECP_ATTRIBUTE13
, ECP.ECP_ATTRIBUTE14
, ECP.ECP_ATTRIBUTE15
, ECP.ECP_ATTRIBUTE16
, ECP.ECP_ATTRIBUTE17
, ECP.ECP_ATTRIBUTE18
, ECP.ECP_ATTRIBUTE19
, ECP.ECP_ATTRIBUTE20
, ECP.ECP_ATTRIBUTE21
, ECP.ECP_ATTRIBUTE22
, ECP.ECP_ATTRIBUTE23
, ECP.ECP_ATTRIBUTE24
, ECP.ECP_ATTRIBUTE25
, ECP.ECP_ATTRIBUTE26
, ECP.ECP_ATTRIBUTE27
, ECP.ECP_ATTRIBUTE28
, ECP.ECP_ATTRIBUTE29
, ECP.ECP_ATTRIBUTE30
, ECP.LAST_UPDATE_DATE
, ECP.LAST_UPDATED_BY
, ECP.LAST_UPDATE_LOGIN
, ECP.CREATED_BY
, ECP.CREATION_DATE
, ECP.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_CMBN_AGE_LOS_PRTE_F ECP
WHERE ECP.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND ECP.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))