View: BENBV_CWB_PERSON_RATES_V

Product:	BEN - Advanced Benefits
Description:	This view captures Person Rates for Compensation Workbench
Implementation/DBA Data:	APPS.BENBV_CWB_PERSON_RATES_V

View Text

SELECT CWB.LF_EVT_OCRD_DT
, CWB.WS_VAL
, CWB.WS_MN_VAL
, CWB.WS_MX_VAL
, CWB.WS_INCR_VAL
, CWB.ELIG_SAL_VAL
, CWB.STAT_SAL_VAL
, CWB.OTH_COMP_VAL
, CWB.TOT_COMP_VAL
, CWB.MISC1_VAL
, CWB.MISC2_VAL
, CWB.MISC3_VAL
, CWB.REC_VAL
, CWB.REC_MN_VAL
, CWB.REC_MX_VAL
, CWB.REC_INCR_VAL
, CWB.WS_VAL_LAST_UPD_DATE
, CWB.WS_VAL_LAST_UPD_BY
, CWB.ELIG_OVRID_DT
, CWB.COPY_DIST_BDGT_VAL
, CWB.COPY_WS_BDGT_VAL
, CWB.COPY_RSRV_VAL
, CWB.COPY_DIST_BDGT_MN_VAL
, CWB.COPY_DIST_BDGT_MX_VAL
, CWB.COPY_DIST_BDGT_INCR_VAL
, CWB.COPY_WS_BDGT_MN_VAL
, CWB.COPY_WS_BDGT_MX_VAL
, CWB.COPY_WS_BDGT_INCR_VAL
, CWB.COPY_RSRV_MN_VAL
, CWB.COPY_RSRV_MX_VAL
, CWB.COPY_RSRV_INCR_VAL
, CWB.COPY_DIST_BDGT_ISS_VAL
, CWB.COPY_WS_BDGT_ISS_VAL
, CWB.COPY_DIST_BDGT_ISS_DATE
, CWB.COPY_WS_BDGT_ISS_DATE
, CWB.COMP_POSTING_DATE
, CWB.WS_RT_START_DATE
, BEN_BIS_UTILS.GET_GROUP_PL_NAME(CWB.PL_ID
, CWB.LF_EVT_OCRD_DT)
, BEN_BIS_UTILS.GET_GROUP_OIPL_NAME(CWB.OIPL_ID
, CWB.LF_EVT_OCRD_DT)
, BEN_BIS_UTILS.GET_GROUP_PL_NAME(CWB.GROUP_PL_ID
, CWB.LF_EVT_OCRD_DT)
, BEN_BIS_UTILS.GET_GROUP_OIPL_NAME(CWB.GROUP_OIPL_ID
, CWB.LF_EVT_OCRD_DT)
, /* CODES */ CWB.INELIG_RSN_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_INELG_RSN'
, CWB.INELIG_RSN_CD)
, CWB.ELIG_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CWB.ELIG_FLAG)
, /* ID COLUMNS */ CWB.PERSON_RATE_ID
, CWB.GROUP_PER_IN_LER_ID
, CWB.PL_ID
, CWB.OIPL_ID
, CWB.GROUP_PL_ID
, CWB.GROUP_OIPL_ID
, CWB.PERSON_ID
, CWB.ASSIGNMENT_ID
, CWB.PAY_PROPOSAL_ID
, CWB.ELEMENT_ENTRY_VALUE_ID
, CWB.ELIG_OVRID_PERSON_ID
, /* WHO COLUMNS */ CWB.LAST_UPDATE_DATE
, CWB.LAST_UPDATED_BY
, CWB.CREATED_BY
, CWB.CREATION_DATE
FROM BEN_CWB_PERSON_RATES CWB WITH READ ONLY

Columns