VIEW: APPS.BEN_ELIG_SP_CLNG_PRG_PRTE_D

Source

View Text - Preformatted

SELECT ESP.rowid ,ESP.elig_sp_clng_prg_prte_id ,ESP.effective_START_DATE ,ESP.effective_END_DATE ,ELP.name ,ESP.excld_flag ,ESP.special_ceiling_step_id , ESP.CRITERIA_SCORE , ESP.CRITERIA_WEIGHT ,ESP.LAST_UPDATE_DATE ,FUSER.USER_NAME FROM BEN_ELIG_sp_clng_prg_PRTE_F ESP, FND_USER FUSER, BEN_ELIGY_PRFL_F ELP WHERE FUSER.USER_ID (+)= ESP.LAST_UPDATED_BY AND ELP.ELIGY_PRFL_ID (+) = ESP.ELIGY_PRFL_ID

View Text - HTML Formatted

SELECT ESP.ROWID
, ESP.ELIG_SP_CLNG_PRG_PRTE_ID
, ESP.EFFECTIVE_START_DATE
, ESP.EFFECTIVE_END_DATE
, ELP.NAME
, ESP.EXCLD_FLAG
, ESP.SPECIAL_CEILING_STEP_ID
, ESP.CRITERIA_SCORE
, ESP.CRITERIA_WEIGHT
, ESP.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_ELIG_SP_CLNG_PRG_PRTE_F ESP
, FND_USER FUSER
, BEN_ELIGY_PRFL_F ELP
WHERE FUSER.USER_ID (+)= ESP.LAST_UPDATED_BY
AND ELP.ELIGY_PRFL_ID (+) = ESP.ELIGY_PRFL_ID