Product: | BEN - Advanced Benefits |
---|---|
Description: | This view identifies a specific instance of an enrollment period for a program or plan for a defined type of enrollment type cycle (e.g., open enrollment). |
Implementation/DBA Data: | APPS.BENBV_ENRT_PERD_V |
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