VIEW: APPS.BEN_ELIG_SCHEDD_HRS_PRTE

Source

View Text - Preformatted

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.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 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'))

View Text - HTML Formatted

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.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
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'))