Product: | BEN - Advanced Benefits |
---|---|
Description: | This view identifies participation eligibility criteria for a program, plan type in program, plan in program, plan, or option in plan. |
Implementation/DBA Data: | APPS.BENBV_PRTN_ELIG_V |
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