Product: | BEN - Advanced Benefits |
---|---|
Description: | This view captures Plan Design for Compensation Workbench |
Implementation/DBA Data: | APPS.BENBV_CWB_PL_DSGN_V |
SELECT CWB.LF_EVT_OCRD_DT
, CWB.EFFECTIVE_DATE
, CWB.NAME
, CWB.PL_UOM
, CWB.PL_ORDR_NUM
, CWB.OIPL_ORDR_NUM
, CWB.PL_XCHG_RATE
, CWB.OPT_COUNT
, CWB.UPD_START_DT
, CWB.UPD_END_DT
, CWB.APPROVAL_MODE
, CWB.ENRT_PERD_START_DT
, CWB.ENRT_PERD_END_DT
, CWB.YR_PERD_END_DT
, CWB.WTHN_YR_START_DT
, CWB.WTHN_YR_END_DT
, CWB.PERF_REVW_STRT_DT
, CWB.ASG_UPDT_EFF_DATE
, CWB.SALARY_CHANGE_REASON
, CWB.WS_NNMNTRY_UOM
, CWB.DIST_BDGT_NNMNTRY_UOM
, CWB.WS_BDGT_NNMNTRY_UOM
, CWB.RSRV_NNMNTRY_UOM
, CWB.ELIG_SAL_NNMNTRY_UOM
, CWB.MISC1_NNMNTRY_UOM
, CWB.MISC2_NNMNTRY_UOM
, CWB.MISC3_NNMNTRY_UOM
, CWB.STAT_SAL_NNMNTRY_UOM
, CWB.REC_NNMNTRY_UOM
, CWB.TOT_COMP_NNMNTRY_UOM
, CWB.OTH_COMP_NNMNTRY_UOM
, CWB.YR_PERD_START_DT
, CWB.LEGISLATION_CODE
, CWB.PL_ANNULIZATION_FACTOR
, CWB.UOM_PRECISION
, CWB.DATA_FREEZE_DATE
, CWB.BDGT_OVER_BUDGET_TOLERANCE_PCT
, CWB.WS_OVER_BUDGET_TOLERANCE_PCT
, BEN_BIS_UTILS.GET_PL_NAME(CWB.PL_ID
, CWB.BUSINESS_GROUP_ID
, CWB.LF_EVT_OCRD_DT)
, BEN_BIS_UTILS.GET_OIPL_NAME(CWB.OIPL_ID
, CWB.BUSINESS_GROUP_ID
, 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)
, BEN_BIS_UTILS.GET_OPT_NAME(CWB.OPT_ID
, CWB.BUSINESS_GROUP_ID
, CWB.LF_EVT_OCRD_DT)
, /* CODES */ CWB.PRSRV_BDGT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRSVR_BDGT'
, CWB.PRSRV_BDGT_CD)
, CWB.EMP_INTERVIEW_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('LOOKUP_NOT_FOUND'
, CWB.EMP_INTERVIEW_TYP_CD)
, CWB.WS_RNDG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RNDG'
, CWB.WS_RNDG_CD)
, CWB.DIST_BDGT_RNDG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RNDG'
, CWB.DIST_BDGT_RNDG_CD)
, CWB.WS_BDGT_RNDG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RNDG'
, CWB.WS_BDGT_RNDG_CD)
, CWB.RSRV_RNDG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RNDG'
, CWB.RSRV_RNDG_CD)
, CWB.ELIG_SAL_RNDG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RNDG'
, CWB.ELIG_SAL_RNDG_CD)
, CWB.MISC1_RNDG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RNDG'
, CWB.MISC1_RNDG_CD)
, CWB.MISC2_RNDG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RNDG'
, CWB.MISC2_RNDG_CD)
, CWB.MISC3_RNDG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RNDG'
, CWB.MISC3_RNDG_CD)
, CWB.STAT_SAL_RNDG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RNDG'
, CWB.STAT_SAL_RNDG_CD)
, CWB.REC_RNDG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RNDG'
, CWB.REC_RNDG_CD)
, CWB.TOT_COMP_RNDG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RNDG'
, CWB.TOT_COMP_RNDG_CD)
, CWB.OTH_COMP_RNDG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RNDG'
, CWB.OTH_COMP_RNDG_CD)
, CWB.WS_SUB_ACTY_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_SUB_ACTY_TYP'
, CWB.WS_SUB_ACTY_TYP_CD)
, CWB.ACTY_REF_PERD_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ACTY_REF_PERD'
, CWB.ACTY_REF_PERD_CD)
, CWB.PL_STAT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_STAT'
, CWB.PL_STAT_CD)
, CWB.OPT_HIDDEN_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CWB.OPT_HIDDEN_FLAG)
, CWB.USES_BDGT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CWB.USES_BDGT_FLAG)
, CWB.ACTUAL_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CWB.ACTUAL_FLAG)
, CWB.BDGT_OVER_BUDGET_EDIT_CD
, HR_BIS.BIS_DECODE_LOOKUP('LOOKUP_NOT_FOUND'
, CWB.BDGT_OVER_BUDGET_EDIT_CD)
, CWB.WS_OVER_BUDGET_EDIT_CD
, HR_BIS.BIS_DECODE_LOOKUP('LOOKUP_NOT_FOUND'
, CWB.WS_OVER_BUDGET_EDIT_CD)
, CWB.WS_AMT_EDIT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_CWB_WS_AMT_EDIT'
, CWB.WS_AMT_EDIT_CD)
, CWB.WS_AMT_EDIT_ENF_CD_FOR_NULLS
, HR_BIS.BIS_DECODE_LOOKUP('BEN_CWB_WS_AMT_EDIT_ENF'
, CWB.WS_AMT_EDIT_ENF_CD_FOR_NULLS)
, /* ID COLUMNS */ CWB.PL_ID
, CWB.OIPL_ID
, CWB.GROUP_PL_ID
, CWB.GROUP_OIPL_ID
, CWB.OPT_ID
, CWB.ENRT_PERD_ID
, CWB.YR_PERD_ID
, CWB.BUSINESS_GROUP_ID
, CWB.WS_ABR_ID
, CWB.DIST_BDGT_ABR_ID
, CWB.WS_BDGT_ABR_ID
, CWB.RSRV_ABR_ID
, CWB.ELIG_SAL_ABR_ID
, CWB.MISC1_ABR_ID
, CWB.MISC2_ABR_ID
, CWB.MISC3_ABR_ID
, CWB.STAT_SAL_ABR_ID
, CWB.REC_ABR_ID
, CWB.TOT_COMP_ABR_ID
, CWB.OTH_COMP_ABR_ID
, CWB.WS_ELEMENT_TYPE_ID
, CWB.WS_INPUT_VALUE_ID
, /* WHO COLUMNS */ CWB.LAST_UPDATE_DATE
, CWB.LAST_UPDATED_BY
, CWB.CREATED_BY
, CWB.CREATION_DATE
FROM BEN_CWB_PL_DSGN CWB
WHERE CWB.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, CWB.BUSINESS_GROUP_ID) WITH READ ONLY