VIEW: APPS.BEN_CLPSE_LF_EVT

Source

View Text - Preformatted

SELECT 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 WHERE clp.effective_start_date <= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid')) and clp.effective_end_date >= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid'))

View Text - HTML Formatted

SELECT 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
WHERE CLP.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND CLP.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))