VIEW: APPS.BENBV_CWB_PERSON_RATES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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