View: BEN_PTD_BAL_TYP

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

View Text

SELECT PBY.PTD_BAL_TYP_ID
, PBY.EFFECTIVE_START_DATE
, PBY.EFFECTIVE_END_DATE
, PBY.CLG_AMT
, PBY.FLR_AMT
, PBY.PTD_LMT_ID
, PBY.COMP_LVL_FCTR_ID
, PBY.BUSINESS_GROUP_ID
, PBY.PBY_ATTRIBUTE_CATEGORY
, PBY.PBY_ATTRIBUTE1
, PBY.PBY_ATTRIBUTE2
, PBY.PBY_ATTRIBUTE3
, PBY.PBY_ATTRIBUTE4
, PBY.PBY_ATTRIBUTE5
, PBY.PBY_ATTRIBUTE6
, PBY.PBY_ATTRIBUTE7
, PBY.PBY_ATTRIBUTE8
, PBY.PBY_ATTRIBUTE9
, PBY.PBY_ATTRIBUTE10
, PBY.PBY_ATTRIBUTE11
, PBY.PBY_ATTRIBUTE12
, PBY.PBY_ATTRIBUTE13
, PBY.PBY_ATTRIBUTE14
, PBY.PBY_ATTRIBUTE15
, PBY.PBY_ATTRIBUTE16
, PBY.PBY_ATTRIBUTE17
, PBY.PBY_ATTRIBUTE18
, PBY.PBY_ATTRIBUTE19
, PBY.PBY_ATTRIBUTE20
, PBY.PBY_ATTRIBUTE21
, PBY.PBY_ATTRIBUTE22
, PBY.PBY_ATTRIBUTE23
, PBY.PBY_ATTRIBUTE24
, PBY.PBY_ATTRIBUTE25
, PBY.PBY_ATTRIBUTE26
, PBY.PBY_ATTRIBUTE27
, PBY.PBY_ATTRIBUTE28
, PBY.PBY_ATTRIBUTE29
, PBY.PBY_ATTRIBUTE30
, PBY.LAST_UPDATE_DATE
, PBY.LAST_UPDATED_BY
, PBY.LAST_UPDATE_LOGIN
, PBY.CREATED_BY
, PBY.CREATION_DATE
, PBY.OBJECT_VERSION_NUMBER
FROM BEN_PTD_BAL_TYP_F PBY
WHERE PBY.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND PBY.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns