Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_SVC_AREA_PSTL_ZIP_RNG_V1 |
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
, RZR.FROM_VALUE
, RZR.TO_VALUE
, RZR.FROM_VALUE || DECODE(NVL(RZR.TO_VALUE
, '*')
, '*'
, ' '
, ' -- ' ||TO_VALUE) PSTL_ZIP_RNG_ID_NAME
FROM BEN_SVC_AREA_PSTL_ZIP_RNG_F SAZ
, BEN_PSTL_ZIP_RNG_F RZR
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND RZR.PSTL_ZIP_RNG_ID = SAZ.PSTL_ZIP_RNG_ID
AND SE.EFFECTIVE_DATE BETWEEN SAZ.EFFECTIVE_START_DATE
AND SAZ.EFFECTIVE_END_DATE
AND SE.EFFECTIVE_DATE BETWEEN RZR.EFFECTIVE_START_DATE
AND RZR.EFFECTIVE_END_DATE
AND RZR.BUSINESS_GROUP_ID = SAZ.BUSINESS_GROUP_ID