Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_LER_BNFT_RSTRN_D |
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