View: BEN_PY_BSS_RT

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

View Text

SELECT PBR.PY_BSS_RT_ID
, PBR.EFFECTIVE_START_DATE
, PBR.EFFECTIVE_END_DATE
, PBR.VRBL_RT_PRFL_ID
, PBR.PAY_BASIS_ID
, PBR.EXCLD_FLAG
, PBR.ORDR_NUM
, PBR.BUSINESS_GROUP_ID
, PBR.PBR_ATTRIBUTE_CATEGORY
, PBR.PBR_ATTRIBUTE1
, PBR.PBR_ATTRIBUTE2
, PBR.PBR_ATTRIBUTE3
, PBR.PBR_ATTRIBUTE4
, PBR.PBR_ATTRIBUTE5
, PBR.PBR_ATTRIBUTE6
, PBR.PBR_ATTRIBUTE7
, PBR.PBR_ATTRIBUTE8
, PBR.PBR_ATTRIBUTE9
, PBR.PBR_ATTRIBUTE10
, PBR.PBR_ATTRIBUTE11
, PBR.PBR_ATTRIBUTE12
, PBR.PBR_ATTRIBUTE13
, PBR.PBR_ATTRIBUTE14
, PBR.PBR_ATTRIBUTE15
, PBR.PBR_ATTRIBUTE16
, PBR.PBR_ATTRIBUTE17
, PBR.PBR_ATTRIBUTE18
, PBR.PBR_ATTRIBUTE19
, PBR.PBR_ATTRIBUTE20
, PBR.PBR_ATTRIBUTE21
, PBR.PBR_ATTRIBUTE22
, PBR.PBR_ATTRIBUTE23
, PBR.PBR_ATTRIBUTE24
, PBR.PBR_ATTRIBUTE25
, PBR.PBR_ATTRIBUTE26
, PBR.PBR_ATTRIBUTE27
, PBR.PBR_ATTRIBUTE28
, PBR.PBR_ATTRIBUTE29
, PBR.PBR_ATTRIBUTE30
, PBR.LAST_UPDATE_DATE
, PBR.LAST_UPDATED_BY
, PBR.LAST_UPDATE_LOGIN
, PBR.CREATED_BY
, PBR.CREATION_DATE
, PBR.OBJECT_VERSION_NUMBER
FROM BEN_PY_BSS_RT_F PBR
WHERE PBR.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND PBR.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns