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