View: BENBV_CVG_AMT_CALC_MTHD_V

Product:	BEN - Advanced Benefits
Description:	This view identifies the coverage amount, or how coverage is calculated, for a plan or option in plan.
Implementation/DBA Data:	APPS.BENBV_CVG_AMT_CALC_MTHD_V

View Text

SELECT CCM.EFFECTIVE_START_DATE
, CCM.EFFECTIVE_END_DATE
, CCM.NAME
, CCM.LWR_LMT_VAL
, CCM.LWR_LMT_CALC_RL
, CCM.UPR_LMT_VAL
, CCM.UPR_LMT_CALC_RL
, CCM.INCRMT_VAL
, CCM.MX_VAL
, CCM.RNDG_RL
, CCM.MN_VAL
, CCM.VAL_CALC_RL
, CCM.VAL
, CCM.UOM
, CCM.NNMNTRY_UOM
, HR_BIS.BIS_DECODE_LOOKUP('BEN_NNMNTRY_UOM'
, CCM.NNMNTRY_UOM)
, CCM.DFLT_VAL
, CASE WHEN (CCM.PL_ID IS NOT NULL) THEN BEN_BIS_UTILS.GET_PL_NAME(CCM.PL_ID
, CCM.BUSINESS_GROUP_ID
, CCM.EFFECTIVE_START_DATE) WHEN (CCM.OIPL_ID IS NOT NULL) THEN BEN_BIS_UTILS.GET_OIPL_NAME(CCM.OIPL_ID
, CCM.BUSINESS_GROUP_ID
, CCM.EFFECTIVE_START_DATE) WHEN (CCM.PLIP_ID IS NOT NULL) THEN BEN_BIS_UTILS.GET_PLIP_NAME(CCM.PLIP_ID
, CCM.BUSINESS_GROUP_ID
, CCM.EFFECTIVE_START_DATE) ELSE NULL END COMP_OBJECT
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_CVG_AMT_CALC_MTHD_F:CCM'
, /* CODES */ CCM.RNDG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RNDG'
, CCM.RNDG_CD)
, CCM.BNDRY_PERD_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_BNDRY_PERD'
, CCM.BNDRY_PERD_CD)
, CCM.BNFT_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_BNFT_TYP'
, CCM.BNFT_TYP_CD)
, CCM.CVG_MLT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_CVG_MLT'
, CCM.CVG_MLT_CD)
, CCM.RT_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RT_TYP'
, CCM.RT_TYP_CD)
, CCM.NO_MX_VAL_DFND_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CCM.NO_MX_VAL_DFND_FLAG)
, CCM.NO_MN_VAL_DFND_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CCM.NO_MN_VAL_DFND_FLAG)
, CCM.VAL_OVRID_ALWD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CCM.VAL_OVRID_ALWD_FLAG)
, CCM.ENTR_VAL_AT_ENRT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CCM.ENTR_VAL_AT_ENRT_FLAG)
, CCM.DFLT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CCM.DFLT_FLAG)
, /* ID COLUMNS */ CCM.CVG_AMT_CALC_MTHD_ID
, CCM.BUSINESS_GROUP_ID
, CCM.COMP_LVL_FCTR_ID
, CCM.OIPL_ID
, CCM.PL_ID
, CCM.PLIP_ID
, /* WHO COLUMNS */ CCM.LAST_UPDATE_DATE
, CCM.LAST_UPDATED_BY
, CCM.CREATED_BY
, CCM.CREATION_DATE
FROM BEN_CVG_AMT_CALC_MTHD_F CCM
WHERE CCM.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, CCM.BUSINESS_GROUP_ID) WITH READ ONLY

Columns