VIEW: APPS.BENBV_PRTN_ELIG_V

Source

View Text - Preformatted

SELECT EPA.EFFECTIVE_START_DATE, EPA.EFFECTIVE_END_DATE, EPA.WAIT_PERD_VAL, EPA.WAIT_PERD_DT_TO_USE_RL, EPA.MX_POE_UOM, HR_BIS.BIS_DECODE_LOOKUP('BEN_RQD_PERD_ENRT_NENRT_TM_UOM',EPA.MX_POE_UOM), EPA.MX_POE_VAL, EPA.MX_POE_RL, EPA.WAIT_PERD_RL, EPA.MX_POE_DET_DT_RL, EPA.WAIT_PERD_UOM, HR_BIS.BIS_DECODE_LOOKUP('BEN_TM_UOM',EPA.WAIT_PERD_UOM), EPA.PRTN_EFF_STRT_DT_RL, EPA.PRTN_EFF_END_DT_RL, /* descriptive flexfield */ '_DF:BEN:BEN_PRTN_ELIG_F:EPA', /* codes */ EPA.WAIT_PERD_DT_TO_USE_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_MX_WTG_DT_TO_USE',EPA.WAIT_PERD_DT_TO_USE_CD), EPA.MX_POE_DET_DT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_MX_POE_DET_DT',EPA.MX_POE_DET_DT_CD), EPA.PRTN_EFF_STRT_DT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRTN_ELIG_STRT',EPA.PRTN_EFF_STRT_DT_CD), EPA.PRTN_EFF_END_DT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRTN_ELIG_END',EPA.PRTN_EFF_END_DT_CD), EPA.MX_POE_APLS_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_MX_POE_APLS',EPA.MX_POE_APLS_CD), /* id columns */ EPA.PRTN_ELIG_ID, EPA.BUSINESS_GROUP_ID, EPA.PTIP_ID, EPA.PLIP_ID, EPA.OIPL_ID, EPA.PL_ID, EPA.PGM_ID, /* who columns */ EPA.LAST_UPDATE_DATE, EPA.LAST_UPDATED_BY, EPA.CREATED_BY, EPA.CREATION_DATE FROM BEN_PRTN_ELIG_F EPA WHERE EPA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, EPA.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT EPA.EFFECTIVE_START_DATE
, EPA.EFFECTIVE_END_DATE
, EPA.WAIT_PERD_VAL
, EPA.WAIT_PERD_DT_TO_USE_RL
, EPA.MX_POE_UOM
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RQD_PERD_ENRT_NENRT_TM_UOM'
, EPA.MX_POE_UOM)
, EPA.MX_POE_VAL
, EPA.MX_POE_RL
, EPA.WAIT_PERD_RL
, EPA.MX_POE_DET_DT_RL
, EPA.WAIT_PERD_UOM
, HR_BIS.BIS_DECODE_LOOKUP('BEN_TM_UOM'
, EPA.WAIT_PERD_UOM)
, EPA.PRTN_EFF_STRT_DT_RL
, EPA.PRTN_EFF_END_DT_RL
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_PRTN_ELIG_F:EPA'
, /* CODES */ EPA.WAIT_PERD_DT_TO_USE_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_MX_WTG_DT_TO_USE'
, EPA.WAIT_PERD_DT_TO_USE_CD)
, EPA.MX_POE_DET_DT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_MX_POE_DET_DT'
, EPA.MX_POE_DET_DT_CD)
, EPA.PRTN_EFF_STRT_DT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRTN_ELIG_STRT'
, EPA.PRTN_EFF_STRT_DT_CD)
, EPA.PRTN_EFF_END_DT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRTN_ELIG_END'
, EPA.PRTN_EFF_END_DT_CD)
, EPA.MX_POE_APLS_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_MX_POE_APLS'
, EPA.MX_POE_APLS_CD)
, /* ID COLUMNS */ EPA.PRTN_ELIG_ID
, EPA.BUSINESS_GROUP_ID
, EPA.PTIP_ID
, EPA.PLIP_ID
, EPA.OIPL_ID
, EPA.PL_ID
, EPA.PGM_ID
, /* WHO COLUMNS */ EPA.LAST_UPDATE_DATE
, EPA.LAST_UPDATED_BY
, EPA.CREATED_BY
, EPA.CREATION_DATE
FROM BEN_PRTN_ELIG_F EPA
WHERE EPA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, EPA.BUSINESS_GROUP_ID) WITH READ ONLY