VIEW: APPS.BEN_ELIGY_CRIT_VALUES_D

Source

View Text - Preformatted

SELECT ecv.eligy_crit_values_id , elp.name , egl.name , ecv.effective_start_date , ecv.effective_end_date , ecv.ordr_num , ecv.number_value1 , ecv.number_value2 , ecv.char_value1 , ecv.char_value2 , ecv.date_value1 , ecv.date_value2 , hr.meaning , ecv.legislation_code , ecv.char_value3 , ecv.char_value4 , ecv.number_value3 , ecv.number_value4 , ecv.date_value3 , ecv.date_value4 , ecv.criteria_score , ecv.criteria_weight , ecv.last_update_date , fuser.user_name , ecv.last_update_login FROM ben_eligy_crit_values_f ecv , fnd_user fuser , ben_eligy_criteria egl , ben_eligy_prfl_f elp , hr_lookups hr WHERE fuser.user_id(+) = ecv.last_updated_by and ecv.eligy_criteria_id = egl.eligy_criteria_id and ecv.excld_flag(+) = hr.lookup_code and hr.lookup_type = 'YES_NO' and ecv.eligy_prfl_id = elp.eligy_prfl_id and ecv.effective_start_date between elp.effective_start_date and elp.effective_end_date

View Text - HTML Formatted

SELECT ECV.ELIGY_CRIT_VALUES_ID
, ELP.NAME
, EGL.NAME
, ECV.EFFECTIVE_START_DATE
, ECV.EFFECTIVE_END_DATE
, ECV.ORDR_NUM
, ECV.NUMBER_VALUE1
, ECV.NUMBER_VALUE2
, ECV.CHAR_VALUE1
, ECV.CHAR_VALUE2
, ECV.DATE_VALUE1
, ECV.DATE_VALUE2
, HR.MEANING
, ECV.LEGISLATION_CODE
, ECV.CHAR_VALUE3
, ECV.CHAR_VALUE4
, ECV.NUMBER_VALUE3
, ECV.NUMBER_VALUE4
, ECV.DATE_VALUE3
, ECV.DATE_VALUE4
, ECV.CRITERIA_SCORE
, ECV.CRITERIA_WEIGHT
, ECV.LAST_UPDATE_DATE
, FUSER.USER_NAME
, ECV.LAST_UPDATE_LOGIN
FROM BEN_ELIGY_CRIT_VALUES_F ECV
, FND_USER FUSER
, BEN_ELIGY_CRITERIA EGL
, BEN_ELIGY_PRFL_F ELP
, HR_LOOKUPS HR
WHERE FUSER.USER_ID(+) = ECV.LAST_UPDATED_BY
AND ECV.ELIGY_CRITERIA_ID = EGL.ELIGY_CRITERIA_ID
AND ECV.EXCLD_FLAG(+) = HR.LOOKUP_CODE
AND HR.LOOKUP_TYPE = 'YES_NO'
AND ECV.ELIGY_PRFL_ID = ELP.ELIGY_PRFL_ID
AND ECV.EFFECTIVE_START_DATE BETWEEN ELP.EFFECTIVE_START_DATE
AND ELP.EFFECTIVE_END_DATE