Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_PER_IN_LGL_ENTY |
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'))