VIEW: APPS.BEN_POPL_ENRT_TYP_CYCL_V

Source

View Text - Preformatted

SELECT PET.ROWID ROW_ID , PET.POPL_ENRT_TYP_CYCL_ID , PET.EFFECTIVE_START_DATE , PET.EFFECTIVE_END_DATE , PET.BUSINESS_GROUP_ID , PET.ENRT_TYP_CYCL_CD , PET.PL_ID , PET.PGM_ID , PET.PET_ATTRIBUTE_CATEGORY , PET.PET_ATTRIBUTE1 , PET.PET_ATTRIBUTE2 , PET.PET_ATTRIBUTE3 , PET.PET_ATTRIBUTE4 , PET.PET_ATTRIBUTE5 , PET.PET_ATTRIBUTE6 , PET.PET_ATTRIBUTE7 , PET.PET_ATTRIBUTE8 , PET.PET_ATTRIBUTE9 , PET.PET_ATTRIBUTE10 , PET.PET_ATTRIBUTE11 , PET.PET_ATTRIBUTE12 , PET.PET_ATTRIBUTE13 , PET.PET_ATTRIBUTE14 , PET.PET_ATTRIBUTE15 , PET.PET_ATTRIBUTE16 , PET.PET_ATTRIBUTE17 , PET.PET_ATTRIBUTE18 , PET.PET_ATTRIBUTE19 , PET.PET_ATTRIBUTE20 , PET.PET_ATTRIBUTE21 , PET.PET_ATTRIBUTE22 , PET.PET_ATTRIBUTE23 , PET.PET_ATTRIBUTE24 , PET.PET_ATTRIBUTE25 , PET.PET_ATTRIBUTE26 , PET.PET_ATTRIBUTE27 , PET.PET_ATTRIBUTE28 , PET.PET_ATTRIBUTE29 , PET.PET_ATTRIBUTE30 , PET.LAST_UPDATE_DATE , PET.LAST_UPDATED_BY , PET.LAST_UPDATE_LOGIN , PET.CREATED_BY , PET.CREATION_DATE , PET.OBJECT_VERSION_NUMBER FROM BEN_POPL_ENRT_TYP_CYCL_F PET, FND_SESSIONS SE WHERE SE.SESSION_ID = USERENV('sessionid') AND SE.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE AND PET.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT PET.ROWID ROW_ID
, PET.POPL_ENRT_TYP_CYCL_ID
, PET.EFFECTIVE_START_DATE
, PET.EFFECTIVE_END_DATE
, PET.BUSINESS_GROUP_ID
, PET.ENRT_TYP_CYCL_CD
, PET.PL_ID
, PET.PGM_ID
, PET.PET_ATTRIBUTE_CATEGORY
, PET.PET_ATTRIBUTE1
, PET.PET_ATTRIBUTE2
, PET.PET_ATTRIBUTE3
, PET.PET_ATTRIBUTE4
, PET.PET_ATTRIBUTE5
, PET.PET_ATTRIBUTE6
, PET.PET_ATTRIBUTE7
, PET.PET_ATTRIBUTE8
, PET.PET_ATTRIBUTE9
, PET.PET_ATTRIBUTE10
, PET.PET_ATTRIBUTE11
, PET.PET_ATTRIBUTE12
, PET.PET_ATTRIBUTE13
, PET.PET_ATTRIBUTE14
, PET.PET_ATTRIBUTE15
, PET.PET_ATTRIBUTE16
, PET.PET_ATTRIBUTE17
, PET.PET_ATTRIBUTE18
, PET.PET_ATTRIBUTE19
, PET.PET_ATTRIBUTE20
, PET.PET_ATTRIBUTE21
, PET.PET_ATTRIBUTE22
, PET.PET_ATTRIBUTE23
, PET.PET_ATTRIBUTE24
, PET.PET_ATTRIBUTE25
, PET.PET_ATTRIBUTE26
, PET.PET_ATTRIBUTE27
, PET.PET_ATTRIBUTE28
, PET.PET_ATTRIBUTE29
, PET.PET_ATTRIBUTE30
, PET.LAST_UPDATE_DATE
, PET.LAST_UPDATED_BY
, PET.LAST_UPDATE_LOGIN
, PET.CREATED_BY
, PET.CREATION_DATE
, PET.OBJECT_VERSION_NUMBER
FROM BEN_POPL_ENRT_TYP_CYCL_F PET
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE