View: BENBV_COMP_LVL_FCTR_V

Product:	BEN - Advanced Benefits
Description:	This view identifies how to calculate a person's compensation level, for example, base pay, for such purposes as determining eligibility and calculating rates.
Implementation/DBA Data:	APPS.BENBV_COMP_LVL_FCTR_V

View Text

SELECT CLF.NAME
, CLF.COMP_LVL_UOM
, HR_BIS.BIS_DECODE_LOOKUP('HR_UOM'
, CLF.COMP_LVL_UOM)
, CLF.COMP_LVL_DET_RL
, CLF.RNDG_RL
, CLF.MX_COMP_VAL
, CLF.MN_COMP_VAL
, CLF.COMP_CALC_RL
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_COMP_LVL_FCTR:CLF'
, /* CODES */ CLF.RNDG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RNDG'
, CLF.RNDG_CD)
, CLF.COMP_SRC_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_COMP_SRC'
, CLF.COMP_SRC_CD)
, CLF.COMP_ALT_VAL_TO_USE_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_COMP_ALT_VAL_TO_USE'
, CLF.COMP_ALT_VAL_TO_USE_CD)
, CLF.STTD_SAL_PRDCTY_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ACTY_REF_PERD'
, CLF.STTD_SAL_PRDCTY_CD)
, CLF.COMP_LVL_DET_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_COMP_LVL_DET'
, CLF.COMP_LVL_DET_CD)
, CLF.NO_MX_COMP_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CLF.NO_MX_COMP_FLAG)
, CLF.NO_MN_COMP_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CLF.NO_MN_COMP_FLAG)
, /* ID COLUMNS */ CLF.COMP_LVL_FCTR_ID
, CLF.BUSINESS_GROUP_ID
, CLF.DEFINED_BALANCE_ID
, CLF.BNFTS_BAL_ID
, /* WHO COLUMNS */ CLF.LAST_UPDATE_DATE
, CLF.LAST_UPDATED_BY
, CLF.CREATED_BY
, CLF.CREATION_DATE
FROM BEN_COMP_LVL_FCTR CLF
WHERE CLF.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, CLF.BUSINESS_GROUP_ID) WITH READ ONLY

Columns