[Home] [Help]
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
Name |
ORDR_NUM |
LABEL |
WKSHT_GRP_CD |
WKSHT_GRP_CD_M |
STATUS_CD |
STATUS_CD_M |
HIDDEN_CD |
HIDDEN_CD_M |
CWB_WKSHT_GRP_ID |
BUSINESS_GROUP_ID |
PL_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATED_BY |
CREATION_DATE |