VIEW: APPS.BENBV_ENRT_PERD_FOR_PL_V

Source

View Text - Preformatted

SELECT ERP.EFFECTIVE_START_DATE, ERP.EFFECTIVE_END_DATE, ERP.ENRT_CVG_STRT_DT_RL, ERP.ENRT_CVG_END_DT_RL, ERP.RT_STRT_DT_RL, ERP.RT_END_DT_RL, /* descriptive flexfield */ '_DF:BEN:BEN_ENRT_PERD_FOR_PL_F:ERP', /* codes */ ERP.ENRT_CVG_STRT_DT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_ENRT_CVG_STRT',ERP.ENRT_CVG_STRT_DT_CD), ERP.ENRT_CVG_END_DT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_ENRT_CVG_END',ERP.ENRT_CVG_END_DT_CD), ERP.RT_STRT_DT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_RT_STRT',ERP.RT_STRT_DT_CD), ERP.RT_END_DT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_RT_END',ERP.RT_END_DT_CD), /* id columns */ ERP.ENRT_PERD_FOR_PL_ID, ERP.BUSINESS_GROUP_ID, ERP.PL_ID, ERP.ENRT_PERD_ID, ERP.LEE_RSN_ID, /* who columns */ ERP.LAST_UPDATE_DATE, ERP.LAST_UPDATED_BY, ERP.CREATED_BY, ERP.CREATION_DATE FROM BEN_ENRT_PERD_FOR_PL_F ERP WHERE ERP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, ERP.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT ERP.EFFECTIVE_START_DATE
, ERP.EFFECTIVE_END_DATE
, ERP.ENRT_CVG_STRT_DT_RL
, ERP.ENRT_CVG_END_DT_RL
, ERP.RT_STRT_DT_RL
, ERP.RT_END_DT_RL
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_ENRT_PERD_FOR_PL_F:ERP'
, /* CODES */ ERP.ENRT_CVG_STRT_DT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ENRT_CVG_STRT'
, ERP.ENRT_CVG_STRT_DT_CD)
, ERP.ENRT_CVG_END_DT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ENRT_CVG_END'
, ERP.ENRT_CVG_END_DT_CD)
, ERP.RT_STRT_DT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RT_STRT'
, ERP.RT_STRT_DT_CD)
, ERP.RT_END_DT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RT_END'
, ERP.RT_END_DT_CD)
, /* ID COLUMNS */ ERP.ENRT_PERD_FOR_PL_ID
, ERP.BUSINESS_GROUP_ID
, ERP.PL_ID
, ERP.ENRT_PERD_ID
, ERP.LEE_RSN_ID
, /* WHO COLUMNS */ ERP.LAST_UPDATE_DATE
, ERP.LAST_UPDATED_BY
, ERP.CREATED_BY
, ERP.CREATION_DATE
FROM BEN_ENRT_PERD_FOR_PL_F ERP
WHERE ERP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ERP.BUSINESS_GROUP_ID) WITH READ ONLY