VIEW: APPS.BENBV_CVG_AMT_CALC_MTHD_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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