VIEW: APPS.BEN_ELIG_PCT_FL_TM_PRTE_D

Source

View Text - Preformatted

SELECT epf.ROWID row_id, epf.elig_pct_fl_tm_prte_id, epf.effective_start_date, epf.effective_end_date, eligy_prfl.NAME, pct_fl_tm_fctr.NAME, excld.meaning, epf.ordr_num, epf.criteria_weight, epf.criteria_score, epf.last_update_date, fuser.user_name FROM ben_elig_pct_fl_tm_prte_f epf, fnd_user fuser, ben_eligy_prfl_f eligy_prfl, ben_pct_fl_tm_fctr pct_fl_tm_fctr, hr_lookups excld WHERE fuser.user_id(+) = epf.last_updated_by AND eligy_prfl.eligy_prfl_id(+) = epf.eligy_prfl_id AND pct_fl_tm_fctr.pct_fl_tm_fctr_id(+) = epf.pct_fl_tm_fctr_id AND excld.lookup_code(+) = epf.excld_flag AND excld.lookup_type(+) = 'YES_NO' AND epf.effective_start_date BETWEEN eligy_prfl.effective_start_date(+) AND eligy_prfl.effective_end_date(+)

View Text - HTML Formatted

SELECT EPF.ROWID ROW_ID
, EPF.ELIG_PCT_FL_TM_PRTE_ID
, EPF.EFFECTIVE_START_DATE
, EPF.EFFECTIVE_END_DATE
, ELIGY_PRFL.NAME
, PCT_FL_TM_FCTR.NAME
, EXCLD.MEANING
, EPF.ORDR_NUM
, EPF.CRITERIA_WEIGHT
, EPF.CRITERIA_SCORE
, EPF.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_ELIG_PCT_FL_TM_PRTE_F EPF
, FND_USER FUSER
, BEN_ELIGY_PRFL_F ELIGY_PRFL
, BEN_PCT_FL_TM_FCTR PCT_FL_TM_FCTR
, HR_LOOKUPS EXCLD
WHERE FUSER.USER_ID(+) = EPF.LAST_UPDATED_BY
AND ELIGY_PRFL.ELIGY_PRFL_ID(+) = EPF.ELIGY_PRFL_ID
AND PCT_FL_TM_FCTR.PCT_FL_TM_FCTR_ID(+) = EPF.PCT_FL_TM_FCTR_ID
AND EXCLD.LOOKUP_CODE(+) = EPF.EXCLD_FLAG
AND EXCLD.LOOKUP_TYPE(+) = 'YES_NO'
AND EPF.EFFECTIVE_START_DATE BETWEEN ELIGY_PRFL.EFFECTIVE_START_DATE(+)
AND ELIGY_PRFL.EFFECTIVE_END_DATE(+)