VIEW: APPS.BEN_ELIG_QUA_IN_GR_PRTE_D

Source

View Text - Preformatted

SELECT eqg.elig_qua_in_gr_prte_id, eqg.effective_start_date, eqg.effective_end_date, hr_general.decode_lookup ('BEN_CWB_QUAR_IN_GRD', eqg.quar_in_grade_cd ), hr_general.decode_lookup ('YES_NO', eqg.excld_flag), elp.NAME, eqg.ordr_num, eqg.criteria_score, eqg.criteria_weight, eqg.last_update_date, fuser.user_name FROM ben_elig_qua_in_gr_prte_f eqg, fnd_user_view fuser, ben_eligy_prfl_f elp WHERE fuser.user_id(+) = eqg.last_updated_by AND eqg.eligy_prfl_id = elp.eligy_prfl_id(+) AND eqg.effective_start_date BETWEEN elp.effective_start_date(+) AND elp.effective_end_date(+)

View Text - HTML Formatted

SELECT EQG.ELIG_QUA_IN_GR_PRTE_ID
, EQG.EFFECTIVE_START_DATE
, EQG.EFFECTIVE_END_DATE
, HR_GENERAL.DECODE_LOOKUP ('BEN_CWB_QUAR_IN_GRD'
, EQG.QUAR_IN_GRADE_CD )
, HR_GENERAL.DECODE_LOOKUP ('YES_NO'
, EQG.EXCLD_FLAG)
, ELP.NAME
, EQG.ORDR_NUM
, EQG.CRITERIA_SCORE
, EQG.CRITERIA_WEIGHT
, EQG.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_ELIG_QUA_IN_GR_PRTE_F EQG
, FND_USER_VIEW FUSER
, BEN_ELIGY_PRFL_F ELP
WHERE FUSER.USER_ID(+) = EQG.LAST_UPDATED_BY
AND EQG.ELIGY_PRFL_ID = ELP.ELIGY_PRFL_ID(+)
AND EQG.EFFECTIVE_START_DATE BETWEEN ELP.EFFECTIVE_START_DATE(+)
AND ELP.EFFECTIVE_END_DATE(+)