VIEW: APPS.BEN_ELIG_FL_TM_PT_TM_PRTE_D

Source

View Text - Preformatted

SELECT efp.ROWID row_id, efp.elig_fl_tm_pt_tm_prte_id, efp.effective_start_date, efp.effective_end_date, eligy_prfl.NAME, efp.ordr_num, fl_tm_pt_tm.meaning, excld.meaning, efp.criteria_weight, efp.criteria_score, efp.last_update_date, fuser.user_name FROM ben_elig_fl_tm_pt_tm_prte_f efp, fnd_user fuser, ben_eligy_prfl_f eligy_prfl, hr_lookups fl_tm_pt_tm, hr_lookups excld WHERE fuser.user_id(+) = efp.last_updated_by AND eligy_prfl.eligy_prfl_id(+) = efp.eligy_prfl_id AND fl_tm_pt_tm.lookup_code(+) = efp.fl_tm_pt_tm_cd AND fl_tm_pt_tm.lookup_type(+) = 'EMP_CAT' AND excld.lookup_code(+) = efp.excld_flag AND excld.lookup_type(+) = 'YES_NO' AND efp.effective_start_date BETWEEN eligy_prfl.effective_start_date(+) AND eligy_prfl.effective_end_date(+)

View Text - HTML Formatted

SELECT EFP.ROWID ROW_ID
, EFP.ELIG_FL_TM_PT_TM_PRTE_ID
, EFP.EFFECTIVE_START_DATE
, EFP.EFFECTIVE_END_DATE
, ELIGY_PRFL.NAME
, EFP.ORDR_NUM
, FL_TM_PT_TM.MEANING
, EXCLD.MEANING
, EFP.CRITERIA_WEIGHT
, EFP.CRITERIA_SCORE
, EFP.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_ELIG_FL_TM_PT_TM_PRTE_F EFP
, FND_USER FUSER
, BEN_ELIGY_PRFL_F ELIGY_PRFL
, HR_LOOKUPS FL_TM_PT_TM
, HR_LOOKUPS EXCLD
WHERE FUSER.USER_ID(+) = EFP.LAST_UPDATED_BY
AND ELIGY_PRFL.ELIGY_PRFL_ID(+) = EFP.ELIGY_PRFL_ID
AND FL_TM_PT_TM.LOOKUP_CODE(+) = EFP.FL_TM_PT_TM_CD
AND FL_TM_PT_TM.LOOKUP_TYPE(+) = 'EMP_CAT'
AND EXCLD.LOOKUP_CODE(+) = EFP.EXCLD_FLAG
AND EXCLD.LOOKUP_TYPE(+) = 'YES_NO'
AND EFP.EFFECTIVE_START_DATE BETWEEN ELIGY_PRFL.EFFECTIVE_START_DATE(+)
AND ELIGY_PRFL.EFFECTIVE_END_DATE(+)