Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_CLPSE_LF_EVT_V |
SELECT CLP.ROWID ROW_ID
, CLP.CLPSE_LF_EVT_ID
, CLP.EFFECTIVE_START_DATE
, CLP.EFFECTIVE_END_DATE
, CLP.BUSINESS_GROUP_ID
, CLP.SEQ
, CLP.LER1_ID
, CLP.BOOL1_CD
, CLP.LER2_ID
, CLP.BOOL2_CD
, CLP.LER3_ID
, CLP.BOOL3_CD
, CLP.LER4_ID
, CLP.BOOL4_CD
, CLP.LER5_ID
, CLP.BOOL5_CD
, CLP.LER6_ID
, CLP.BOOL6_CD
, CLP.LER7_ID
, CLP.BOOL7_CD
, CLP.LER8_ID
, CLP.BOOL8_CD
, CLP.LER9_ID
, CLP.BOOL9_CD
, CLP.LER10_ID
, CLP.EVAL_CD
, CLP.EVAL_RL
, CLP.TLRNC_DYS_NUM
, CLP.EVAL_LER_ID
, CLP.EVAL_LER_DET_CD
, CLP.EVAL_LER_DET_RL
, CLP.CLP_ATTRIBUTE_CATEGORY
, CLP.CLP_ATTRIBUTE1
, CLP.CLP_ATTRIBUTE2
, CLP.CLP_ATTRIBUTE3
, CLP.CLP_ATTRIBUTE4
, CLP.CLP_ATTRIBUTE5
, CLP.CLP_ATTRIBUTE6
, CLP.CLP_ATTRIBUTE7
, CLP.CLP_ATTRIBUTE8
, CLP.CLP_ATTRIBUTE9
, CLP.CLP_ATTRIBUTE10
, CLP.CLP_ATTRIBUTE11
, CLP.CLP_ATTRIBUTE12
, CLP.CLP_ATTRIBUTE13
, CLP.CLP_ATTRIBUTE14
, CLP.CLP_ATTRIBUTE15
, CLP.CLP_ATTRIBUTE16
, CLP.CLP_ATTRIBUTE17
, CLP.CLP_ATTRIBUTE18
, CLP.CLP_ATTRIBUTE19
, CLP.CLP_ATTRIBUTE20
, CLP.CLP_ATTRIBUTE21
, CLP.CLP_ATTRIBUTE22
, CLP.CLP_ATTRIBUTE23
, CLP.CLP_ATTRIBUTE24
, CLP.CLP_ATTRIBUTE25
, CLP.CLP_ATTRIBUTE26
, CLP.CLP_ATTRIBUTE27
, CLP.CLP_ATTRIBUTE28
, CLP.CLP_ATTRIBUTE29
, CLP.CLP_ATTRIBUTE30
, CLP.LAST_UPDATE_DATE
, CLP.LAST_UPDATED_BY
, CLP.LAST_UPDATE_LOGIN
, CLP.CREATED_BY
, CLP.CREATION_DATE
, CLP.OBJECT_VERSION_NUMBER
FROM BEN_CLPSE_LF_EVT_F CLP
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN CLP.EFFECTIVE_START_DATE
AND CLP.EFFECTIVE_END_DATE