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_CNTNG_PRTN_ELIG_PRFL

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

View Text

SELECT CGP.CNTNG_PRTN_ELIG_PRFL_ID
, CGP.EFFECTIVE_START_DATE
, CGP.EFFECTIVE_END_DATE
, CGP.ELIGY_PRFL_ID
, CGP.NAME
, CGP.PYMT_MUST_BE_RCVD_UOM
, CGP.PYMT_MUST_BE_RCVD_NUM
, CGP.PYMT_MUST_BE_RCVD_RL
, CGP.BUSINESS_GROUP_ID
, CGP.CGP_ATTRIBUTE_CATEGORY
, CGP.CGP_ATTRIBUTE1
, CGP.CGP_ATTRIBUTE2
, CGP.CGP_ATTRIBUTE3
, CGP.CGP_ATTRIBUTE4
, CGP.CGP_ATTRIBUTE5
, CGP.CGP_ATTRIBUTE6
, CGP.CGP_ATTRIBUTE7
, CGP.CGP_ATTRIBUTE8
, CGP.CGP_ATTRIBUTE9
, CGP.CGP_ATTRIBUTE10
, CGP.CGP_ATTRIBUTE11
, CGP.CGP_ATTRIBUTE12
, CGP.CGP_ATTRIBUTE13
, CGP.CGP_ATTRIBUTE14
, CGP.CGP_ATTRIBUTE15
, CGP.CGP_ATTRIBUTE16
, CGP.CGP_ATTRIBUTE17
, CGP.CGP_ATTRIBUTE18
, CGP.CGP_ATTRIBUTE19
, CGP.CGP_ATTRIBUTE20
, CGP.CGP_ATTRIBUTE21
, CGP.CGP_ATTRIBUTE22
, CGP.CGP_ATTRIBUTE23
, CGP.CGP_ATTRIBUTE24
, CGP.CGP_ATTRIBUTE25
, CGP.CGP_ATTRIBUTE26
, CGP.CGP_ATTRIBUTE27
, CGP.CGP_ATTRIBUTE28
, CGP.CGP_ATTRIBUTE29
, CGP.CGP_ATTRIBUTE30
, CGP.LAST_UPDATE_DATE
, CGP.LAST_UPDATED_BY
, CGP.LAST_UPDATE_LOGIN
, CGP.CREATED_BY
, CGP.CREATION_DATE
, CGP.OBJECT_VERSION_NUMBER
FROM BEN_CNTNG_PRTN_ELIG_PRFL_F CGP
WHERE CGP.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND CGP.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns

Name
CNTNG_PRTN_ELIG_PRFL_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
ELIGY_PRFL_ID
NAME
PYMT_MUST_BE_RCVD_UOM
PYMT_MUST_BE_RCVD_NUM
PYMT_MUST_BE_RCVD_RL
BUSINESS_GROUP_ID
CGP_ATTRIBUTE_CATEGORY
CGP_ATTRIBUTE1
CGP_ATTRIBUTE2
CGP_ATTRIBUTE3
CGP_ATTRIBUTE4
CGP_ATTRIBUTE5
CGP_ATTRIBUTE6
CGP_ATTRIBUTE7
CGP_ATTRIBUTE8
CGP_ATTRIBUTE9
CGP_ATTRIBUTE10
CGP_ATTRIBUTE11
CGP_ATTRIBUTE12
CGP_ATTRIBUTE13
CGP_ATTRIBUTE14
CGP_ATTRIBUTE15
CGP_ATTRIBUTE16
CGP_ATTRIBUTE17
CGP_ATTRIBUTE18
CGP_ATTRIBUTE19
CGP_ATTRIBUTE20
CGP_ATTRIBUTE21
CGP_ATTRIBUTE22
CGP_ATTRIBUTE23
CGP_ATTRIBUTE24
CGP_ATTRIBUTE25
CGP_ATTRIBUTE26
CGP_ATTRIBUTE27
CGP_ATTRIBUTE28
CGP_ATTRIBUTE29
CGP_ATTRIBUTE30
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER