View: BEN_PREM_CSTG_BY_SGMT_V

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BEN_PREM_CSTG_BY_SGMT_V

View Text

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

Columns