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_PCT_FL_TM_RT

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

View Text

SELECT PFR.PCT_FL_TM_RT_ID
, PFR.EFFECTIVE_START_DATE
, PFR.EFFECTIVE_END_DATE
, PFR.BUSINESS_GROUP_ID
, PFR.VRBL_RT_PRFL_ID
, PFR.PCT_FL_TM_FCTR_ID
, PFR.EXCLD_FLAG
, PFR.ORDR_NUM
, PFR.PFR_ATTRIBUTE_CATEGORY
, PFR.PFR_ATTRIBUTE1
, PFR.PFR_ATTRIBUTE2
, PFR.PFR_ATTRIBUTE3
, PFR.PFR_ATTRIBUTE4
, PFR.PFR_ATTRIBUTE5
, PFR.PFR_ATTRIBUTE6
, PFR.PFR_ATTRIBUTE7
, PFR.PFR_ATTRIBUTE8
, PFR.PFR_ATTRIBUTE9
, PFR.PFR_ATTRIBUTE10
, PFR.PFR_ATTRIBUTE11
, PFR.PFR_ATTRIBUTE12
, PFR.PFR_ATTRIBUTE13
, PFR.PFR_ATTRIBUTE14
, PFR.PFR_ATTRIBUTE15
, PFR.PFR_ATTRIBUTE16
, PFR.PFR_ATTRIBUTE17
, PFR.PFR_ATTRIBUTE18
, PFR.PFR_ATTRIBUTE19
, PFR.PFR_ATTRIBUTE20
, PFR.PFR_ATTRIBUTE21
, PFR.PFR_ATTRIBUTE22
, PFR.PFR_ATTRIBUTE23
, PFR.PFR_ATTRIBUTE24
, PFR.PFR_ATTRIBUTE25
, PFR.PFR_ATTRIBUTE26
, PFR.PFR_ATTRIBUTE27
, PFR.PFR_ATTRIBUTE28
, PFR.PFR_ATTRIBUTE29
, PFR.PFR_ATTRIBUTE30
, PFR.LAST_UPDATE_DATE
, PFR.LAST_UPDATED_BY
, PFR.LAST_UPDATE_LOGIN
, PFR.CREATED_BY
, PFR.CREATION_DATE
, PFR.OBJECT_VERSION_NUMBER
FROM BEN_PCT_FL_TM_RT_F PFR
WHERE PFR.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND PFR.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns

Name
PCT_FL_TM_RT_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
BUSINESS_GROUP_ID
VRBL_RT_PRFL_ID
PCT_FL_TM_FCTR_ID
EXCLD_FLAG
ORDR_NUM
PFR_ATTRIBUTE_CATEGORY
PFR_ATTRIBUTE1
PFR_ATTRIBUTE2
PFR_ATTRIBUTE3
PFR_ATTRIBUTE4
PFR_ATTRIBUTE5
PFR_ATTRIBUTE6
PFR_ATTRIBUTE7
PFR_ATTRIBUTE8
PFR_ATTRIBUTE9
PFR_ATTRIBUTE10
PFR_ATTRIBUTE11
PFR_ATTRIBUTE12
PFR_ATTRIBUTE13
PFR_ATTRIBUTE14
PFR_ATTRIBUTE15
PFR_ATTRIBUTE16
PFR_ATTRIBUTE17
PFR_ATTRIBUTE18
PFR_ATTRIBUTE19
PFR_ATTRIBUTE20
PFR_ATTRIBUTE21
PFR_ATTRIBUTE22
PFR_ATTRIBUTE23
PFR_ATTRIBUTE24
PFR_ATTRIBUTE25
PFR_ATTRIBUTE26
PFR_ATTRIBUTE27
PFR_ATTRIBUTE28
PFR_ATTRIBUTE29
PFR_ATTRIBUTE30
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER