VIEW: APPS.BEN_PER_IN_LGL_ENTY

Source

View Text - Preformatted

SELECT PLE.PER_IN_LGL_ENTY_ID , PLE.EFFECTIVE_START_DATE , PLE.EFFECTIVE_END_DATE , PLE.BUSINESS_GROUP_ID , PLE.PERSON_ID , PLE.PCT_OWND_VAL , PLE.OFCR_FLAG , PLE.PLE_ATTRIBUTE_CATEGORY , PLE.PLE_ATTRIBUTE1 , PLE.PLE_ATTRIBUTE2 , PLE.PLE_ATTRIBUTE3 , PLE.PLE_ATTRIBUTE4 , PLE.PLE_ATTRIBUTE5 , PLE.PLE_ATTRIBUTE6 , PLE.PLE_ATTRIBUTE7 , PLE.PLE_ATTRIBUTE8 , PLE.PLE_ATTRIBUTE9 , PLE.PLE_ATTRIBUTE10 , PLE.PLE_ATTRIBUTE11 , PLE.PLE_ATTRIBUTE12 , PLE.PLE_ATTRIBUTE13 , PLE.PLE_ATTRIBUTE14 , PLE.PLE_ATTRIBUTE15 , PLE.PLE_ATTRIBUTE16 , PLE.PLE_ATTRIBUTE17 , PLE.PLE_ATTRIBUTE18 , PLE.PLE_ATTRIBUTE19 , PLE.PLE_ATTRIBUTE20 , PLE.PLE_ATTRIBUTE21 , PLE.PLE_ATTRIBUTE22 , PLE.PLE_ATTRIBUTE23 , PLE.PLE_ATTRIBUTE24 , PLE.PLE_ATTRIBUTE25 , PLE.PLE_ATTRIBUTE26 , PLE.PLE_ATTRIBUTE27 , PLE.PLE_ATTRIBUTE28 , PLE.PLE_ATTRIBUTE29 , PLE.PLE_ATTRIBUTE30 , PLE.LAST_UPDATE_DATE , PLE.LAST_UPDATED_BY , PLE.LAST_UPDATE_LOGIN , PLE.CREATED_BY , PLE.CREATION_DATE , PLE.OBJECT_VERSION_NUMBER FROM BEN_PER_IN_LGL_ENTY_F PLE WHERE PLE.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid')) AND PLE.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid'))

View Text - HTML Formatted

SELECT PLE.PER_IN_LGL_ENTY_ID
, PLE.EFFECTIVE_START_DATE
, PLE.EFFECTIVE_END_DATE
, PLE.BUSINESS_GROUP_ID
, PLE.PERSON_ID
, PLE.PCT_OWND_VAL
, PLE.OFCR_FLAG
, PLE.PLE_ATTRIBUTE_CATEGORY
, PLE.PLE_ATTRIBUTE1
, PLE.PLE_ATTRIBUTE2
, PLE.PLE_ATTRIBUTE3
, PLE.PLE_ATTRIBUTE4
, PLE.PLE_ATTRIBUTE5
, PLE.PLE_ATTRIBUTE6
, PLE.PLE_ATTRIBUTE7
, PLE.PLE_ATTRIBUTE8
, PLE.PLE_ATTRIBUTE9
, PLE.PLE_ATTRIBUTE10
, PLE.PLE_ATTRIBUTE11
, PLE.PLE_ATTRIBUTE12
, PLE.PLE_ATTRIBUTE13
, PLE.PLE_ATTRIBUTE14
, PLE.PLE_ATTRIBUTE15
, PLE.PLE_ATTRIBUTE16
, PLE.PLE_ATTRIBUTE17
, PLE.PLE_ATTRIBUTE18
, PLE.PLE_ATTRIBUTE19
, PLE.PLE_ATTRIBUTE20
, PLE.PLE_ATTRIBUTE21
, PLE.PLE_ATTRIBUTE22
, PLE.PLE_ATTRIBUTE23
, PLE.PLE_ATTRIBUTE24
, PLE.PLE_ATTRIBUTE25
, PLE.PLE_ATTRIBUTE26
, PLE.PLE_ATTRIBUTE27
, PLE.PLE_ATTRIBUTE28
, PLE.PLE_ATTRIBUTE29
, PLE.PLE_ATTRIBUTE30
, PLE.LAST_UPDATE_DATE
, PLE.LAST_UPDATED_BY
, PLE.LAST_UPDATE_LOGIN
, PLE.CREATED_BY
, PLE.CREATION_DATE
, PLE.OBJECT_VERSION_NUMBER
FROM BEN_PER_IN_LGL_ENTY_F PLE
WHERE PLE.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND PLE.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))