VIEW: APPS.BENBV_CWB_SUMMARY_V

Source

View Text - Preformatted

SELECT CWB.STATUS, CWB.ELIG_COUNT_DIRECT, CWB.ELIG_COUNT_ALL, CWB.EMP_RECV_COUNT_DIRECT, CWB.EMP_RECV_COUNT_ALL, CWB.ELIG_SAL_VAL_DIRECT, CWB.ELIG_SAL_VAL_ALL, CWB.WS_VAL_DIRECT, CWB.WS_VAL_ALL, CWB.WS_BDGT_VAL_DIRECT, CWB.WS_BDGT_VAL_ALL, CWB.WS_BDGT_ISS_VAL_DIRECT, CWB.WS_BDGT_ISS_VAL_ALL, CWB.BDGT_VAL_DIRECT, CWB.BDGT_ISS_VAL_DIRECT, CWB.STAT_SAL_VAL_DIRECT, CWB.STAT_SAL_VAL_ALL, CWB.OTH_COMP_VAL_DIRECT, CWB.OTH_COMP_VAL_ALL, CWB.TOT_COMP_VAL_DIRECT, CWB.TOT_COMP_VAL_ALL, CWB.REC_VAL_DIRECT, CWB.REC_VAL_ALL, CWB.REC_MN_VAL_DIRECT, CWB.REC_MN_VAL_ALL, CWB.REC_MX_VAL_DIRECT, CWB.REC_MX_VAL_ALL, CWB.MISC1_VAL_DIRECT, CWB.MISC1_VAL_ALL, CWB.MISC2_VAL_DIRECT, CWB.MISC2_VAL_ALL, CWB.MISC3_VAL_DIRECT, CWB.MISC3_VAL_ALL, 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), /* id columns */ CWB.SUMMARY_ID, CWB.GROUP_PER_IN_LER_ID, CWB.GROUP_PL_ID, CWB.GROUP_OIPL_ID, CWB.PERSON_ID, /* who columns */ CWB.LAST_UPDATE_DATE, CWB.LAST_UPDATED_BY, CWB.CREATED_BY, CWB.CREATION_DATE FROM BEN_CWB_SUMMARY CWB WITH READ ONLY

View Text - HTML Formatted

SELECT CWB.STATUS
, CWB.ELIG_COUNT_DIRECT
, CWB.ELIG_COUNT_ALL
, CWB.EMP_RECV_COUNT_DIRECT
, CWB.EMP_RECV_COUNT_ALL
, CWB.ELIG_SAL_VAL_DIRECT
, CWB.ELIG_SAL_VAL_ALL
, CWB.WS_VAL_DIRECT
, CWB.WS_VAL_ALL
, CWB.WS_BDGT_VAL_DIRECT
, CWB.WS_BDGT_VAL_ALL
, CWB.WS_BDGT_ISS_VAL_DIRECT
, CWB.WS_BDGT_ISS_VAL_ALL
, CWB.BDGT_VAL_DIRECT
, CWB.BDGT_ISS_VAL_DIRECT
, CWB.STAT_SAL_VAL_DIRECT
, CWB.STAT_SAL_VAL_ALL
, CWB.OTH_COMP_VAL_DIRECT
, CWB.OTH_COMP_VAL_ALL
, CWB.TOT_COMP_VAL_DIRECT
, CWB.TOT_COMP_VAL_ALL
, CWB.REC_VAL_DIRECT
, CWB.REC_VAL_ALL
, CWB.REC_MN_VAL_DIRECT
, CWB.REC_MN_VAL_ALL
, CWB.REC_MX_VAL_DIRECT
, CWB.REC_MX_VAL_ALL
, CWB.MISC1_VAL_DIRECT
, CWB.MISC1_VAL_ALL
, CWB.MISC2_VAL_DIRECT
, CWB.MISC2_VAL_ALL
, CWB.MISC3_VAL_DIRECT
, CWB.MISC3_VAL_ALL
, 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)
, /* ID COLUMNS */ CWB.SUMMARY_ID
, CWB.GROUP_PER_IN_LER_ID
, CWB.GROUP_PL_ID
, CWB.GROUP_OIPL_ID
, CWB.PERSON_ID
, /* WHO COLUMNS */ CWB.LAST_UPDATE_DATE
, CWB.LAST_UPDATED_BY
, CWB.CREATED_BY
, CWB.CREATION_DATE
FROM BEN_CWB_SUMMARY CWB WITH READ ONLY