VIEW: APPS.BENBV_CWB_WKSHT_GRP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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