VIEW: APPS.BEN_PPL_GRP_RT_V

Source

View Text - Preformatted

SELECT pgr.ROWID ROW_ID, pgr.PPL_GRP_RT_ID ,pgr.EFFECTIVE_START_DATE ,pgr.EFFECTIVE_END_DATE ,pgr.ORDR_NUM ,pgr.EXCLD_FLAG ,pgr.VRBL_RT_PRFL_ID ,pgr.PEOPLE_GROUP_ID ,pgr.BUSINESS_GROUP_ID ,pgr.PGR_ATTRIBUTE_CATEGORY ,pgr.PGR_ATTRIBUTE1 ,pgr.PGR_ATTRIBUTE2 ,pgr.PGR_ATTRIBUTE3 ,pgr.PGR_ATTRIBUTE4 ,pgr.PGR_ATTRIBUTE5 ,pgr.PGR_ATTRIBUTE6 ,pgr.PGR_ATTRIBUTE7 ,pgr.PGR_ATTRIBUTE8 ,pgr.PGR_ATTRIBUTE9 ,pgr.PGR_ATTRIBUTE10 ,pgr.PGR_ATTRIBUTE11 ,pgr.PGR_ATTRIBUTE12 ,pgr.PGR_ATTRIBUTE13 ,pgr.PGR_ATTRIBUTE14 ,pgr.PGR_ATTRIBUTE15 ,pgr.PGR_ATTRIBUTE16 ,pgr.PGR_ATTRIBUTE17 ,pgr.PGR_ATTRIBUTE18 ,pgr.PGR_ATTRIBUTE19 ,pgr.PGR_ATTRIBUTE20 ,pgr.PGR_ATTRIBUTE21 ,pgr.PGR_ATTRIBUTE22 ,pgr.PGR_ATTRIBUTE23 ,pgr.PGR_ATTRIBUTE24 ,pgr.PGR_ATTRIBUTE25 ,pgr.PGR_ATTRIBUTE26 ,pgr.PGR_ATTRIBUTE27 ,pgr.PGR_ATTRIBUTE28 ,pgr.PGR_ATTRIBUTE29 ,pgr.PGR_ATTRIBUTE30 ,pgr.LAST_UPDATE_DATE ,pgr.LAST_UPDATED_BY ,pgr.LAST_UPDATE_LOGIN ,pgr.CREATED_BY ,pgr.CREATION_DATE ,pgr.OBJECT_VERSION_NUMBER from BEN_PPL_GRP_RT_F pgr, fnd_sessions se WHERE se.session_id = userenv('sessionid') and se.effective_date between pgr.effective_start_date and pgr.effective_end_date

View Text - HTML Formatted

SELECT PGR.ROWID ROW_ID
, PGR.PPL_GRP_RT_ID
, PGR.EFFECTIVE_START_DATE
, PGR.EFFECTIVE_END_DATE
, PGR.ORDR_NUM
, PGR.EXCLD_FLAG
, PGR.VRBL_RT_PRFL_ID
, PGR.PEOPLE_GROUP_ID
, PGR.BUSINESS_GROUP_ID
, PGR.PGR_ATTRIBUTE_CATEGORY
, PGR.PGR_ATTRIBUTE1
, PGR.PGR_ATTRIBUTE2
, PGR.PGR_ATTRIBUTE3
, PGR.PGR_ATTRIBUTE4
, PGR.PGR_ATTRIBUTE5
, PGR.PGR_ATTRIBUTE6
, PGR.PGR_ATTRIBUTE7
, PGR.PGR_ATTRIBUTE8
, PGR.PGR_ATTRIBUTE9
, PGR.PGR_ATTRIBUTE10
, PGR.PGR_ATTRIBUTE11
, PGR.PGR_ATTRIBUTE12
, PGR.PGR_ATTRIBUTE13
, PGR.PGR_ATTRIBUTE14
, PGR.PGR_ATTRIBUTE15
, PGR.PGR_ATTRIBUTE16
, PGR.PGR_ATTRIBUTE17
, PGR.PGR_ATTRIBUTE18
, PGR.PGR_ATTRIBUTE19
, PGR.PGR_ATTRIBUTE20
, PGR.PGR_ATTRIBUTE21
, PGR.PGR_ATTRIBUTE22
, PGR.PGR_ATTRIBUTE23
, PGR.PGR_ATTRIBUTE24
, PGR.PGR_ATTRIBUTE25
, PGR.PGR_ATTRIBUTE26
, PGR.PGR_ATTRIBUTE27
, PGR.PGR_ATTRIBUTE28
, PGR.PGR_ATTRIBUTE29
, PGR.PGR_ATTRIBUTE30
, PGR.LAST_UPDATE_DATE
, PGR.LAST_UPDATED_BY
, PGR.LAST_UPDATE_LOGIN
, PGR.CREATED_BY
, PGR.CREATION_DATE
, PGR.OBJECT_VERSION_NUMBER
FROM BEN_PPL_GRP_RT_F PGR
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN PGR.EFFECTIVE_START_DATE
AND PGR.EFFECTIVE_END_DATE