Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_PTD_BAL_TYP_V |
SELECT PBY.ROWID ROW_ID
, 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
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN PBY.EFFECTIVE_START_DATE
AND PBY.EFFECTIVE_END_DATE