VIEW: APPS.BEN_ELIG_COMP_LVL_PRTE_D

Source

View Text - Preformatted

SELECT ecl.ROWID row_id, ecl.elig_comp_lvl_prte_id, ecl.effective_start_date, ecl.effective_end_date, comp_lvl_fctr.NAME, eligy_prfl.NAME, excld.meaning, ecl.ordr_num, ecl.criteria_weight, ecl.criteria_score, ecl.last_update_date, fuser.user_name FROM ben_elig_comp_lvl_prte_f ecl, fnd_user fuser, ben_comp_lvl_fctr comp_lvl_fctr, ben_eligy_prfl_f eligy_prfl, hr_lookups excld WHERE fuser.user_id(+) = ecl.last_updated_by AND comp_lvl_fctr.comp_lvl_fctr_id(+) = ecl.comp_lvl_fctr_id AND eligy_prfl.eligy_prfl_id(+) = ecl.eligy_prfl_id AND excld.lookup_code(+) = ecl.excld_flag AND excld.lookup_type(+) = 'YES_NO' AND ecl.effective_start_date BETWEEN eligy_prfl.effective_start_date(+) AND eligy_prfl.effective_end_date(+)

View Text - HTML Formatted

SELECT ECL.ROWID ROW_ID
, ECL.ELIG_COMP_LVL_PRTE_ID
, ECL.EFFECTIVE_START_DATE
, ECL.EFFECTIVE_END_DATE
, COMP_LVL_FCTR.NAME
, ELIGY_PRFL.NAME
, EXCLD.MEANING
, ECL.ORDR_NUM
, ECL.CRITERIA_WEIGHT
, ECL.CRITERIA_SCORE
, ECL.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_ELIG_COMP_LVL_PRTE_F ECL
, FND_USER FUSER
, BEN_COMP_LVL_FCTR COMP_LVL_FCTR
, BEN_ELIGY_PRFL_F ELIGY_PRFL
, HR_LOOKUPS EXCLD
WHERE FUSER.USER_ID(+) = ECL.LAST_UPDATED_BY
AND COMP_LVL_FCTR.COMP_LVL_FCTR_ID(+) = ECL.COMP_LVL_FCTR_ID
AND ELIGY_PRFL.ELIGY_PRFL_ID(+) = ECL.ELIGY_PRFL_ID
AND EXCLD.LOOKUP_CODE(+) = ECL.EXCLD_FLAG
AND EXCLD.LOOKUP_TYPE(+) = 'YES_NO'
AND ECL.EFFECTIVE_START_DATE BETWEEN ELIGY_PRFL.EFFECTIVE_START_DATE(+)
AND ELIGY_PRFL.EFFECTIVE_END_DATE(+)