Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_PREM_CSTG_BY_SGMT |
SELECT 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
WHERE CBS.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND CBS.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))