VIEW: APPS.BEN_LER_CHG_PGM_ENRT_D

Source

View Text - Preformatted

SELECT lge.ROWID ROW_ID, lge.LER_CHG_PGM_ENRT_ID ,lge.EFFECTIVE_START_DATE ,lge.EFFECTIVE_END_DATE ,AUTO_ENRT_MTHD.FORMULA_NAME ,CRNT_ENRT_PRCLDS_CHG.MEANING ,PGM.NAME ,LER.NAME ,DFLT_ENRT.MEANING ,DFLT_ENRT2.FORMULA_NAME ,ENRT.MEANING ,ENRT_MTHD.MEANING ,ENRT2.FORMULA_NAME ,STL_ELIG_CANT_CHG.MEANING ,lge.LAST_UPDATE_DATE ,fuser.LAST_UPDATED_BY from BEN_LER_CHG_PGM_ENRT_F lge, fnd_user fuser ,BEN_PGM_F PGM ,BEN_LER_F LER ,hr_lookups DFLT_ENRT ,hr_lookups ENRT ,hr_lookups ENRT_MTHD ,hr_lookups CRNT_ENRT_PRCLDS_CHG ,hr_lookups STL_ELIG_CANT_CHG ,ff_formulas_f AUTO_ENRT_MTHD ,ff_formulas_f DFLT_ENRT2 ,ff_formulas_f ENRT2 WHERE fuser.user_id (+)= lge.last_updated_by and PGM.PGM_ID (+)= lge.PGM_ID and LER.LER_ID (+)= lge.LER_ID and DFLT_ENRT.lookup_code (+)= lge.DFLT_ENRT_CD and DFLT_ENRT.lookup_type (+)= 'BEN_DFLT_ENRT' and ENRT.lookup_code (+)= lge.ENRT_CD and ENRT.lookup_type (+)= 'BEN_ENRT' and ENRT_MTHD.lookup_code (+)= lge.ENRT_MTHD_CD and ENRT_MTHD.lookup_type (+)= 'BEN_ENRT_MTHD' and CRNT_ENRT_PRCLDS_CHG.lookup_code (+)= lge.CRNT_ENRT_PRCLDS_CHG_FLAG and CRNT_ENRT_PRCLDS_CHG.lookup_type (+)= 'YES_NO' and STL_ELIG_CANT_CHG.lookup_code (+)= lge.STL_ELIG_CANT_CHG_FLAG and STL_ELIG_CANT_CHG.lookup_type (+)= 'YES_NO' and AUTO_ENRT_MTHD.formula_id (+)= lge.AUTO_ENRT_MTHD_RL and lge.EFFECTIVE_START_DATE BETWEEN AUTO_ENRT_MTHD.EFFECTIVE_START_DATE(+) and AUTO_ENRT_MTHD.EFFECTIVE_END_DATE(+) and DFLT_ENRT2.formula_id (+)= lge.DFLT_ENRT_RL and lge.EFFECTIVE_START_DATE BETWEEN DFLT_ENRT2.EFFECTIVE_START_DATE(+) and DFLT_ENRT2.EFFECTIVE_END_DATE(+) and ENRT2.formula_id (+)= lge.ENRT_RL and lge.EFFECTIVE_START_DATE BETWEEN ENRT2.EFFECTIVE_START_DATE(+) and ENRT2.EFFECTIVE_END_DATE(+) and lge.effective_start_date between pgm.effective_start_date(+) and pgm.effective_end_date(+) and lge.effective_start_date between ler.effective_start_date(+) and ler.effective_end_date(+)

View Text - HTML Formatted

SELECT LGE.ROWID ROW_ID
, LGE.LER_CHG_PGM_ENRT_ID
, LGE.EFFECTIVE_START_DATE
, LGE.EFFECTIVE_END_DATE
, AUTO_ENRT_MTHD.FORMULA_NAME
, CRNT_ENRT_PRCLDS_CHG.MEANING
, PGM.NAME
, LER.NAME
, DFLT_ENRT.MEANING
, DFLT_ENRT2.FORMULA_NAME
, ENRT.MEANING
, ENRT_MTHD.MEANING
, ENRT2.FORMULA_NAME
, STL_ELIG_CANT_CHG.MEANING
, LGE.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_LER_CHG_PGM_ENRT_F LGE
, FND_USER FUSER
, BEN_PGM_F PGM
, BEN_LER_F LER
, HR_LOOKUPS DFLT_ENRT
, HR_LOOKUPS ENRT
, HR_LOOKUPS ENRT_MTHD
, HR_LOOKUPS CRNT_ENRT_PRCLDS_CHG
, HR_LOOKUPS STL_ELIG_CANT_CHG
, FF_FORMULAS_F AUTO_ENRT_MTHD
, FF_FORMULAS_F DFLT_ENRT2
, FF_FORMULAS_F ENRT2
WHERE FUSER.USER_ID (+)= LGE.LAST_UPDATED_BY
AND PGM.PGM_ID (+)= LGE.PGM_ID
AND LER.LER_ID (+)= LGE.LER_ID
AND DFLT_ENRT.LOOKUP_CODE (+)= LGE.DFLT_ENRT_CD
AND DFLT_ENRT.LOOKUP_TYPE (+)= 'BEN_DFLT_ENRT'
AND ENRT.LOOKUP_CODE (+)= LGE.ENRT_CD
AND ENRT.LOOKUP_TYPE (+)= 'BEN_ENRT'
AND ENRT_MTHD.LOOKUP_CODE (+)= LGE.ENRT_MTHD_CD
AND ENRT_MTHD.LOOKUP_TYPE (+)= 'BEN_ENRT_MTHD'
AND CRNT_ENRT_PRCLDS_CHG.LOOKUP_CODE (+)= LGE.CRNT_ENRT_PRCLDS_CHG_FLAG
AND CRNT_ENRT_PRCLDS_CHG.LOOKUP_TYPE (+)= 'YES_NO'
AND STL_ELIG_CANT_CHG.LOOKUP_CODE (+)= LGE.STL_ELIG_CANT_CHG_FLAG
AND STL_ELIG_CANT_CHG.LOOKUP_TYPE (+)= 'YES_NO'
AND AUTO_ENRT_MTHD.FORMULA_ID (+)= LGE.AUTO_ENRT_MTHD_RL
AND LGE.EFFECTIVE_START_DATE BETWEEN AUTO_ENRT_MTHD.EFFECTIVE_START_DATE(+)
AND AUTO_ENRT_MTHD.EFFECTIVE_END_DATE(+)
AND DFLT_ENRT2.FORMULA_ID (+)= LGE.DFLT_ENRT_RL
AND LGE.EFFECTIVE_START_DATE BETWEEN DFLT_ENRT2.EFFECTIVE_START_DATE(+)
AND DFLT_ENRT2.EFFECTIVE_END_DATE(+)
AND ENRT2.FORMULA_ID (+)= LGE.ENRT_RL
AND LGE.EFFECTIVE_START_DATE BETWEEN ENRT2.EFFECTIVE_START_DATE(+)
AND ENRT2.EFFECTIVE_END_DATE(+)
AND LGE.EFFECTIVE_START_DATE BETWEEN PGM.EFFECTIVE_START_DATE(+)
AND PGM.EFFECTIVE_END_DATE(+)
AND LGE.EFFECTIVE_START_DATE BETWEEN LER.EFFECTIVE_START_DATE(+)
AND LER.EFFECTIVE_END_DATE(+)