VIEW: BEN.BEN_CWB_PERSON_GROUPS#

Source

View Text - Preformatted

select GROUP_PER_IN_LER_ID GROUP_PER_IN_LER_ID, GROUP_PL_ID GROUP_PL_ID, GROUP_OIPL_ID GROUP_OIPL_ID, LF_EVT_OCRD_DT LF_EVT_OCRD_DT, BDGT_POP_CD BDGT_POP_CD, DUE_DT DUE_DT, ACCESS_CD ACCESS_CD, APPROVAL_CD APPROVAL_CD, APPROVAL_DATE APPROVAL_DATE, APPROVAL_COMMENTS APPROVAL_COMMENTS, SUBMIT_CD SUBMIT_CD, SUBMIT_DATE SUBMIT_DATE, SUBMIT_COMMENTS SUBMIT_COMMENTS, DIST_BDGT_VAL DIST_BDGT_VAL, WS_BDGT_VAL WS_BDGT_VAL, RSRV_VAL RSRV_VAL, DIST_BDGT_MN_VAL DIST_BDGT_MN_VAL, DIST_BDGT_MX_VAL DIST_BDGT_MX_VAL, DIST_BDGT_INCR_VAL DIST_BDGT_INCR_VAL, WS_BDGT_MN_VAL WS_BDGT_MN_VAL, WS_BDGT_MX_VAL WS_BDGT_MX_VAL, WS_BDGT_INCR_VAL WS_BDGT_INCR_VAL, RSRV_MN_VAL RSRV_MN_VAL, RSRV_MX_VAL RSRV_MX_VAL, RSRV_INCR_VAL RSRV_INCR_VAL, DIST_BDGT_ISS_VAL DIST_BDGT_ISS_VAL, WS_BDGT_ISS_VAL WS_BDGT_ISS_VAL, DFLT_DIST_BDGT_VAL DFLT_DIST_BDGT_VAL, DFLT_WS_BDGT_VAL DFLT_WS_BDGT_VAL, DIST_BDGT_ISS_DATE DIST_BDGT_ISS_DATE, WS_BDGT_ISS_DATE WS_BDGT_ISS_DATE, WS_BDGT_VAL_LAST_UPD_DATE WS_BDGT_VAL_LAST_UPD_DATE, DIST_BDGT_VAL_LAST_UPD_DATE DIST_BDGT_VAL_LAST_UPD_DATE, RSRV_VAL_LAST_UPD_DATE RSRV_VAL_LAST_UPD_DATE, WS_BDGT_VAL_LAST_UPD_BY WS_BDGT_VAL_LAST_UPD_BY, DIST_BDGT_VAL_LAST_UPD_BY DIST_BDGT_VAL_LAST_UPD_BY, RSRV_VAL_LAST_UPD_BY RSRV_VAL_LAST_UPD_BY, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE from "BEN"."BEN_CWB_PERSON_GROUPS"

View Text - HTML Formatted

SELECT GROUP_PER_IN_LER_ID GROUP_PER_IN_LER_ID
, GROUP_PL_ID GROUP_PL_ID
, GROUP_OIPL_ID GROUP_OIPL_ID
, LF_EVT_OCRD_DT LF_EVT_OCRD_DT
, BDGT_POP_CD BDGT_POP_CD
, DUE_DT DUE_DT
, ACCESS_CD ACCESS_CD
, APPROVAL_CD APPROVAL_CD
, APPROVAL_DATE APPROVAL_DATE
, APPROVAL_COMMENTS APPROVAL_COMMENTS
, SUBMIT_CD SUBMIT_CD
, SUBMIT_DATE SUBMIT_DATE
, SUBMIT_COMMENTS SUBMIT_COMMENTS
, DIST_BDGT_VAL DIST_BDGT_VAL
, WS_BDGT_VAL WS_BDGT_VAL
, RSRV_VAL RSRV_VAL
, DIST_BDGT_MN_VAL DIST_BDGT_MN_VAL
, DIST_BDGT_MX_VAL DIST_BDGT_MX_VAL
, DIST_BDGT_INCR_VAL DIST_BDGT_INCR_VAL
, WS_BDGT_MN_VAL WS_BDGT_MN_VAL
, WS_BDGT_MX_VAL WS_BDGT_MX_VAL
, WS_BDGT_INCR_VAL WS_BDGT_INCR_VAL
, RSRV_MN_VAL RSRV_MN_VAL
, RSRV_MX_VAL RSRV_MX_VAL
, RSRV_INCR_VAL RSRV_INCR_VAL
, DIST_BDGT_ISS_VAL DIST_BDGT_ISS_VAL
, WS_BDGT_ISS_VAL WS_BDGT_ISS_VAL
, DFLT_DIST_BDGT_VAL DFLT_DIST_BDGT_VAL
, DFLT_WS_BDGT_VAL DFLT_WS_BDGT_VAL
, DIST_BDGT_ISS_DATE DIST_BDGT_ISS_DATE
, WS_BDGT_ISS_DATE WS_BDGT_ISS_DATE
, WS_BDGT_VAL_LAST_UPD_DATE WS_BDGT_VAL_LAST_UPD_DATE
, DIST_BDGT_VAL_LAST_UPD_DATE DIST_BDGT_VAL_LAST_UPD_DATE
, RSRV_VAL_LAST_UPD_DATE RSRV_VAL_LAST_UPD_DATE
, WS_BDGT_VAL_LAST_UPD_BY WS_BDGT_VAL_LAST_UPD_BY
, DIST_BDGT_VAL_LAST_UPD_BY DIST_BDGT_VAL_LAST_UPD_BY
, RSRV_VAL_LAST_UPD_BY RSRV_VAL_LAST_UPD_BY
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
FROM "BEN"."BEN_CWB_PERSON_GROUPS"