VIEW: APPS.BEN_GNDR_RT

Source

View Text - Preformatted

SELECT GNR.GNDR_RT_ID , GNR.EFFECTIVE_START_DATE , GNR.EFFECTIVE_END_DATE , GNR.BUSINESS_GROUP_ID , GNR.VRBL_RT_PRFL_ID , GNR.ORDR_NUM , GNR.GNDR_CD , GNR.EXCLD_FLAG , GNR.GNR_ATTRIBUTE_CATEGORY , GNR.GNR_ATTRIBUTE1 , GNR.GNR_ATTRIBUTE2 , GNR.GNR_ATTRIBUTE3 , GNR.GNR_ATTRIBUTE4 , GNR.GNR_ATTRIBUTE5 , GNR.GNR_ATTRIBUTE6 , GNR.GNR_ATTRIBUTE7 , GNR.GNR_ATTRIBUTE8 , GNR.GNR_ATTRIBUTE9 , GNR.GNR_ATTRIBUTE10 , GNR.GNR_ATTRIBUTE11 , GNR.GNR_ATTRIBUTE12 , GNR.GNR_ATTRIBUTE13 , GNR.GNR_ATTRIBUTE14 , GNR.GNR_ATTRIBUTE15 , GNR.GNR_ATTRIBUTE16 , GNR.GNR_ATTRIBUTE17 , GNR.GNR_ATTRIBUTE18 , GNR.GNR_ATTRIBUTE19 , GNR.GNR_ATTRIBUTE20 , GNR.GNR_ATTRIBUTE21 , GNR.GNR_ATTRIBUTE22 , GNR.GNR_ATTRIBUTE23 , GNR.GNR_ATTRIBUTE24 , GNR.GNR_ATTRIBUTE25 , GNR.GNR_ATTRIBUTE26 , GNR.GNR_ATTRIBUTE27 , GNR.GNR_ATTRIBUTE28 , GNR.GNR_ATTRIBUTE29 , GNR.GNR_ATTRIBUTE30 , GNR.LAST_UPDATE_DATE , GNR.LAST_UPDATED_BY , GNR.LAST_UPDATE_LOGIN , GNR.CREATED_BY , GNR.CREATION_DATE , GNR.OBJECT_VERSION_NUMBER FROM BEN_GNDR_RT_F GNR WHERE GNR.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid')) AND GNR.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid'))

View Text - HTML Formatted

SELECT GNR.GNDR_RT_ID
, GNR.EFFECTIVE_START_DATE
, GNR.EFFECTIVE_END_DATE
, GNR.BUSINESS_GROUP_ID
, GNR.VRBL_RT_PRFL_ID
, GNR.ORDR_NUM
, GNR.GNDR_CD
, GNR.EXCLD_FLAG
, GNR.GNR_ATTRIBUTE_CATEGORY
, GNR.GNR_ATTRIBUTE1
, GNR.GNR_ATTRIBUTE2
, GNR.GNR_ATTRIBUTE3
, GNR.GNR_ATTRIBUTE4
, GNR.GNR_ATTRIBUTE5
, GNR.GNR_ATTRIBUTE6
, GNR.GNR_ATTRIBUTE7
, GNR.GNR_ATTRIBUTE8
, GNR.GNR_ATTRIBUTE9
, GNR.GNR_ATTRIBUTE10
, GNR.GNR_ATTRIBUTE11
, GNR.GNR_ATTRIBUTE12
, GNR.GNR_ATTRIBUTE13
, GNR.GNR_ATTRIBUTE14
, GNR.GNR_ATTRIBUTE15
, GNR.GNR_ATTRIBUTE16
, GNR.GNR_ATTRIBUTE17
, GNR.GNR_ATTRIBUTE18
, GNR.GNR_ATTRIBUTE19
, GNR.GNR_ATTRIBUTE20
, GNR.GNR_ATTRIBUTE21
, GNR.GNR_ATTRIBUTE22
, GNR.GNR_ATTRIBUTE23
, GNR.GNR_ATTRIBUTE24
, GNR.GNR_ATTRIBUTE25
, GNR.GNR_ATTRIBUTE26
, GNR.GNR_ATTRIBUTE27
, GNR.GNR_ATTRIBUTE28
, GNR.GNR_ATTRIBUTE29
, GNR.GNR_ATTRIBUTE30
, GNR.LAST_UPDATE_DATE
, GNR.LAST_UPDATED_BY
, GNR.LAST_UPDATE_LOGIN
, GNR.CREATED_BY
, GNR.CREATION_DATE
, GNR.OBJECT_VERSION_NUMBER
FROM BEN_GNDR_RT_F GNR
WHERE GNR.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND GNR.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))