Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_ELIG_SCHEDD_HRS_PRTE_V |
SELECT ESH.ROWID ROW_ID
, ESH.ELIG_SCHEDD_HRS_PRTE_ID
, ESH.EFFECTIVE_START_DATE
, ESH.EFFECTIVE_END_DATE
, ESH.BUSINESS_GROUP_ID
, ESH.HRS_NUM
, ESH.FREQ_CD
, ESH.ORDR_NUM
, ESH.EXCLD_FLAG
, ESH.ELIGY_PRFL_ID
, ESH.MAX_HRS_NUM
, ESH.SCHEDD_HRS_RL
, ESH.DETERMINATION_CD
, ESH.DETERMINATION_RL
, ESH.ROUNDING_CD
, ESH.ROUNDING_RL
, ESH.CRITERIA_SCORE
, ESH.CRITERIA_WEIGHT
, ESH.ESH_ATTRIBUTE_CATEGORY
, ESH.ESH_ATTRIBUTE1
, ESH.ESH_ATTRIBUTE2
, ESH.ESH_ATTRIBUTE3
, ESH.ESH_ATTRIBUTE4
, ESH.ESH_ATTRIBUTE5
, ESH.ESH_ATTRIBUTE6
, ESH.ESH_ATTRIBUTE7
, ESH.ESH_ATTRIBUTE8
, ESH.ESH_ATTRIBUTE9
, ESH.ESH_ATTRIBUTE10
, ESH.ESH_ATTRIBUTE11
, ESH.ESH_ATTRIBUTE12
, ESH.ESH_ATTRIBUTE13
, ESH.ESH_ATTRIBUTE14
, ESH.ESH_ATTRIBUTE15
, ESH.ESH_ATTRIBUTE16
, ESH.ESH_ATTRIBUTE17
, ESH.ESH_ATTRIBUTE18
, ESH.ESH_ATTRIBUTE19
, ESH.ESH_ATTRIBUTE20
, ESH.ESH_ATTRIBUTE21
, ESH.ESH_ATTRIBUTE22
, ESH.ESH_ATTRIBUTE23
, ESH.ESH_ATTRIBUTE24
, ESH.ESH_ATTRIBUTE25
, ESH.ESH_ATTRIBUTE26
, ESH.ESH_ATTRIBUTE27
, ESH.ESH_ATTRIBUTE28
, ESH.ESH_ATTRIBUTE29
, ESH.ESH_ATTRIBUTE30
, ESH.LAST_UPDATE_DATE
, ESH.LAST_UPDATED_BY
, ESH.LAST_UPDATE_LOGIN
, ESH.CREATED_BY
, ESH.CREATION_DATE
, ESH.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_SCHEDD_HRS_PRTE_F ESH
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN ESH.EFFECTIVE_START_DATE
AND ESH.EFFECTIVE_END_DATE