Product: | BEN - Advanced Benefits |
---|---|
Description: | This view captures Summary for Compensation Workbench |
Implementation/DBA Data: | APPS.BENBV_CWB_SUMMARY_V |
SELECT CWB.STATUS
, CWB.ELIG_COUNT_DIRECT
, CWB.ELIG_COUNT_ALL
, CWB.EMP_RECV_COUNT_DIRECT
, CWB.EMP_RECV_COUNT_ALL
, CWB.ELIG_SAL_VAL_DIRECT
, CWB.ELIG_SAL_VAL_ALL
, CWB.WS_VAL_DIRECT
, CWB.WS_VAL_ALL
, CWB.WS_BDGT_VAL_DIRECT
, CWB.WS_BDGT_VAL_ALL
, CWB.WS_BDGT_ISS_VAL_DIRECT
, CWB.WS_BDGT_ISS_VAL_ALL
, CWB.BDGT_VAL_DIRECT
, CWB.BDGT_ISS_VAL_DIRECT
, CWB.STAT_SAL_VAL_DIRECT
, CWB.STAT_SAL_VAL_ALL
, CWB.OTH_COMP_VAL_DIRECT
, CWB.OTH_COMP_VAL_ALL
, CWB.TOT_COMP_VAL_DIRECT
, CWB.TOT_COMP_VAL_ALL
, CWB.REC_VAL_DIRECT
, CWB.REC_VAL_ALL
, CWB.REC_MN_VAL_DIRECT
, CWB.REC_MN_VAL_ALL
, CWB.REC_MX_VAL_DIRECT
, CWB.REC_MX_VAL_ALL
, CWB.MISC1_VAL_DIRECT
, CWB.MISC1_VAL_ALL
, CWB.MISC2_VAL_DIRECT
, CWB.MISC2_VAL_ALL
, CWB.MISC3_VAL_DIRECT
, CWB.MISC3_VAL_ALL
, CWB.LF_EVT_OCRD_DT
, 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)
, /* ID COLUMNS */ CWB.SUMMARY_ID
, CWB.GROUP_PER_IN_LER_ID
, CWB.GROUP_PL_ID
, CWB.GROUP_OIPL_ID
, CWB.PERSON_ID
, /* WHO COLUMNS */ CWB.LAST_UPDATE_DATE
, CWB.LAST_UPDATED_BY
, CWB.CREATED_BY
, CWB.CREATION_DATE
FROM BEN_CWB_SUMMARY CWB WITH READ ONLY