View: BEN_CVG_AMT_CALC_MTHD_D

Product:	BEN - Advanced Benefits
Description:	- Retrofitted
Implementation/DBA Data:	APPS.BEN_CVG_AMT_CALC_MTHD_D

View Text

SELECT CCM.ROWID ROW_ID
, CCM.CVG_AMT_CALC_MTHD_ID
, CCM.EFFECTIVE_START_DATE
, CCM.EFFECTIVE_END_DATE
, CCM.NAME
, CCM.INCRMT_VAL
, CCM.MX_VAL
, CCM.MN_VAL
, NO_MX_VAL_DFND.MEANING
, NO_MN_VAL_DFND.MEANING
, RNDG.MEANING
, RNDG_RL.FORMULA_NAME
, CCM.VAL
, VAL_OVRID_ALWD.MEANING
, VAL_CALC.FORMULA_NAME
, CCM.UOM
, NNMNTRY.MEANING
, BNDRY_PERD.MEANING
, BNFT_TYP.MEANING
, CVG_MLT.MEANING
, RT_TYP.MEANING
, CCM.DFLT_VAL
, ENTR_VAL_AT_ENRT.MEANING
, DFLT.MEANING
, CCM.LWR_LMT_VAL
, LWR_LMT.FORMULA_NAME
, CCM.UPR_LMT_VAL
, UPR_LMT.FORMULA_NAME
, COMP_LVL_FCTR.NAME
, OIPL_PL.NAME || '-' || OIPL_OPT.NAME
, PL.NAME
, CCM.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_CVG_AMT_CALC_MTHD_F CCM
, FND_USER FUSER
, BEN_COMP_LVL_FCTR COMP_LVL_FCTR
, BEN_OIPL_F OIPL
, BEN_PL_F OIPL_PL
, BEN_OPT_F OIPL_OPT
, BEN_PL_F PL
, HR_LOOKUPS RNDG
, HR_LOOKUPS BNDRY_PERD
, HR_LOOKUPS BNFT_TYP
, HR_LOOKUPS CVG_MLT
, HR_LOOKUPS RT_TYP
, HR_LOOKUPS NNMNTRY
, HR_LOOKUPS NO_MX_VAL_DFND
, HR_LOOKUPS NO_MN_VAL_DFND
, HR_LOOKUPS VAL_OVRID_ALWD
, HR_LOOKUPS ENTR_VAL_AT_ENRT
, HR_LOOKUPS DFLT
, FF_FORMULAS_F RNDG_RL
, FF_FORMULAS_F VAL_CALC
, FF_FORMULAS_F LWR_LMT
, FF_FORMULAS_F UPR_LMT
WHERE FUSER.USER_ID (+)= CCM .LAST_UPDATED_BY
AND COMP_LVL_FCTR.COMP_LVL_FCTR_ID (+)= CCM .COMP_LVL_FCTR_ID
AND OIPL.OIPL_ID (+)= CCM .OIPL_ID
AND OIPL_PL.PL_ID(+) = OIPL.PL_ID
AND OIPL_OPT.OPT_ID(+) = OIPL.OPT_ID
AND PL.PL_ID (+)= CCM .PL_ID
AND RNDG.LOOKUP_CODE (+)= CCM .RNDG_CD
AND RNDG.LOOKUP_TYPE (+)= 'BEN_RNDG'
AND BNDRY_PERD.LOOKUP_CODE (+)= CCM .BNDRY_PERD_CD
AND BNDRY_PERD.LOOKUP_TYPE (+)= 'BEN_BNDRY_PERD'
AND BNFT_TYP.LOOKUP_CODE (+)= CCM .BNFT_TYP_CD
AND BNFT_TYP.LOOKUP_TYPE (+)= 'BEN_BNFT_TYP'
AND CVG_MLT.LOOKUP_CODE (+)= CCM .CVG_MLT_CD
AND CVG_MLT.LOOKUP_TYPE (+)= 'BEN_CVG_MLT'
AND RT_TYP.LOOKUP_CODE (+)= CCM .RT_TYP_CD
AND RT_TYP.LOOKUP_TYPE (+)= 'BEN_RT_TYP'
AND NNMNTRY.LOOKUP_CODE (+)= CCM .NNMNTRY_UOM
AND NNMNTRY.LOOKUP_TYPE (+)= 'BEN_NNMNTRY_UOM'
AND NO_MX_VAL_DFND.LOOKUP_CODE (+)= CCM .NO_MX_VAL_DFND_FLAG
AND NO_MX_VAL_DFND.LOOKUP_TYPE (+)= 'YES_NO'
AND NO_MN_VAL_DFND.LOOKUP_CODE (+)= CCM .NO_MN_VAL_DFND_FLAG
AND NO_MN_VAL_DFND.LOOKUP_TYPE (+)= 'YES_NO'
AND VAL_OVRID_ALWD.LOOKUP_CODE (+)= CCM .VAL_OVRID_ALWD_FLAG
AND VAL_OVRID_ALWD.LOOKUP_TYPE (+)= 'YES_NO'
AND ENTR_VAL_AT_ENRT.LOOKUP_CODE (+)= CCM.ENTR_VAL_AT_ENRT_FLAG
AND ENTR_VAL_AT_ENRT.LOOKUP_TYPE (+)= 'YES_NO'
AND DFLT.LOOKUP_CODE (+)= CCM .DFLT_FLAG
AND DFLT.LOOKUP_TYPE (+)= 'YES_NO'
AND RNDG_RL.FORMULA_ID (+)= CCM .RNDG_RL
AND CCM .EFFECTIVE_START_DATE BETWEEN RNDG_RL.EFFECTIVE_START_DATE(+)
AND RNDG_RL.EFFECTIVE_END_DATE(+)
AND VAL_CALC.FORMULA_ID (+)= CCM .VAL_CALC_RL
AND CCM .EFFECTIVE_START_DATE BETWEEN VAL_CALC.EFFECTIVE_START_DATE(+)
AND VAL_CALC.EFFECTIVE_END_DATE(+)
AND LWR_LMT.FORMULA_ID (+)= CCM .LWR_LMT_CALC_RL
AND CCM .EFFECTIVE_START_DATE BETWEEN LWR_LMT.EFFECTIVE_START_DATE(+)
AND LWR_LMT.EFFECTIVE_END_DATE(+)
AND UPR_LMT.FORMULA_ID (+)= CCM .UPR_LMT_CALC_RL
AND CCM .EFFECTIVE_START_DATE BETWEEN UPR_LMT.EFFECTIVE_START_DATE(+)
AND UPR_LMT.EFFECTIVE_END_DATE (+)

Columns