Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_ELIG_PER_TYP_PRTE_V |
SELECT EPT.ROWID ROW_ID
, EPT.ELIG_PER_TYP_PRTE_ID
, EPT.EFFECTIVE_START_DATE
, EPT.EFFECTIVE_END_DATE
, EPT.BUSINESS_GROUP_ID
, EPT.ELIGY_PRFL_ID
, EPT.PER_TYP_CD
, EPT.PERSON_TYPE_ID
, EPT.ORDR_NUM
, EPT.EXCLD_FLAG
, EPT.CRITERIA_SCORE
, EPT.CRITERIA_WEIGHT
, EPT.EPT_ATTRIBUTE_CATEGORY
, EPT.EPT_ATTRIBUTE1
, EPT.EPT_ATTRIBUTE2
, EPT.EPT_ATTRIBUTE3
, EPT.EPT_ATTRIBUTE4
, EPT.EPT_ATTRIBUTE5
, EPT.EPT_ATTRIBUTE6
, EPT.EPT_ATTRIBUTE7
, EPT.EPT_ATTRIBUTE8
, EPT.EPT_ATTRIBUTE9
, EPT.EPT_ATTRIBUTE10
, EPT.EPT_ATTRIBUTE11
, EPT.EPT_ATTRIBUTE12
, EPT.EPT_ATTRIBUTE13
, EPT.EPT_ATTRIBUTE14
, EPT.EPT_ATTRIBUTE15
, EPT.EPT_ATTRIBUTE16
, EPT.EPT_ATTRIBUTE17
, EPT.EPT_ATTRIBUTE18
, EPT.EPT_ATTRIBUTE19
, EPT.EPT_ATTRIBUTE20
, EPT.EPT_ATTRIBUTE21
, EPT.EPT_ATTRIBUTE22
, EPT.EPT_ATTRIBUTE23
, EPT.EPT_ATTRIBUTE24
, EPT.EPT_ATTRIBUTE25
, EPT.EPT_ATTRIBUTE26
, EPT.EPT_ATTRIBUTE27
, EPT.EPT_ATTRIBUTE28
, EPT.EPT_ATTRIBUTE29
, EPT.EPT_ATTRIBUTE30
, EPT.LAST_UPDATE_DATE
, EPT.LAST_UPDATED_BY
, EPT.LAST_UPDATE_LOGIN
, EPT.CREATED_BY
, EPT.CREATION_DATE
, EPT.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_PER_TYP_PRTE_F EPT
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN EPT.EFFECTIVE_START_DATE
AND EPT.EFFECTIVE_END_DATE