VIEW: APPS.BEN_ELIG_SP_CLNG_PRG_PRTE_V

Source

View Text - Preformatted

SELECT esp.rowid ,elig_sp_clng_prg_prte_id ,EFFECTIVE_START_DATE ,EFFECTIVE_END_DATE ,BUSINESS_GROUP_ID ,eligy_prfl_id ,excld_flag ,special_ceiling_step_id ,ordr_num , CRITERIA_SCORE , CRITERIA_WEIGHT ,esp_ATTRIBUTE_CATEGORY ,esp_ATTRIBUTE1 ,esp_ATTRIBUTE2 ,esp_ATTRIBUTE3 ,esp_ATTRIBUTE4 ,esp_ATTRIBUTE5 ,esp_ATTRIBUTE6 ,esp_ATTRIBUTE7 ,esp_ATTRIBUTE8 ,esp_ATTRIBUTE9 ,esp_ATTRIBUTE10 ,esp_ATTRIBUTE11 ,esp_ATTRIBUTE12 ,esp_ATTRIBUTE13 ,esp_ATTRIBUTE14 ,esp_ATTRIBUTE15 ,esp_ATTRIBUTE16 ,esp_ATTRIBUTE17 ,esp_ATTRIBUTE18 ,esp_ATTRIBUTE19 ,esp_ATTRIBUTE20 ,esp_ATTRIBUTE21 ,esp_ATTRIBUTE22 ,esp_ATTRIBUTE23 ,esp_ATTRIBUTE24 ,esp_ATTRIBUTE25 ,esp_ATTRIBUTE26 ,esp_ATTRIBUTE27 ,esp_ATTRIBUTE28 ,esp_ATTRIBUTE29 ,esp_ATTRIBUTE30 ,LAST_UPDATE_DATE ,LAST_UPDATED_BY ,LAST_UPDATE_LOGIN ,CREATED_BY ,CREATION_DATE ,OBJECT_VERSION_NUMBER from ben_elig_sp_clng_prg_prte_f esp, fnd_sessions se WHERE se.session_id = userenv('sessionid') and effective_date between effective_start_date and effective_end_date

View Text - HTML Formatted

SELECT ESP.ROWID
, ELIG_SP_CLNG_PRG_PRTE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, ELIGY_PRFL_ID
, EXCLD_FLAG
, SPECIAL_CEILING_STEP_ID
, ORDR_NUM
, CRITERIA_SCORE
, CRITERIA_WEIGHT
, ESP_ATTRIBUTE_CATEGORY
, ESP_ATTRIBUTE1
, ESP_ATTRIBUTE2
, ESP_ATTRIBUTE3
, ESP_ATTRIBUTE4
, ESP_ATTRIBUTE5
, ESP_ATTRIBUTE6
, ESP_ATTRIBUTE7
, ESP_ATTRIBUTE8
, ESP_ATTRIBUTE9
, ESP_ATTRIBUTE10
, ESP_ATTRIBUTE11
, ESP_ATTRIBUTE12
, ESP_ATTRIBUTE13
, ESP_ATTRIBUTE14
, ESP_ATTRIBUTE15
, ESP_ATTRIBUTE16
, ESP_ATTRIBUTE17
, ESP_ATTRIBUTE18
, ESP_ATTRIBUTE19
, ESP_ATTRIBUTE20
, ESP_ATTRIBUTE21
, ESP_ATTRIBUTE22
, ESP_ATTRIBUTE23
, ESP_ATTRIBUTE24
, ESP_ATTRIBUTE25
, ESP_ATTRIBUTE26
, ESP_ATTRIBUTE27
, ESP_ATTRIBUTE28
, ESP_ATTRIBUTE29
, ESP_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM BEN_ELIG_SP_CLNG_PRG_PRTE_F ESP
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE