View: BENBV_CWB_WKSHT_GRP_V

Product:	BEN - Advanced Benefits
Description:	This view captures Worksheet Groups for Compensation Workbench
Implementation/DBA Data:	APPS.BENBV_CWB_WKSHT_GRP_V

View Text

SELECT CWG.ORDR_NUM
, CWG.LABEL
, /* CODES */ CWG.WKSHT_GRP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_WKSHT_GRP'
, CWG.WKSHT_GRP_CD)
, CWG.STATUS_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_STAT'
, CWG.STATUS_CD)
, CWG.HIDDEN_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_CWB_HIDDEN'
, CWG.HIDDEN_CD)
, /* ID COLUMNS */ CWG.CWB_WKSHT_GRP_ID
, CWG.BUSINESS_GROUP_ID
, CWG.PL_ID
, /* WHO COLUMNS */ CWG.LAST_UPDATE_DATE
, CWG.LAST_UPDATED_BY
, CWG.CREATED_BY
, CWG.CREATION_DATE
FROM BEN_CWB_WKSHT_GRP CWG
WHERE CWG.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, CWG.BUSINESS_GROUP_ID) WITH READ ONLY

Columns