VIEW: APPS.BEN_CVG_AMT_CALC_MTHD_D

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)