[Home] [Help]
View: BENBV_CWB_GROUP_HRCHY_V
Product: | BEN - Advanced Benefits |
Description: | This view captures Group Hierarchy for Compensation Workbench |
Implementation/DBA Data: |
APPS.BENBV_CWB_GROUP_HRCHY_V
|
View Text
SELECT CWB.LVL_NUM
, /* ID COLUMNS */ CWB.MGR_PER_IN_LER_ID
, CWB.EMP_PER_IN_LER_ID
, /* WHO COLUMNS */ CWB.LAST_UPDATE_DATE
, CWB.LAST_UPDATED_BY
, CWB.CREATED_BY
, CWB.CREATION_DATE
FROM BEN_CWB_GROUP_HRCHY CWB WITH READ ONLY
Columns
Name |
LVL_NUM |
MGR_PER_IN_LER_ID |
EMP_PER_IN_LER_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATED_BY |
CREATION_DATE |