VIEW: APPS.BEN_PREM_CSTG_BY_SGMT_V

Source

View Text - Preformatted

SELECT cbs.ROWID ROW_ID, cbs.PREM_CSTG_BY_SGMT_ID ,cbs.EFFECTIVE_START_DATE ,cbs.EFFECTIVE_END_DATE ,cbs.SGMT_NUM ,cbs.SGMT_CSTG_MTHD_CD ,cbs.SGMT_CSTG_MTHD_RL ,cbs.BUSINESS_GROUP_ID ,cbs.ACTL_PREM_ID ,cbs.CBS_ATTRIBUTE_CATEGORY ,cbs.CBS_ATTRIBUTE1 ,cbs.CBS_ATTRIBUTE2 ,cbs.CBS_ATTRIBUTE3 ,cbs.CBS_ATTRIBUTE4 ,cbs.CBS_ATTRIBUTE5 ,cbs.CBS_ATTRIBUTE6 ,cbs.CBS_ATTRIBUTE7 ,cbs.CBS_ATTRIBUTE8 ,cbs.CBS_ATTRIBUTE9 ,cbs.CBS_ATTRIBUTE10 ,cbs.CBS_ATTRIBUTE11 ,cbs.CBS_ATTRIBUTE12 ,cbs.CBS_ATTRIBUTE13 ,cbs.CBS_ATTRIBUTE14 ,cbs.CBS_ATTRIBUTE15 ,cbs.CBS_ATTRIBUTE16 ,cbs.CBS_ATTRIBUTE17 ,cbs.CBS_ATTRIBUTE18 ,cbs.CBS_ATTRIBUTE19 ,cbs.CBS_ATTRIBUTE20 ,cbs.CBS_ATTRIBUTE21 ,cbs.CBS_ATTRIBUTE22 ,cbs.CBS_ATTRIBUTE23 ,cbs.CBS_ATTRIBUTE24 ,cbs.CBS_ATTRIBUTE25 ,cbs.CBS_ATTRIBUTE26 ,cbs.CBS_ATTRIBUTE27 ,cbs.CBS_ATTRIBUTE28 ,cbs.CBS_ATTRIBUTE29 ,cbs.CBS_ATTRIBUTE30 ,cbs.LAST_UPDATE_DATE ,cbs.LAST_UPDATED_BY ,cbs.LAST_UPDATE_LOGIN ,cbs.CREATED_BY ,cbs.CREATION_DATE ,cbs.OBJECT_VERSION_NUMBER from BEN_PREM_CSTG_BY_SGMT_F cbs, fnd_sessions se WHERE se.session_id = userenv('sessionid') and se.effective_date between cbs.effective_start_date and cbs.effective_end_date

View Text - HTML Formatted

SELECT CBS.ROWID ROW_ID
, CBS.PREM_CSTG_BY_SGMT_ID
, CBS.EFFECTIVE_START_DATE
, CBS.EFFECTIVE_END_DATE
, CBS.SGMT_NUM
, CBS.SGMT_CSTG_MTHD_CD
, CBS.SGMT_CSTG_MTHD_RL
, CBS.BUSINESS_GROUP_ID
, CBS.ACTL_PREM_ID
, CBS.CBS_ATTRIBUTE_CATEGORY
, CBS.CBS_ATTRIBUTE1
, CBS.CBS_ATTRIBUTE2
, CBS.CBS_ATTRIBUTE3
, CBS.CBS_ATTRIBUTE4
, CBS.CBS_ATTRIBUTE5
, CBS.CBS_ATTRIBUTE6
, CBS.CBS_ATTRIBUTE7
, CBS.CBS_ATTRIBUTE8
, CBS.CBS_ATTRIBUTE9
, CBS.CBS_ATTRIBUTE10
, CBS.CBS_ATTRIBUTE11
, CBS.CBS_ATTRIBUTE12
, CBS.CBS_ATTRIBUTE13
, CBS.CBS_ATTRIBUTE14
, CBS.CBS_ATTRIBUTE15
, CBS.CBS_ATTRIBUTE16
, CBS.CBS_ATTRIBUTE17
, CBS.CBS_ATTRIBUTE18
, CBS.CBS_ATTRIBUTE19
, CBS.CBS_ATTRIBUTE20
, CBS.CBS_ATTRIBUTE21
, CBS.CBS_ATTRIBUTE22
, CBS.CBS_ATTRIBUTE23
, CBS.CBS_ATTRIBUTE24
, CBS.CBS_ATTRIBUTE25
, CBS.CBS_ATTRIBUTE26
, CBS.CBS_ATTRIBUTE27
, CBS.CBS_ATTRIBUTE28
, CBS.CBS_ATTRIBUTE29
, CBS.CBS_ATTRIBUTE30
, CBS.LAST_UPDATE_DATE
, CBS.LAST_UPDATED_BY
, CBS.LAST_UPDATE_LOGIN
, CBS.CREATED_BY
, CBS.CREATION_DATE
, CBS.OBJECT_VERSION_NUMBER
FROM BEN_PREM_CSTG_BY_SGMT_F CBS
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN CBS.EFFECTIVE_START_DATE
AND CBS.EFFECTIVE_END_DATE