Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_ELIG_SCHEDD_HRS_PRTE |
SELECT 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.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
WHERE ESH.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND ESH.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))