Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_ORG_UNIT_RT |
SELECT OUR.ORG_UNIT_RT_ID
, OUR.EFFECTIVE_START_DATE
, OUR.EFFECTIVE_END_DATE
, OUR.BUSINESS_GROUP_ID
, OUR.VRBL_RT_PRFL_ID
, OUR.ORGANIZATION_ID
, OUR.EXCLD_FLAG
, OUR.ORDR_NUM
, OUR.OUR_ATTRIBUTE_CATEGORY
, OUR.OUR_ATTRIBUTE1
, OUR.OUR_ATTRIBUTE2
, OUR.OUR_ATTRIBUTE3
, OUR.OUR_ATTRIBUTE4
, OUR.OUR_ATTRIBUTE5
, OUR.OUR_ATTRIBUTE6
, OUR.OUR_ATTRIBUTE7
, OUR.OUR_ATTRIBUTE8
, OUR.OUR_ATTRIBUTE9
, OUR.OUR_ATTRIBUTE10
, OUR.OUR_ATTRIBUTE11
, OUR.OUR_ATTRIBUTE12
, OUR.OUR_ATTRIBUTE13
, OUR.OUR_ATTRIBUTE14
, OUR.OUR_ATTRIBUTE15
, OUR.OUR_ATTRIBUTE16
, OUR.OUR_ATTRIBUTE17
, OUR.OUR_ATTRIBUTE18
, OUR.OUR_ATTRIBUTE19
, OUR.OUR_ATTRIBUTE20
, OUR.OUR_ATTRIBUTE21
, OUR.OUR_ATTRIBUTE22
, OUR.OUR_ATTRIBUTE23
, OUR.OUR_ATTRIBUTE24
, OUR.OUR_ATTRIBUTE25
, OUR.OUR_ATTRIBUTE26
, OUR.OUR_ATTRIBUTE27
, OUR.OUR_ATTRIBUTE28
, OUR.OUR_ATTRIBUTE29
, OUR.OUR_ATTRIBUTE30
, OUR.LAST_UPDATE_DATE
, OUR.LAST_UPDATED_BY
, OUR.LAST_UPDATE_LOGIN
, OUR.CREATED_BY
, OUR.CREATION_DATE
, OUR.OBJECT_VERSION_NUMBER
FROM BEN_ORG_UNIT_RT_F OUR
WHERE OUR.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND OUR.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))