VIEW: APPS.BEN_CMBN_PTIP

Source

View Text - Preformatted

SELECT CBP.CMBN_PTIP_ID , CBP.EFFECTIVE_START_DATE , CBP.EFFECTIVE_END_DATE , CBP.NAME , CBP.PGM_ID , CBP.BUSINESS_GROUP_ID , CBP.CBP_ATTRIBUTE_CATEGORY , CBP.CBP_ATTRIBUTE1 , CBP.CBP_ATTRIBUTE2 , CBP.CBP_ATTRIBUTE3 , CBP.CBP_ATTRIBUTE4 , CBP.CBP_ATTRIBUTE5 , CBP.CBP_ATTRIBUTE6 , CBP.CBP_ATTRIBUTE7 , CBP.CBP_ATTRIBUTE8 , CBP.CBP_ATTRIBUTE9 , CBP.CBP_ATTRIBUTE10 , CBP.CBP_ATTRIBUTE11 , CBP.CBP_ATTRIBUTE12 , CBP.CBP_ATTRIBUTE13 , CBP.CBP_ATTRIBUTE14 , CBP.CBP_ATTRIBUTE15 , CBP.CBP_ATTRIBUTE16 , CBP.CBP_ATTRIBUTE17 , CBP.CBP_ATTRIBUTE18 , CBP.CBP_ATTRIBUTE19 , CBP.CBP_ATTRIBUTE20 , CBP.CBP_ATTRIBUTE21 , CBP.CBP_ATTRIBUTE22 , CBP.CBP_ATTRIBUTE23 , CBP.CBP_ATTRIBUTE24 , CBP.CBP_ATTRIBUTE25 , CBP.CBP_ATTRIBUTE26 , CBP.CBP_ATTRIBUTE27 , CBP.CBP_ATTRIBUTE28 , CBP.CBP_ATTRIBUTE29 , CBP.CBP_ATTRIBUTE30 , CBP.LAST_UPDATE_DATE , CBP.LAST_UPDATED_BY , CBP.LAST_UPDATE_LOGIN , CBP.CREATED_BY , CBP.CREATION_DATE , CBP.OBJECT_VERSION_NUMBER FROM BEN_CMBN_PTIP_F CBP WHERE CBP.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid')) AND CBP.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid'))

View Text - HTML Formatted

SELECT CBP.CMBN_PTIP_ID
, CBP.EFFECTIVE_START_DATE
, CBP.EFFECTIVE_END_DATE
, CBP.NAME
, CBP.PGM_ID
, CBP.BUSINESS_GROUP_ID
, CBP.CBP_ATTRIBUTE_CATEGORY
, CBP.CBP_ATTRIBUTE1
, CBP.CBP_ATTRIBUTE2
, CBP.CBP_ATTRIBUTE3
, CBP.CBP_ATTRIBUTE4
, CBP.CBP_ATTRIBUTE5
, CBP.CBP_ATTRIBUTE6
, CBP.CBP_ATTRIBUTE7
, CBP.CBP_ATTRIBUTE8
, CBP.CBP_ATTRIBUTE9
, CBP.CBP_ATTRIBUTE10
, CBP.CBP_ATTRIBUTE11
, CBP.CBP_ATTRIBUTE12
, CBP.CBP_ATTRIBUTE13
, CBP.CBP_ATTRIBUTE14
, CBP.CBP_ATTRIBUTE15
, CBP.CBP_ATTRIBUTE16
, CBP.CBP_ATTRIBUTE17
, CBP.CBP_ATTRIBUTE18
, CBP.CBP_ATTRIBUTE19
, CBP.CBP_ATTRIBUTE20
, CBP.CBP_ATTRIBUTE21
, CBP.CBP_ATTRIBUTE22
, CBP.CBP_ATTRIBUTE23
, CBP.CBP_ATTRIBUTE24
, CBP.CBP_ATTRIBUTE25
, CBP.CBP_ATTRIBUTE26
, CBP.CBP_ATTRIBUTE27
, CBP.CBP_ATTRIBUTE28
, CBP.CBP_ATTRIBUTE29
, CBP.CBP_ATTRIBUTE30
, CBP.LAST_UPDATE_DATE
, CBP.LAST_UPDATED_BY
, CBP.LAST_UPDATE_LOGIN
, CBP.CREATED_BY
, CBP.CREATION_DATE
, CBP.OBJECT_VERSION_NUMBER
FROM BEN_CMBN_PTIP_F CBP
WHERE CBP.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND CBP.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))