VIEW: APPS.BEN_ELIGY_PRFL_RL_D

Source

View Text - Preformatted

SELECT erl.ROWID row_id, erl.eligy_prfl_rl_id, erl.effective_start_date, erl.effective_end_date, erl.ordr_to_aply_num, formula.formula_name, eligy_prfl.NAME, drvbl_fctr_apls.meaning, erl.criteria_weight, erl.criteria_score, erl.last_update_date, fuser.user_name FROM ben_eligy_prfl_rl_f erl, fnd_user fuser, ff_formulas_f formula, ben_eligy_prfl_f eligy_prfl, hr_lookups drvbl_fctr_apls WHERE fuser.user_id(+) = erl.last_updated_by AND formula.formula_id(+) = erl.formula_id AND eligy_prfl.eligy_prfl_id(+) = erl.eligy_prfl_id AND drvbl_fctr_apls.lookup_code(+) = erl.drvbl_fctr_apls_flag AND drvbl_fctr_apls.lookup_type(+) = 'YES_NO' AND erl.effective_start_date BETWEEN eligy_prfl.effective_start_date(+) AND eligy_prfl.effective_end_date(+) AND erl.effective_start_date BETWEEN formula.effective_start_date(+) AND formula.effective_end_date(+)

View Text - HTML Formatted

SELECT ERL.ROWID ROW_ID
, ERL.ELIGY_PRFL_RL_ID
, ERL.EFFECTIVE_START_DATE
, ERL.EFFECTIVE_END_DATE
, ERL.ORDR_TO_APLY_NUM
, FORMULA.FORMULA_NAME
, ELIGY_PRFL.NAME
, DRVBL_FCTR_APLS.MEANING
, ERL.CRITERIA_WEIGHT
, ERL.CRITERIA_SCORE
, ERL.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_ELIGY_PRFL_RL_F ERL
, FND_USER FUSER
, FF_FORMULAS_F FORMULA
, BEN_ELIGY_PRFL_F ELIGY_PRFL
, HR_LOOKUPS DRVBL_FCTR_APLS
WHERE FUSER.USER_ID(+) = ERL.LAST_UPDATED_BY
AND FORMULA.FORMULA_ID(+) = ERL.FORMULA_ID
AND ELIGY_PRFL.ELIGY_PRFL_ID(+) = ERL.ELIGY_PRFL_ID
AND DRVBL_FCTR_APLS.LOOKUP_CODE(+) = ERL.DRVBL_FCTR_APLS_FLAG
AND DRVBL_FCTR_APLS.LOOKUP_TYPE(+) = 'YES_NO'
AND ERL.EFFECTIVE_START_DATE BETWEEN ELIGY_PRFL.EFFECTIVE_START_DATE(+)
AND ELIGY_PRFL.EFFECTIVE_END_DATE(+)
AND ERL.EFFECTIVE_START_DATE BETWEEN FORMULA.EFFECTIVE_START_DATE(+)
AND FORMULA.EFFECTIVE_END_DATE(+)