View: BENBV_CWB_PERSON_GROUPS_V

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BENBV_CWB_PERSON_GROUPS_V

View Text

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

Columns