VIEW: APPS.BEN_ELIG_SCHEDD_HRS_PRTE_D

Source

View Text - Preformatted

SELECT esh.ROWID row_id, esh.elig_schedd_hrs_prte_id, esh.effective_start_date, esh.effective_end_date, esh.hrs_num, freq.meaning, esh.ordr_num, excld.meaning, eligy_prfl.NAME, esh.criteria_weight, esh.criteria_score, esh.last_update_date, fuser.user_name, hr_general.decode_lookup ('BEN_LOS_DET', esh.determination_cd), deter_rl.formula_name, esh.max_hrs_num, hr_general.decode_lookup ('BEN_RNDG', esh.rounding_cd), rndg_rl.formula_name, schdl_rl.formula_name FROM ben_elig_schedd_hrs_prte_f esh, fnd_user fuser, ben_eligy_prfl_f eligy_prfl, hr_lookups freq, hr_lookups excld, ff_formulas_f rndg_rl, ff_formulas_f schdl_rl, ff_formulas_f deter_rl WHERE fuser.user_id(+) = esh.last_updated_by AND eligy_prfl.eligy_prfl_id(+) = esh.eligy_prfl_id AND freq.lookup_code(+) = esh.freq_cd AND freq.lookup_type(+) = 'FREQUENCY' AND excld.lookup_code(+) = esh.excld_flag AND excld.lookup_type(+) = 'YES_NO' AND esh.effective_start_date BETWEEN eligy_prfl.effective_start_date(+) AND eligy_prfl.effective_end_date(+) AND esh.rounding_rl = rndg_rl.formula_id(+) AND esh.effective_start_date BETWEEN rndg_rl.effective_start_date(+) AND rndg_rl.effective_end_date(+) AND esh.schedd_hrs_rl = schdl_rl.formula_id(+) AND esh.effective_start_date BETWEEN schdl_rl.effective_start_date(+) AND schdl_rl.effective_end_date(+) AND esh.determination_rl = deter_rl.formula_id(+) AND esh.effective_start_date BETWEEN deter_rl.effective_start_date(+) AND deter_rl.effective_end_date(+)

View Text - HTML Formatted

SELECT ESH.ROWID ROW_ID
, ESH.ELIG_SCHEDD_HRS_PRTE_ID
, ESH.EFFECTIVE_START_DATE
, ESH.EFFECTIVE_END_DATE
, ESH.HRS_NUM
, FREQ.MEANING
, ESH.ORDR_NUM
, EXCLD.MEANING
, ELIGY_PRFL.NAME
, ESH.CRITERIA_WEIGHT
, ESH.CRITERIA_SCORE
, ESH.LAST_UPDATE_DATE
, FUSER.USER_NAME
, HR_GENERAL.DECODE_LOOKUP ('BEN_LOS_DET'
, ESH.DETERMINATION_CD)
, DETER_RL.FORMULA_NAME
, ESH.MAX_HRS_NUM
, HR_GENERAL.DECODE_LOOKUP ('BEN_RNDG'
, ESH.ROUNDING_CD)
, RNDG_RL.FORMULA_NAME
, SCHDL_RL.FORMULA_NAME
FROM BEN_ELIG_SCHEDD_HRS_PRTE_F ESH
, FND_USER FUSER
, BEN_ELIGY_PRFL_F ELIGY_PRFL
, HR_LOOKUPS FREQ
, HR_LOOKUPS EXCLD
, FF_FORMULAS_F RNDG_RL
, FF_FORMULAS_F SCHDL_RL
, FF_FORMULAS_F DETER_RL
WHERE FUSER.USER_ID(+) = ESH.LAST_UPDATED_BY
AND ELIGY_PRFL.ELIGY_PRFL_ID(+) = ESH.ELIGY_PRFL_ID
AND FREQ.LOOKUP_CODE(+) = ESH.FREQ_CD
AND FREQ.LOOKUP_TYPE(+) = 'FREQUENCY'
AND EXCLD.LOOKUP_CODE(+) = ESH.EXCLD_FLAG
AND EXCLD.LOOKUP_TYPE(+) = 'YES_NO'
AND ESH.EFFECTIVE_START_DATE BETWEEN ELIGY_PRFL.EFFECTIVE_START_DATE(+)
AND ELIGY_PRFL.EFFECTIVE_END_DATE(+)
AND ESH.ROUNDING_RL = RNDG_RL.FORMULA_ID(+)
AND ESH.EFFECTIVE_START_DATE BETWEEN RNDG_RL.EFFECTIVE_START_DATE(+)
AND RNDG_RL.EFFECTIVE_END_DATE(+)
AND ESH.SCHEDD_HRS_RL = SCHDL_RL.FORMULA_ID(+)
AND ESH.EFFECTIVE_START_DATE BETWEEN SCHDL_RL.EFFECTIVE_START_DATE(+)
AND SCHDL_RL.EFFECTIVE_END_DATE(+)
AND ESH.DETERMINATION_RL = DETER_RL.FORMULA_ID(+)
AND ESH.EFFECTIVE_START_DATE BETWEEN DETER_RL.EFFECTIVE_START_DATE(+)
AND DETER_RL.EFFECTIVE_END_DATE(+)