eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: BEN_CMBN_PTIP

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

View Text

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

Columns

Name
CMBN_PTIP_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
NAME
PGM_ID
BUSINESS_GROUP_ID
CBP_ATTRIBUTE_CATEGORY
CBP_ATTRIBUTE1
CBP_ATTRIBUTE2
CBP_ATTRIBUTE3
CBP_ATTRIBUTE4
CBP_ATTRIBUTE5
CBP_ATTRIBUTE6
CBP_ATTRIBUTE7
CBP_ATTRIBUTE8
CBP_ATTRIBUTE9
CBP_ATTRIBUTE10
CBP_ATTRIBUTE11
CBP_ATTRIBUTE12
CBP_ATTRIBUTE13
CBP_ATTRIBUTE14
CBP_ATTRIBUTE15
CBP_ATTRIBUTE16
CBP_ATTRIBUTE17
CBP_ATTRIBUTE18
CBP_ATTRIBUTE19
CBP_ATTRIBUTE20
CBP_ATTRIBUTE21
CBP_ATTRIBUTE22
CBP_ATTRIBUTE23
CBP_ATTRIBUTE24
CBP_ATTRIBUTE25
CBP_ATTRIBUTE26
CBP_ATTRIBUTE27
CBP_ATTRIBUTE28
CBP_ATTRIBUTE29
CBP_ATTRIBUTE30
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER