eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.BEN_CLPSE_LF_EVT_D

Source

View Text - Preformatted


SELECT clp.ROWID row_id, clp.clpse_lf_evt_id, clp.effective_start_date, clp.effective_end_date, clp.tlrnc_dys_num, clp.last_update_date, fuser.user_name, clp.seq, ler1.NAME, hr_general.decode_lookup ('BEN_BOOL', clp.bool1_cd), ler2.NAME, hr_general.decode_lookup ('BEN_BOOL', clp.bool2_cd), ler3.NAME, hr_general.decode_lookup ('BEN_BOOL', clp.bool3_cd), ler4.NAME, hr_general.decode_lookup ('BEN_BOOL', clp.bool4_cd), ler5.NAME, hr_general.decode_lookup ('BEN_BOOL', clp.bool5_cd), ler6.NAME, hr_general.decode_lookup ('BEN_BOOL', clp.bool6_cd), ler7.NAME, hr_general.decode_lookup ('BEN_BOOL', clp.bool7_cd), ler8.NAME, hr_general.decode_lookup ('BEN_BOOL', clp.bool8_cd), ler9.NAME, hr_general.decode_lookup ('BEN_BOOL', clp.bool9_cd), ler10.NAME, hr_general.decode_lookup ('BEN_EVAL', clp.eval_cd) eval_cd_meaning, eval_rl.formula_name eval_rl_name, hr_general.decode_lookup ('BEN_EVAL_DET', clp.eval_ler_det_cd) eval_ler_det_meaning, eval_ler_rl.formula_name eval_ler_det_rl_name, eval_ler.NAME eval_ler_name FROM ben_clpse_lf_evt_f clp, fnd_user fuser, ben_ler_f ler1, ben_ler_f ler2, ben_ler_f ler3, ben_ler_f ler4, ben_ler_f ler5, ben_ler_f ler6, ben_ler_f ler7, ben_ler_f ler8, ben_ler_f ler9, ben_ler_f ler10, ben_ler_f eval_ler, ff_formulas_f eval_rl, ff_formulas_f eval_ler_rl WHERE fuser.user_id(+) = clp.last_updated_by AND eval_ler_rl.formula_id(+) = clp.eval_ler_det_rl AND clp.effective_start_date BETWEEN eval_ler_rl.effective_start_date(+) AND eval_ler_rl.effective_end_date(+) AND eval_rl.formula_id(+) = clp.eval_rl AND clp.effective_start_date BETWEEN eval_rl.effective_start_date(+) AND eval_rl.effective_end_date(+) AND clp.ler1_id = ler1.ler_id(+) AND clp.effective_start_date BETWEEN ler1.effective_start_date(+) AND ler1.effective_end_date(+) AND clp.ler2_id = ler2.ler_id(+) AND clp.effective_start_date BETWEEN ler2.effective_start_date(+) AND ler2.effective_end_date(+) AND clp.ler3_id = ler3.ler_id(+) AND clp.effective_start_date BETWEEN ler3.effective_start_date(+) AND ler3.effective_end_date(+) AND clp.ler4_id = ler4.ler_id(+) AND clp.effective_start_date BETWEEN ler4.effective_start_date(+) AND ler4.effective_end_date(+) AND clp.ler5_id = ler5.ler_id(+) AND clp.effective_start_date BETWEEN ler5.effective_start_date(+) AND ler5.effective_end_date(+) AND clp.ler6_id = ler6.ler_id(+) AND clp.effective_start_date BETWEEN ler6.effective_start_date(+) AND ler6.effective_end_date(+) AND clp.ler7_id = ler7.ler_id(+) AND clp.effective_start_date BETWEEN ler7.effective_start_date(+) AND ler7.effective_end_date(+) AND clp.ler8_id = ler8.ler_id(+) AND clp.effective_start_date BETWEEN ler8.effective_start_date(+) AND ler8.effective_end_date(+) AND clp.ler9_id = ler9.ler_id(+) AND clp.effective_start_date BETWEEN ler9.effective_start_date(+) AND ler9.effective_end_date(+) AND clp.ler10_id = ler10.ler_id(+) AND clp.effective_start_date BETWEEN ler10.effective_start_date(+) AND ler10.effective_end_date(+) AND clp.eval_ler_id = eval_ler.ler_id(+) AND clp.effective_start_date BETWEEN eval_ler.effective_start_date(+) AND eval_ler.effective_end_date(+)

View Text - HTML Formatted

SELECT CLP.ROWID ROW_ID
, CLP.CLPSE_LF_EVT_ID
, CLP.EFFECTIVE_START_DATE
, CLP.EFFECTIVE_END_DATE
, CLP.TLRNC_DYS_NUM
, CLP.LAST_UPDATE_DATE
, FUSER.USER_NAME
, CLP.SEQ
, LER1.NAME
, HR_GENERAL.DECODE_LOOKUP ('BEN_BOOL'
, CLP.BOOL1_CD)
, LER2.NAME
, HR_GENERAL.DECODE_LOOKUP ('BEN_BOOL'
, CLP.BOOL2_CD)
, LER3.NAME
, HR_GENERAL.DECODE_LOOKUP ('BEN_BOOL'
, CLP.BOOL3_CD)
, LER4.NAME
, HR_GENERAL.DECODE_LOOKUP ('BEN_BOOL'
, CLP.BOOL4_CD)
, LER5.NAME
, HR_GENERAL.DECODE_LOOKUP ('BEN_BOOL'
, CLP.BOOL5_CD)
, LER6.NAME
, HR_GENERAL.DECODE_LOOKUP ('BEN_BOOL'
, CLP.BOOL6_CD)
, LER7.NAME
, HR_GENERAL.DECODE_LOOKUP ('BEN_BOOL'
, CLP.BOOL7_CD)
, LER8.NAME
, HR_GENERAL.DECODE_LOOKUP ('BEN_BOOL'
, CLP.BOOL8_CD)
, LER9.NAME
, HR_GENERAL.DECODE_LOOKUP ('BEN_BOOL'
, CLP.BOOL9_CD)
, LER10.NAME
, HR_GENERAL.DECODE_LOOKUP ('BEN_EVAL'
, CLP.EVAL_CD) EVAL_CD_MEANING
, EVAL_RL.FORMULA_NAME EVAL_RL_NAME
, HR_GENERAL.DECODE_LOOKUP ('BEN_EVAL_DET'
, CLP.EVAL_LER_DET_CD) EVAL_LER_DET_MEANING
, EVAL_LER_RL.FORMULA_NAME EVAL_LER_DET_RL_NAME
, EVAL_LER.NAME EVAL_LER_NAME
FROM BEN_CLPSE_LF_EVT_F CLP
, FND_USER FUSER
, BEN_LER_F LER1
, BEN_LER_F LER2
, BEN_LER_F LER3
, BEN_LER_F LER4
, BEN_LER_F LER5
, BEN_LER_F LER6
, BEN_LER_F LER7
, BEN_LER_F LER8
, BEN_LER_F LER9
, BEN_LER_F LER10
, BEN_LER_F EVAL_LER
, FF_FORMULAS_F EVAL_RL
, FF_FORMULAS_F EVAL_LER_RL
WHERE FUSER.USER_ID(+) = CLP.LAST_UPDATED_BY
AND EVAL_LER_RL.FORMULA_ID(+) = CLP.EVAL_LER_DET_RL
AND CLP.EFFECTIVE_START_DATE BETWEEN EVAL_LER_RL.EFFECTIVE_START_DATE(+)
AND EVAL_LER_RL.EFFECTIVE_END_DATE(+)
AND EVAL_RL.FORMULA_ID(+) = CLP.EVAL_RL
AND CLP.EFFECTIVE_START_DATE BETWEEN EVAL_RL.EFFECTIVE_START_DATE(+)
AND EVAL_RL.EFFECTIVE_END_DATE(+)
AND CLP.LER1_ID = LER1.LER_ID(+)
AND CLP.EFFECTIVE_START_DATE BETWEEN LER1.EFFECTIVE_START_DATE(+)
AND LER1.EFFECTIVE_END_DATE(+)
AND CLP.LER2_ID = LER2.LER_ID(+)
AND CLP.EFFECTIVE_START_DATE BETWEEN LER2.EFFECTIVE_START_DATE(+)
AND LER2.EFFECTIVE_END_DATE(+)
AND CLP.LER3_ID = LER3.LER_ID(+)
AND CLP.EFFECTIVE_START_DATE BETWEEN LER3.EFFECTIVE_START_DATE(+)
AND LER3.EFFECTIVE_END_DATE(+)
AND CLP.LER4_ID = LER4.LER_ID(+)
AND CLP.EFFECTIVE_START_DATE BETWEEN LER4.EFFECTIVE_START_DATE(+)
AND LER4.EFFECTIVE_END_DATE(+)
AND CLP.LER5_ID = LER5.LER_ID(+)
AND CLP.EFFECTIVE_START_DATE BETWEEN LER5.EFFECTIVE_START_DATE(+)
AND LER5.EFFECTIVE_END_DATE(+)
AND CLP.LER6_ID = LER6.LER_ID(+)
AND CLP.EFFECTIVE_START_DATE BETWEEN LER6.EFFECTIVE_START_DATE(+)
AND LER6.EFFECTIVE_END_DATE(+)
AND CLP.LER7_ID = LER7.LER_ID(+)
AND CLP.EFFECTIVE_START_DATE BETWEEN LER7.EFFECTIVE_START_DATE(+)
AND LER7.EFFECTIVE_END_DATE(+)
AND CLP.LER8_ID = LER8.LER_ID(+)
AND CLP.EFFECTIVE_START_DATE BETWEEN LER8.EFFECTIVE_START_DATE(+)
AND LER8.EFFECTIVE_END_DATE(+)
AND CLP.LER9_ID = LER9.LER_ID(+)
AND CLP.EFFECTIVE_START_DATE BETWEEN LER9.EFFECTIVE_START_DATE(+)
AND LER9.EFFECTIVE_END_DATE(+)
AND CLP.LER10_ID = LER10.LER_ID(+)
AND CLP.EFFECTIVE_START_DATE BETWEEN LER10.EFFECTIVE_START_DATE(+)
AND LER10.EFFECTIVE_END_DATE(+)
AND CLP.EVAL_LER_ID = EVAL_LER.LER_ID(+)
AND CLP.EFFECTIVE_START_DATE BETWEEN EVAL_LER.EFFECTIVE_START_DATE(+)
AND EVAL_LER.EFFECTIVE_END_DATE(+)