VIEW: APPS.BENBV_CWB_PL_DSGN_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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