Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_ELIG_ORG_UNIT_PRTE_V |
SELECT EOU.ROWID ROW_ID
, EOU.ELIG_ORG_UNIT_PRTE_ID
, EOU.EFFECTIVE_START_DATE
, EOU.EFFECTIVE_END_DATE
, EOU.BUSINESS_GROUP_ID
, EOU.ELIGY_PRFL_ID
, EOU.ORGANIZATION_ID
, EOU.EXCLD_FLAG
, EOU.ORDR_NUM
, EOU.CRITERIA_SCORE
, EOU.CRITERIA_WEIGHT
, EOU.EOU_ATTRIBUTE_CATEGORY
, EOU.EOU_ATTRIBUTE1
, EOU.EOU_ATTRIBUTE2
, EOU.EOU_ATTRIBUTE3
, EOU.EOU_ATTRIBUTE4
, EOU.EOU_ATTRIBUTE5
, EOU.EOU_ATTRIBUTE6
, EOU.EOU_ATTRIBUTE7
, EOU.EOU_ATTRIBUTE8
, EOU.EOU_ATTRIBUTE9
, EOU.EOU_ATTRIBUTE10
, EOU.EOU_ATTRIBUTE11
, EOU.EOU_ATTRIBUTE12
, EOU.EOU_ATTRIBUTE13
, EOU.EOU_ATTRIBUTE14
, EOU.EOU_ATTRIBUTE15
, EOU.EOU_ATTRIBUTE16
, EOU.EOU_ATTRIBUTE17
, EOU.EOU_ATTRIBUTE18
, EOU.EOU_ATTRIBUTE19
, EOU.EOU_ATTRIBUTE20
, EOU.EOU_ATTRIBUTE21
, EOU.EOU_ATTRIBUTE22
, EOU.EOU_ATTRIBUTE23
, EOU.EOU_ATTRIBUTE24
, EOU.EOU_ATTRIBUTE25
, EOU.EOU_ATTRIBUTE26
, EOU.EOU_ATTRIBUTE27
, EOU.EOU_ATTRIBUTE28
, EOU.EOU_ATTRIBUTE29
, EOU.EOU_ATTRIBUTE30
, EOU.LAST_UPDATE_DATE
, EOU.LAST_UPDATED_BY
, EOU.LAST_UPDATE_LOGIN
, EOU.CREATED_BY
, EOU.CREATION_DATE
, EOU.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_ORG_UNIT_PRTE_F EOU
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN EOU.EFFECTIVE_START_DATE
AND EOU.EFFECTIVE_END_DATE