View: BEN_SVC_AREA_RT

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

View Text

SELECT SAR.SVC_AREA_RT_ID
, SAR.EFFECTIVE_START_DATE
, SAR.EFFECTIVE_END_DATE
, SAR.EXCLD_FLAG
, SAR.ORDR_NUM
, SAR.SVC_AREA_ID
, SAR.VRBL_RT_PRFL_ID
, SAR.BUSINESS_GROUP_ID
, SAR.SAR_ATTRIBUTE_CATEGORY
, SAR.SAR_ATTRIBUTE1
, SAR.SAR_ATTRIBUTE2
, SAR.SAR_ATTRIBUTE3
, SAR.SAR_ATTRIBUTE4
, SAR.SAR_ATTRIBUTE5
, SAR.SAR_ATTRIBUTE6
, SAR.SAR_ATTRIBUTE7
, SAR.SAR_ATTRIBUTE8
, SAR.SAR_ATTRIBUTE9
, SAR.SAR_ATTRIBUTE10
, SAR.SAR_ATTRIBUTE11
, SAR.SAR_ATTRIBUTE12
, SAR.SAR_ATTRIBUTE13
, SAR.SAR_ATTRIBUTE14
, SAR.SAR_ATTRIBUTE15
, SAR.SAR_ATTRIBUTE16
, SAR.SAR_ATTRIBUTE17
, SAR.SAR_ATTRIBUTE18
, SAR.SAR_ATTRIBUTE19
, SAR.SAR_ATTRIBUTE20
, SAR.SAR_ATTRIBUTE21
, SAR.SAR_ATTRIBUTE22
, SAR.SAR_ATTRIBUTE23
, SAR.SAR_ATTRIBUTE24
, SAR.SAR_ATTRIBUTE25
, SAR.SAR_ATTRIBUTE26
, SAR.SAR_ATTRIBUTE27
, SAR.SAR_ATTRIBUTE28
, SAR.SAR_ATTRIBUTE29
, SAR.SAR_ATTRIBUTE30
, SAR.LAST_UPDATE_DATE
, SAR.LAST_UPDATED_BY
, SAR.LAST_UPDATE_LOGIN
, SAR.CREATED_BY
, SAR.CREATION_DATE
, SAR.OBJECT_VERSION_NUMBER
FROM BEN_SVC_AREA_RT_F SAR
WHERE SAR.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND SAR.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns