VIEW: APPS.BEN_LER_BNFT_RSTRN_D

Source

View Text - Preformatted

SELECT lbr.ROWID ROW_ID, lbr.LER_BNFT_RSTRN_ID ,lbr.EFFECTIVE_START_DATE ,lbr.EFFECTIVE_END_DATE ,NO_MX_CVG_AMT_APLS.MEANING ,NO_MN_CVG_INCR_APLS.MEANING ,NO_MX_CVG_INCR_APLS.MEANING ,lbr.MX_CVG_INCR_WCF_ALWD_AMT ,lbr.MX_CVG_INCR_ALWD_AMT ,lbr.MX_CVG_ALWD_AMT ,lbr.MX_CVG_MLT_INCR_NUM ,lbr.MX_CVG_MLT_INCR_WCF_NUM ,MX_CVG.FORMULA_NAME ,lbr.MX_CVG_WCFN_AMT ,lbr.MX_CVG_WCFN_MLT_NUM ,lbr.MN_CVG_AMT ,MN_CVG.FORMULA_NAME ,CVG_INCR_R_DECR_ONLY.meaning ,UNSSPND_ENRT.meaning ,DFLT_TO_ASN_PNDG_CTFN.MEANING ,DFLT_TO_ASN_PNDG_CTFN2.FORMULA_NAME ,LER.NAME ,PL.NAME ,lbr.LAST_UPDATE_DATE ,fuser.LAST_UPDATED_BY from BEN_LER_BNFT_RSTRN_F lbr, fnd_user fuser ,BEN_LER_F LER ,BEN_PL_F PL ,hr_lookups CVG_INCR_R_DECR_ONLY ,hr_lookups UNSSPND_ENRT ,hr_lookups NO_MX_CVG_AMT_APLS ,hr_lookups NO_MN_CVG_INCR_APLS ,hr_lookups NO_MX_CVG_INCR_APLS ,hr_lookups DFLT_TO_ASN_PNDG_CTFN ,ff_formulas_f MX_CVG ,ff_formulas_f MN_CVG ,ff_formulas DFLT_TO_ASN_PNDG_CTFN2 WHERE fuser.user_id (+)= lbr.last_updated_by and LER.LER_ID (+)= lbr.LER_ID and PL.PL_ID (+)= lbr.PL_ID and CVG_INCR_R_DECR_ONLY.lookup_code (+)= lbr.CVG_INCR_R_DECR_ONLY_CD and CVG_INCR_R_DECR_ONLY.lookup_type (+)= 'BEN_CVG_INCR_R_DECR_ONLY' and UNSSPND_ENRT.lookup_code (+)= lbr.UNSSPND_ENRT_CD and UNSSPND_ENRT.lookup_type (+)= 'BEN_UNSSPND_ENRT' and DFLT_TO_ASN_PNDG_CTFN.lookup_code (+)= lbr. DFLT_TO_ASN_PNDG_CTFN_CD and DFLT_TO_ASN_PNDG_CTFN.lookup_type (+)= 'BEN_ DFLT_TO_ASN_PNDG_CTFN' and NO_MX_CVG_AMT_APLS.lookup_code (+)= lbr.NO_MX_CVG_AMT_APLS_FLAG and NO_MX_CVG_AMT_APLS.lookup_type (+)= 'YES_NO' and NO_MN_CVG_INCR_APLS.lookup_code (+)= lbr.NO_MN_CVG_INCR_APLS_FLAG and NO_MN_CVG_INCR_APLS.lookup_type (+)= 'YES_NO' and NO_MX_CVG_INCR_APLS.lookup_code (+)= lbr.NO_MX_CVG_INCR_APLS_FLAG and NO_MX_CVG_INCR_APLS.lookup_type (+)= 'YES_NO' and MX_CVG.formula_id (+)= lbr.MX_CVG_RL and lbr.EFFECTIVE_START_DATE BETWEEN MX_CVG.EFFECTIVE_START_DATE(+) and MX_CVG.EFFECTIVE_END_DATE(+) and DFLT_TO_ASN_PNDG_CTFN2.formula_id (+)= lbr.DFLT_TO_ASN_PNDG_CTFN_RL and lbr.EFFECTIVE_START_DATE BETWEEN DFLT_TO_ASN_PNDG_CTFN2.EFFECTIVE_START_DATE(+) and DFLT_TO_ASN_PNDG_CTFN2.EFFECTIVE_END_DATE(+) and MN_CVG.formula_id (+)= lbr.MN_CVG_RL and lbr.EFFECTIVE_START_DATE BETWEEN MN_CVG.EFFECTIVE_START_DATE(+) and MN_CVG.EFFECTIVE_END_DATE(+) AND lbr.effective_start_date BETWEEN pl.effective_start_date(+) AND pl.effective_end_date(+) AND lbr.effective_start_date BETWEEN ler.effective_start_date(+) AND ler.effective_end_date(+)

View Text - HTML Formatted

SELECT LBR.ROWID ROW_ID
, LBR.LER_BNFT_RSTRN_ID
, LBR.EFFECTIVE_START_DATE
, LBR.EFFECTIVE_END_DATE
, NO_MX_CVG_AMT_APLS.MEANING
, NO_MN_CVG_INCR_APLS.MEANING
, NO_MX_CVG_INCR_APLS.MEANING
, LBR.MX_CVG_INCR_WCF_ALWD_AMT
, LBR.MX_CVG_INCR_ALWD_AMT
, LBR.MX_CVG_ALWD_AMT
, LBR.MX_CVG_MLT_INCR_NUM
, LBR.MX_CVG_MLT_INCR_WCF_NUM
, MX_CVG.FORMULA_NAME
, LBR.MX_CVG_WCFN_AMT
, LBR.MX_CVG_WCFN_MLT_NUM
, LBR.MN_CVG_AMT
, MN_CVG.FORMULA_NAME
, CVG_INCR_R_DECR_ONLY.MEANING
, UNSSPND_ENRT.MEANING
, DFLT_TO_ASN_PNDG_CTFN.MEANING
, DFLT_TO_ASN_PNDG_CTFN2.FORMULA_NAME
, LER.NAME
, PL.NAME
, LBR.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_LER_BNFT_RSTRN_F LBR
, FND_USER FUSER
, BEN_LER_F LER
, BEN_PL_F PL
, HR_LOOKUPS CVG_INCR_R_DECR_ONLY
, HR_LOOKUPS UNSSPND_ENRT
, HR_LOOKUPS NO_MX_CVG_AMT_APLS
, HR_LOOKUPS NO_MN_CVG_INCR_APLS
, HR_LOOKUPS NO_MX_CVG_INCR_APLS
, HR_LOOKUPS DFLT_TO_ASN_PNDG_CTFN
, FF_FORMULAS_F MX_CVG
, FF_FORMULAS_F MN_CVG
, FF_FORMULAS DFLT_TO_ASN_PNDG_CTFN2
WHERE FUSER.USER_ID (+)= LBR.LAST_UPDATED_BY
AND LER.LER_ID (+)= LBR.LER_ID
AND PL.PL_ID (+)= LBR.PL_ID
AND CVG_INCR_R_DECR_ONLY.LOOKUP_CODE (+)= LBR.CVG_INCR_R_DECR_ONLY_CD
AND CVG_INCR_R_DECR_ONLY.LOOKUP_TYPE (+)= 'BEN_CVG_INCR_R_DECR_ONLY'
AND UNSSPND_ENRT.LOOKUP_CODE (+)= LBR.UNSSPND_ENRT_CD
AND UNSSPND_ENRT.LOOKUP_TYPE (+)= 'BEN_UNSSPND_ENRT'
AND DFLT_TO_ASN_PNDG_CTFN.LOOKUP_CODE (+)= LBR. DFLT_TO_ASN_PNDG_CTFN_CD
AND DFLT_TO_ASN_PNDG_CTFN.LOOKUP_TYPE (+)= 'BEN_ DFLT_TO_ASN_PNDG_CTFN'
AND NO_MX_CVG_AMT_APLS.LOOKUP_CODE (+)= LBR.NO_MX_CVG_AMT_APLS_FLAG
AND NO_MX_CVG_AMT_APLS.LOOKUP_TYPE (+)= 'YES_NO'
AND NO_MN_CVG_INCR_APLS.LOOKUP_CODE (+)= LBR.NO_MN_CVG_INCR_APLS_FLAG
AND NO_MN_CVG_INCR_APLS.LOOKUP_TYPE (+)= 'YES_NO'
AND NO_MX_CVG_INCR_APLS.LOOKUP_CODE (+)= LBR.NO_MX_CVG_INCR_APLS_FLAG
AND NO_MX_CVG_INCR_APLS.LOOKUP_TYPE (+)= 'YES_NO'
AND MX_CVG.FORMULA_ID (+)= LBR.MX_CVG_RL
AND LBR.EFFECTIVE_START_DATE BETWEEN MX_CVG.EFFECTIVE_START_DATE(+)
AND MX_CVG.EFFECTIVE_END_DATE(+)
AND DFLT_TO_ASN_PNDG_CTFN2.FORMULA_ID (+)= LBR.DFLT_TO_ASN_PNDG_CTFN_RL
AND LBR.EFFECTIVE_START_DATE BETWEEN DFLT_TO_ASN_PNDG_CTFN2.EFFECTIVE_START_DATE(+)
AND DFLT_TO_ASN_PNDG_CTFN2.EFFECTIVE_END_DATE(+)
AND MN_CVG.FORMULA_ID (+)= LBR.MN_CVG_RL
AND LBR.EFFECTIVE_START_DATE BETWEEN MN_CVG.EFFECTIVE_START_DATE(+)
AND MN_CVG.EFFECTIVE_END_DATE(+)
AND LBR.EFFECTIVE_START_DATE BETWEEN PL.EFFECTIVE_START_DATE(+)
AND PL.EFFECTIVE_END_DATE(+)
AND LBR.EFFECTIVE_START_DATE BETWEEN LER.EFFECTIVE_START_DATE(+)
AND LER.EFFECTIVE_END_DATE(+)