VIEW: APPS.BENBV_ENRT_PERD_V

Source

View Text - Preformatted

SELECT ENP.END_DT, ENP.STRT_DT, ENP.ENRT_CVG_END_DT_RL, ENP.RT_END_DT_RL, ENP.DFLT_ENRT_DT, ENP.ENRT_CVG_STRT_DT, ENP.ENRT_CVG_END_DT, ENP.RT_STRT_DT_RL, ENP.PROCG_END_DT, ENP.ENRT_CVG_STRT_DT_RL, ENP.ASND_LF_EVT_DT, ENP.BDGT_UPD_END_DT, ENP.BDGT_UPD_STRT_DT, ENP.WS_UPD_END_DT, ENP.WS_UPD_STRT_DT, ENP.PERF_REVW_STRT_DT, ENP.ASG_UPDT_EFF_DATE, ENP.DATA_FREEZE_DATE, ENP.HRCHY_RL, /* descriptive flexfield */ '_DF:BEN:BEN_ENRT_PERD:ENP', /* codes */ ENP.CLS_ENRT_DT_TO_USE_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_CLS_ENRT_DT_TO_USE',ENP.CLS_ENRT_DT_TO_USE_CD), ENP.ENRT_CVG_STRT_DT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_ENRT_CVG_STRT',ENP.ENRT_CVG_STRT_DT_CD), ENP.ENRT_CVG_END_DT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_ENRT_CVG_END',ENP.ENRT_CVG_END_DT_CD), ENP.RT_STRT_DT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_RT_STRT',ENP.RT_STRT_DT_CD), ENP.RT_END_DT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_RT_END',ENP.RT_END_DT_CD), ENP.DFLT_WS_ACC_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_WS_ACC',ENP.DFLT_WS_ACC_CD), ENP.EMP_INTERVIEW_TYPE_CD, HR_BIS.BIS_DECODE_LOOKUP('EMP_INTERVIEW_TYPE',ENP.EMP_INTERVIEW_TYPE_CD), ENP.HRCHY_TO_USE_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_HRCHY_TO_USE',ENP.HRCHY_TO_USE_CD), ENP.PRSVR_BDGT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRSVR_BDGT',ENP.PRSVR_BDGT_CD), ENP.ENRT_PERD_DET_OVRLP_BCKDT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_ENRT_PERD_DET_CD',ENP.ENRT_PERD_DET_OVRLP_BCKDT_CD), ENP.SAL_CHG_REASON_CD, HR_BIS.BIS_DECODE_LOOKUP('PROPOSAL_REASON',ENP.SAL_CHG_REASON_CD), ENP.APPROVAL_MODE_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_CWB_APPROVAL_MODE',ENP.APPROVAL_MODE_CD), ENP.HRCHY_AME_TRN_CD, HR_BIS.BIS_DECODE_LOOKUP('LOOKUP_NOT_FOUND',ENP.HRCHY_AME_TRN_CD), ENP.AUTO_DISTR_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ENP.AUTO_DISTR_FLAG), ENP.USES_BDGT_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ENP.USES_BDGT_FLAG), /* id columns */ ENP.ENRT_PERD_ID, ENP.BUSINESS_GROUP_ID, ENP.POPL_ENRT_TYP_CYCL_ID, ENP.YR_PERD_ID, ENP.LER_ID, ENP.POS_STRUCTURE_VERSION_ID, ENP.WTHN_YR_PERD_ID, ENP.HRCHY_AME_APP_ID, /* who columns */ ENP.LAST_UPDATE_DATE, ENP.LAST_UPDATED_BY, ENP.CREATED_BY, ENP.CREATION_DATE FROM BEN_ENRT_PERD ENP WHERE ENP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, ENP.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT ENP.END_DT
, ENP.STRT_DT
, ENP.ENRT_CVG_END_DT_RL
, ENP.RT_END_DT_RL
, ENP.DFLT_ENRT_DT
, ENP.ENRT_CVG_STRT_DT
, ENP.ENRT_CVG_END_DT
, ENP.RT_STRT_DT_RL
, ENP.PROCG_END_DT
, ENP.ENRT_CVG_STRT_DT_RL
, ENP.ASND_LF_EVT_DT
, ENP.BDGT_UPD_END_DT
, ENP.BDGT_UPD_STRT_DT
, ENP.WS_UPD_END_DT
, ENP.WS_UPD_STRT_DT
, ENP.PERF_REVW_STRT_DT
, ENP.ASG_UPDT_EFF_DATE
, ENP.DATA_FREEZE_DATE
, ENP.HRCHY_RL
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_ENRT_PERD:ENP'
, /* CODES */ ENP.CLS_ENRT_DT_TO_USE_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_CLS_ENRT_DT_TO_USE'
, ENP.CLS_ENRT_DT_TO_USE_CD)
, ENP.ENRT_CVG_STRT_DT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ENRT_CVG_STRT'
, ENP.ENRT_CVG_STRT_DT_CD)
, ENP.ENRT_CVG_END_DT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ENRT_CVG_END'
, ENP.ENRT_CVG_END_DT_CD)
, ENP.RT_STRT_DT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RT_STRT'
, ENP.RT_STRT_DT_CD)
, ENP.RT_END_DT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RT_END'
, ENP.RT_END_DT_CD)
, ENP.DFLT_WS_ACC_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_WS_ACC'
, ENP.DFLT_WS_ACC_CD)
, ENP.EMP_INTERVIEW_TYPE_CD
, HR_BIS.BIS_DECODE_LOOKUP('EMP_INTERVIEW_TYPE'
, ENP.EMP_INTERVIEW_TYPE_CD)
, ENP.HRCHY_TO_USE_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_HRCHY_TO_USE'
, ENP.HRCHY_TO_USE_CD)
, ENP.PRSVR_BDGT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRSVR_BDGT'
, ENP.PRSVR_BDGT_CD)
, ENP.ENRT_PERD_DET_OVRLP_BCKDT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ENRT_PERD_DET_CD'
, ENP.ENRT_PERD_DET_OVRLP_BCKDT_CD)
, ENP.SAL_CHG_REASON_CD
, HR_BIS.BIS_DECODE_LOOKUP('PROPOSAL_REASON'
, ENP.SAL_CHG_REASON_CD)
, ENP.APPROVAL_MODE_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_CWB_APPROVAL_MODE'
, ENP.APPROVAL_MODE_CD)
, ENP.HRCHY_AME_TRN_CD
, HR_BIS.BIS_DECODE_LOOKUP('LOOKUP_NOT_FOUND'
, ENP.HRCHY_AME_TRN_CD)
, ENP.AUTO_DISTR_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ENP.AUTO_DISTR_FLAG)
, ENP.USES_BDGT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ENP.USES_BDGT_FLAG)
, /* ID COLUMNS */ ENP.ENRT_PERD_ID
, ENP.BUSINESS_GROUP_ID
, ENP.POPL_ENRT_TYP_CYCL_ID
, ENP.YR_PERD_ID
, ENP.LER_ID
, ENP.POS_STRUCTURE_VERSION_ID
, ENP.WTHN_YR_PERD_ID
, ENP.HRCHY_AME_APP_ID
, /* WHO COLUMNS */ ENP.LAST_UPDATE_DATE
, ENP.LAST_UPDATED_BY
, ENP.CREATED_BY
, ENP.CREATION_DATE
FROM BEN_ENRT_PERD ENP
WHERE ENP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ENP.BUSINESS_GROUP_ID) WITH READ ONLY