VIEW: APPS.BEN_PY_BSS_RT

Source

View Text - Preformatted

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'))

View Text - HTML Formatted

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'))