VIEW: APPS.BEN_ELIG_SP_CLNG_PRG_PRTE_X

Source

View Text - Preformatted

SELECT elig_sp_clng_prg_prte_id ,effective_START_DATE ,effective_END_DATE ,BUSINESS_GROUP_ID ,eligy_prfl_id ,excld_flag ,special_ceiling_step_id , ESP.CRITERIA_SCORE , ESP.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 WHERE TRUNC(SYSDATE) BETWEEN ESP.effective_START_DATE AND ESP.effective_END_DATE

View Text - HTML Formatted

SELECT ELIG_SP_CLNG_PRG_PRTE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, ELIGY_PRFL_ID
, EXCLD_FLAG
, SPECIAL_CEILING_STEP_ID
, ESP.CRITERIA_SCORE
, ESP.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
WHERE TRUNC(SYSDATE) BETWEEN ESP.EFFECTIVE_START_DATE
AND ESP.EFFECTIVE_END_DATE