Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_PER_IN_ORG_ROLE |
SELECT PSR.PER_IN_ORG_ROLE_ID
, PSR.EFFECTIVE_START_DATE
, PSR.EFFECTIVE_END_DATE
, PSR.BUSINESS_GROUP_ID
, PSR.PER_IN_ORG_UNIT_ID
, PSR.PSR_ATTRIBUTE_CATEGORY
, PSR.PSR_ATTRIBUTE1
, PSR.PSR_ATTRIBUTE2
, PSR.PSR_ATTRIBUTE3
, PSR.PSR_ATTRIBUTE4
, PSR.PSR_ATTRIBUTE5
, PSR.PSR_ATTRIBUTE6
, PSR.PSR_ATTRIBUTE7
, PSR.PSR_ATTRIBUTE8
, PSR.PSR_ATTRIBUTE9
, PSR.PSR_ATTRIBUTE10
, PSR.PSR_ATTRIBUTE11
, PSR.PSR_ATTRIBUTE12
, PSR.PSR_ATTRIBUTE13
, PSR.PSR_ATTRIBUTE14
, PSR.PSR_ATTRIBUTE15
, PSR.PSR_ATTRIBUTE16
, PSR.PSR_ATTRIBUTE17
, PSR.PSR_ATTRIBUTE18
, PSR.PSR_ATTRIBUTE19
, PSR.PSR_ATTRIBUTE20
, PSR.PSR_ATTRIBUTE21
, PSR.PSR_ATTRIBUTE22
, PSR.PSR_ATTRIBUTE23
, PSR.PSR_ATTRIBUTE24
, PSR.PSR_ATTRIBUTE25
, PSR.PSR_ATTRIBUTE26
, PSR.PSR_ATTRIBUTE27
, PSR.PSR_ATTRIBUTE28
, PSR.PSR_ATTRIBUTE29
, PSR.PSR_ATTRIBUTE30
, PSR.LAST_UPDATE_DATE
, PSR.LAST_UPDATED_BY
, PSR.LAST_UPDATE_LOGIN
, PSR.CREATED_BY
, PSR.CREATION_DATE
, PSR.OBJECT_VERSION_NUMBER
FROM BEN_PER_IN_ORG_ROLE_F PSR
WHERE PSR.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND PSR.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))