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_PL_GD_R_SVC_CTFN

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

View Text

SELECT PCT.PL_GD_R_SVC_CTFN_ID
, PCT.EFFECTIVE_START_DATE
, PCT.EFFECTIVE_END_DATE
, PCT.BUSINESS_GROUP_ID
, PCT.PL_GD_OR_SVC_ID
, PCT.PFD_FLAG
, PCT.LACK_CTFN_DENY_RMBMT_FLAG
, PCT.RQD_FLAG
, PCT.RMBMT_CTFN_TYP_CD
, PCT.LACK_CTFN_DENY_RMBMT_RL
, PCT.CTFN_RQD_WHEN_RL
, PCT.PCT_ATTRIBUTE_CATEGORY
, PCT.PCT_ATTRIBUTE1
, PCT.PCT_ATTRIBUTE2
, PCT.PCT_ATTRIBUTE3
, PCT.PCT_ATTRIBUTE4
, PCT.PCT_ATTRIBUTE5
, PCT.PCT_ATTRIBUTE6
, PCT.PCT_ATTRIBUTE7
, PCT.PCT_ATTRIBUTE8
, PCT.PCT_ATTRIBUTE9
, PCT.PCT_ATTRIBUTE10
, PCT.PCT_ATTRIBUTE11
, PCT.PCT_ATTRIBUTE12
, PCT.PCT_ATTRIBUTE13
, PCT.PCT_ATTRIBUTE14
, PCT.PCT_ATTRIBUTE15
, PCT.PCT_ATTRIBUTE16
, PCT.PCT_ATTRIBUTE17
, PCT.PCT_ATTRIBUTE18
, PCT.PCT_ATTRIBUTE19
, PCT.PCT_ATTRIBUTE20
, PCT.PCT_ATTRIBUTE21
, PCT.PCT_ATTRIBUTE22
, PCT.PCT_ATTRIBUTE23
, PCT.PCT_ATTRIBUTE24
, PCT.PCT_ATTRIBUTE25
, PCT.PCT_ATTRIBUTE26
, PCT.PCT_ATTRIBUTE27
, PCT.PCT_ATTRIBUTE28
, PCT.PCT_ATTRIBUTE29
, PCT.PCT_ATTRIBUTE30
, PCT.LAST_UPDATE_DATE
, PCT.LAST_UPDATED_BY
, PCT.LAST_UPDATE_LOGIN
, PCT.CREATED_BY
, PCT.CREATION_DATE
, PCT.OBJECT_VERSION_NUMBER
FROM BEN_PL_GD_R_SVC_CTFN_F PCT
WHERE PCT.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND PCT.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns

Name
PL_GD_R_SVC_CTFN_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
BUSINESS_GROUP_ID
PL_GD_OR_SVC_ID
PFD_FLAG
LACK_CTFN_DENY_RMBMT_FLAG
RQD_FLAG
RMBMT_CTFN_TYP_CD
LACK_CTFN_DENY_RMBMT_RL
CTFN_RQD_WHEN_RL
PCT_ATTRIBUTE_CATEGORY
PCT_ATTRIBUTE1
PCT_ATTRIBUTE2
PCT_ATTRIBUTE3
PCT_ATTRIBUTE4
PCT_ATTRIBUTE5
PCT_ATTRIBUTE6
PCT_ATTRIBUTE7
PCT_ATTRIBUTE8
PCT_ATTRIBUTE9
PCT_ATTRIBUTE10
PCT_ATTRIBUTE11
PCT_ATTRIBUTE12
PCT_ATTRIBUTE13
PCT_ATTRIBUTE14
PCT_ATTRIBUTE15
PCT_ATTRIBUTE16
PCT_ATTRIBUTE17
PCT_ATTRIBUTE18
PCT_ATTRIBUTE19
PCT_ATTRIBUTE20
PCT_ATTRIBUTE21
PCT_ATTRIBUTE22
PCT_ATTRIBUTE23
PCT_ATTRIBUTE24
PCT_ATTRIBUTE25
PCT_ATTRIBUTE26
PCT_ATTRIBUTE27
PCT_ATTRIBUTE28
PCT_ATTRIBUTE29
PCT_ATTRIBUTE30
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER