VIEW: APPS.BEN_PTD_BAL_TYP

Source

View Text - Preformatted

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'))

View Text - HTML Formatted

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'))