VIEW: APPS.BEN_PRTN_ELIGY_RL_V

Source

View Text - Preformatted

SELECT CER.ROWID ROW_ID , CER.PRTN_ELIGY_RL_ID , CER.EFFECTIVE_START_DATE , CER.EFFECTIVE_END_DATE , CER.BUSINESS_GROUP_ID , CER.PRTN_ELIG_ID , CER.FORMULA_ID , CER.DRVBL_FCTR_APLS_FLAG , CER.MNDTRY_FLAG , CER.ORDR_TO_APLY_NUM , CER.CER_ATTRIBUTE_CATEGORY , CER.CER_ATTRIBUTE1 , CER.CER_ATTRIBUTE2 , CER.CER_ATTRIBUTE3 , CER.CER_ATTRIBUTE4 , CER.CER_ATTRIBUTE5 , CER.CER_ATTRIBUTE6 , CER.CER_ATTRIBUTE7 , CER.CER_ATTRIBUTE8 , CER.CER_ATTRIBUTE9 , CER.CER_ATTRIBUTE10 , CER.CER_ATTRIBUTE11 , CER.CER_ATTRIBUTE12 , CER.CER_ATTRIBUTE13 , CER.CER_ATTRIBUTE14 , CER.CER_ATTRIBUTE15 , CER.CER_ATTRIBUTE16 , CER.CER_ATTRIBUTE17 , CER.CER_ATTRIBUTE18 , CER.CER_ATTRIBUTE19 , CER.CER_ATTRIBUTE20 , CER.CER_ATTRIBUTE21 , CER.CER_ATTRIBUTE22 , CER.CER_ATTRIBUTE23 , CER.CER_ATTRIBUTE24 , CER.CER_ATTRIBUTE25 , CER.CER_ATTRIBUTE26 , CER.CER_ATTRIBUTE27 , CER.CER_ATTRIBUTE28 , CER.CER_ATTRIBUTE29 , CER.CER_ATTRIBUTE30 , CER.LAST_UPDATE_DATE , CER.LAST_UPDATED_BY , CER.LAST_UPDATE_LOGIN , CER.CREATED_BY , CER.CREATION_DATE , CER.OBJECT_VERSION_NUMBER FROM BEN_PRTN_ELIGY_RL_F CER, FND_SESSIONS SE WHERE SE.SESSION_ID = USERENV('sessionid') AND SE.EFFECTIVE_DATE BETWEEN CER.EFFECTIVE_START_DATE AND CER.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT CER.ROWID ROW_ID
, CER.PRTN_ELIGY_RL_ID
, CER.EFFECTIVE_START_DATE
, CER.EFFECTIVE_END_DATE
, CER.BUSINESS_GROUP_ID
, CER.PRTN_ELIG_ID
, CER.FORMULA_ID
, CER.DRVBL_FCTR_APLS_FLAG
, CER.MNDTRY_FLAG
, CER.ORDR_TO_APLY_NUM
, CER.CER_ATTRIBUTE_CATEGORY
, CER.CER_ATTRIBUTE1
, CER.CER_ATTRIBUTE2
, CER.CER_ATTRIBUTE3
, CER.CER_ATTRIBUTE4
, CER.CER_ATTRIBUTE5
, CER.CER_ATTRIBUTE6
, CER.CER_ATTRIBUTE7
, CER.CER_ATTRIBUTE8
, CER.CER_ATTRIBUTE9
, CER.CER_ATTRIBUTE10
, CER.CER_ATTRIBUTE11
, CER.CER_ATTRIBUTE12
, CER.CER_ATTRIBUTE13
, CER.CER_ATTRIBUTE14
, CER.CER_ATTRIBUTE15
, CER.CER_ATTRIBUTE16
, CER.CER_ATTRIBUTE17
, CER.CER_ATTRIBUTE18
, CER.CER_ATTRIBUTE19
, CER.CER_ATTRIBUTE20
, CER.CER_ATTRIBUTE21
, CER.CER_ATTRIBUTE22
, CER.CER_ATTRIBUTE23
, CER.CER_ATTRIBUTE24
, CER.CER_ATTRIBUTE25
, CER.CER_ATTRIBUTE26
, CER.CER_ATTRIBUTE27
, CER.CER_ATTRIBUTE28
, CER.CER_ATTRIBUTE29
, CER.CER_ATTRIBUTE30
, CER.LAST_UPDATE_DATE
, CER.LAST_UPDATED_BY
, CER.LAST_UPDATE_LOGIN
, CER.CREATED_BY
, CER.CREATION_DATE
, CER.OBJECT_VERSION_NUMBER
FROM BEN_PRTN_ELIGY_RL_F CER
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN CER.EFFECTIVE_START_DATE
AND CER.EFFECTIVE_END_DATE