VIEW: APPS.BENBV_CWB_PERSON_GROUPS_V

Source

View Text - Preformatted

SELECT CWB.LF_EVT_OCRD_DT, CWB.DUE_DT, CWB.APPROVAL_DATE, CWB.APPROVAL_COMMENTS, CWB.SUBMIT_DATE, CWB.SUBMIT_COMMENTS, CWB.DIST_BDGT_VAL, CWB.WS_BDGT_VAL, CWB.RSRV_VAL, CWB.DIST_BDGT_MN_VAL, CWB.DIST_BDGT_MX_VAL, CWB.DIST_BDGT_INCR_VAL, CWB.WS_BDGT_MN_VAL, CWB.WS_BDGT_MX_VAL, CWB.WS_BDGT_INCR_VAL, CWB.RSRV_MN_VAL, CWB.RSRV_MX_VAL, CWB.RSRV_INCR_VAL, CWB.DIST_BDGT_ISS_VAL, CWB.WS_BDGT_ISS_VAL, CWB.DIST_BDGT_ISS_DATE, CWB.WS_BDGT_ISS_DATE, CWB.WS_BDGT_VAL_LAST_UPD_DATE, CWB.DIST_BDGT_VAL_LAST_UPD_DATE, CWB.RSRV_VAL_LAST_UPD_DATE, CWB.WS_BDGT_VAL_LAST_UPD_BY, CWB.DIST_BDGT_VAL_LAST_UPD_BY, CWB.RSRV_VAL_LAST_UPD_BY, 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.BDGT_POP_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_POP',CWB.BDGT_POP_CD), CWB.ACCESS_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_CWB_TASK_ACCESS',CWB.ACCESS_CD), CWB.APPROVAL_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_APPR_STAT',CWB.APPROVAL_CD), CWB.SUBMIT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_SUBMIT_STAT',CWB.SUBMIT_CD), /* id columns */ CWB.GROUP_PER_IN_LER_ID, CWB.GROUP_PL_ID, CWB.GROUP_OIPL_ID, /* who columns */ CWB.LAST_UPDATE_DATE, CWB.LAST_UPDATED_BY, CWB.CREATED_BY, CWB.CREATION_DATE FROM BEN_CWB_PERSON_GROUPS CWB WITH READ ONLY

View Text - HTML Formatted

SELECT CWB.LF_EVT_OCRD_DT
, CWB.DUE_DT
, CWB.APPROVAL_DATE
, CWB.APPROVAL_COMMENTS
, CWB.SUBMIT_DATE
, CWB.SUBMIT_COMMENTS
, CWB.DIST_BDGT_VAL
, CWB.WS_BDGT_VAL
, CWB.RSRV_VAL
, CWB.DIST_BDGT_MN_VAL
, CWB.DIST_BDGT_MX_VAL
, CWB.DIST_BDGT_INCR_VAL
, CWB.WS_BDGT_MN_VAL
, CWB.WS_BDGT_MX_VAL
, CWB.WS_BDGT_INCR_VAL
, CWB.RSRV_MN_VAL
, CWB.RSRV_MX_VAL
, CWB.RSRV_INCR_VAL
, CWB.DIST_BDGT_ISS_VAL
, CWB.WS_BDGT_ISS_VAL
, CWB.DIST_BDGT_ISS_DATE
, CWB.WS_BDGT_ISS_DATE
, CWB.WS_BDGT_VAL_LAST_UPD_DATE
, CWB.DIST_BDGT_VAL_LAST_UPD_DATE
, CWB.RSRV_VAL_LAST_UPD_DATE
, CWB.WS_BDGT_VAL_LAST_UPD_BY
, CWB.DIST_BDGT_VAL_LAST_UPD_BY
, CWB.RSRV_VAL_LAST_UPD_BY
, 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.BDGT_POP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_POP'
, CWB.BDGT_POP_CD)
, CWB.ACCESS_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_CWB_TASK_ACCESS'
, CWB.ACCESS_CD)
, CWB.APPROVAL_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_APPR_STAT'
, CWB.APPROVAL_CD)
, CWB.SUBMIT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_SUBMIT_STAT'
, CWB.SUBMIT_CD)
, /* ID COLUMNS */ CWB.GROUP_PER_IN_LER_ID
, CWB.GROUP_PL_ID
, CWB.GROUP_OIPL_ID
, /* WHO COLUMNS */ CWB.LAST_UPDATE_DATE
, CWB.LAST_UPDATED_BY
, CWB.CREATED_BY
, CWB.CREATION_DATE
FROM BEN_CWB_PERSON_GROUPS CWB WITH READ ONLY