View: BEN_PTD_LMT_V

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

View Text

SELECT PDL.ROWID ROW_ID
, PDL.PTD_LMT_ID
, PDL.EFFECTIVE_START_DATE
, PDL.EFFECTIVE_END_DATE
, PDL.NAME
, PDL.MX_COMP_TO_CNSDR
, PDL.MX_VAL
, PDL.MX_PCT_VAL
, PDL.PTD_LMT_CALC_RL
, PDL.LMT_DET_CD
, PDL.COMP_LVL_FCTR_ID
, PDL.BALANCE_TYPE_ID
, PDL.BUSINESS_GROUP_ID
, PDL.PDL_ATTRIBUTE_CATEGORY
, PDL.PDL_ATTRIBUTE1
, PDL.PDL_ATTRIBUTE2
, PDL.PDL_ATTRIBUTE3
, PDL.PDL_ATTRIBUTE4
, PDL.PDL_ATTRIBUTE5
, PDL.PDL_ATTRIBUTE6
, PDL.PDL_ATTRIBUTE7
, PDL.PDL_ATTRIBUTE8
, PDL.PDL_ATTRIBUTE9
, PDL.PDL_ATTRIBUTE10
, PDL.PDL_ATTRIBUTE11
, PDL.PDL_ATTRIBUTE12
, PDL.PDL_ATTRIBUTE13
, PDL.PDL_ATTRIBUTE14
, PDL.PDL_ATTRIBUTE15
, PDL.PDL_ATTRIBUTE16
, PDL.PDL_ATTRIBUTE17
, PDL.PDL_ATTRIBUTE18
, PDL.PDL_ATTRIBUTE19
, PDL.PDL_ATTRIBUTE20
, PDL.PDL_ATTRIBUTE21
, PDL.PDL_ATTRIBUTE22
, PDL.PDL_ATTRIBUTE23
, PDL.PDL_ATTRIBUTE24
, PDL.PDL_ATTRIBUTE25
, PDL.PDL_ATTRIBUTE26
, PDL.PDL_ATTRIBUTE27
, PDL.PDL_ATTRIBUTE28
, PDL.PDL_ATTRIBUTE29
, PDL.PDL_ATTRIBUTE30
, PDL.LAST_UPDATE_DATE
, PDL.LAST_UPDATED_BY
, PDL.LAST_UPDATE_LOGIN
, PDL.CREATED_BY
, PDL.CREATION_DATE
, PDL.OBJECT_VERSION_NUMBER
FROM BEN_PTD_LMT_F PDL
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN PDL.EFFECTIVE_START_DATE
AND PDL.EFFECTIVE_END_DATE

Columns