Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_SVC_AREA_PSTL_ZIP_RNG_V |
SELECT SAZ.ROWID ROW_ID
, SAZ.SVC_AREA_PSTL_ZIP_RNG_ID
, SAZ.EFFECTIVE_START_DATE
, SAZ.EFFECTIVE_END_DATE
, SAZ.SVC_AREA_ID
, SAZ.PSTL_ZIP_RNG_ID
, SAZ.BUSINESS_GROUP_ID
, SAZ.SAZ_ATTRIBUTE_CATEGORY
, SAZ.SAZ_ATTRIBUTE1
, SAZ.SAZ_ATTRIBUTE2
, SAZ.SAZ_ATTRIBUTE3
, SAZ.SAZ_ATTRIBUTE4
, SAZ.SAZ_ATTRIBUTE5
, SAZ.SAZ_ATTRIBUTE6
, SAZ.SAZ_ATTRIBUTE7
, SAZ.SAZ_ATTRIBUTE8
, SAZ.SAZ_ATTRIBUTE9
, SAZ.SAZ_ATTRIBUTE10
, SAZ.SAZ_ATTRIBUTE11
, SAZ.SAZ_ATTRIBUTE12
, SAZ.SAZ_ATTRIBUTE13
, SAZ.SAZ_ATTRIBUTE14
, SAZ.SAZ_ATTRIBUTE15
, SAZ.SAZ_ATTRIBUTE16
, SAZ.SAZ_ATTRIBUTE17
, SAZ.SAZ_ATTRIBUTE18
, SAZ.SAZ_ATTRIBUTE19
, SAZ.SAZ_ATTRIBUTE20
, SAZ.SAZ_ATTRIBUTE21
, SAZ.SAZ_ATTRIBUTE22
, SAZ.SAZ_ATTRIBUTE23
, SAZ.SAZ_ATTRIBUTE24
, SAZ.SAZ_ATTRIBUTE25
, SAZ.SAZ_ATTRIBUTE26
, SAZ.SAZ_ATTRIBUTE27
, SAZ.SAZ_ATTRIBUTE28
, SAZ.SAZ_ATTRIBUTE29
, SAZ.SAZ_ATTRIBUTE30
, SAZ.LAST_UPDATE_DATE
, SAZ.LAST_UPDATED_BY
, SAZ.LAST_UPDATE_LOGIN
, SAZ.CREATED_BY
, SAZ.CREATION_DATE
, SAZ.OBJECT_VERSION_NUMBER
FROM BEN_SVC_AREA_PSTL_ZIP_RNG_F SAZ
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN SAZ.EFFECTIVE_START_DATE
AND SAZ.EFFECTIVE_END_DATE