VIEW: APPS.BEN_ELIG_WK_LOC_PRTE_D

Source

View Text - Preformatted

SELECT ewl.elig_wk_loc_prte_id, ewl.effective_start_date, ewl.effective_end_date, ewl.ordr_num, loc.location_code, hl1.meaning, ewl.criteria_weight, ewl.criteria_score, ewl.last_update_date, fuser.user_name, eligy_prfl.NAME FROM ben_elig_wk_loc_prte_f ewl, hr_lookups hl1, hr_locations loc, fnd_user fuser, ben_eligy_prfl_f eligy_prfl WHERE hl1.lookup_code(+) = ewl.excld_flag AND hl1.lookup_type(+) = 'YES_NO' AND loc.location_id = ewl.location_id AND ewl.effective_start_date <= NVL (loc.inactive_date, ewl.effective_start_date) AND fuser.user_id(+) = ewl.last_updated_by AND ewl.eligy_prfl_id = eligy_prfl.eligy_prfl_id(+) AND ewl.effective_start_date BETWEEN eligy_prfl.effective_start_date(+) AND eligy_prfl.effective_end_date(+)

View Text - HTML Formatted

SELECT EWL.ELIG_WK_LOC_PRTE_ID
, EWL.EFFECTIVE_START_DATE
, EWL.EFFECTIVE_END_DATE
, EWL.ORDR_NUM
, LOC.LOCATION_CODE
, HL1.MEANING
, EWL.CRITERIA_WEIGHT
, EWL.CRITERIA_SCORE
, EWL.LAST_UPDATE_DATE
, FUSER.USER_NAME
, ELIGY_PRFL.NAME
FROM BEN_ELIG_WK_LOC_PRTE_F EWL
, HR_LOOKUPS HL1
, HR_LOCATIONS LOC
, FND_USER FUSER
, BEN_ELIGY_PRFL_F ELIGY_PRFL
WHERE HL1.LOOKUP_CODE(+) = EWL.EXCLD_FLAG
AND HL1.LOOKUP_TYPE(+) = 'YES_NO'
AND LOC.LOCATION_ID = EWL.LOCATION_ID
AND EWL.EFFECTIVE_START_DATE <= NVL (LOC.INACTIVE_DATE
, EWL.EFFECTIVE_START_DATE)
AND FUSER.USER_ID(+) = EWL.LAST_UPDATED_BY
AND EWL.ELIGY_PRFL_ID = ELIGY_PRFL.ELIGY_PRFL_ID(+)
AND EWL.EFFECTIVE_START_DATE BETWEEN ELIGY_PRFL.EFFECTIVE_START_DATE(+)
AND ELIGY_PRFL.EFFECTIVE_END_DATE(+)