Product: | BEN - Advanced Benefits |
---|---|
Description: | This view identifies the impact of a life event reason on eligibility for a program, plan type in program, plan in program, plan, or option in plan. |
Implementation/DBA Data: | APPS.BENBV_ELIG_TO_PRTE_RSN_V |
SELECT PEO.EFFECTIVE_START_DATE
, PEO.EFFECTIVE_END_DATE
, PEO.PRTN_EFF_STRT_DT_RL
, PEO.PRTN_EFF_END_DT_RL
, PEO.WAIT_PERD_UOM
, HR_BIS.BIS_DECODE_LOOKUP('BEN_TM_UOM'
, PEO.WAIT_PERD_UOM)
, PEO.WAIT_PERD_VAL
, PEO.WAIT_PERD_DT_TO_USE_RL
, PEO.MX_POE_UOM
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RQD_PERD_ENRT_NENRT_TM_UOM'
, PEO.MX_POE_UOM)
, PEO.MX_POE_VAL
, PEO.MX_POE_RL
, PEO.WAIT_PERD_RL
, PEO.MX_POE_DET_DT_RL
, PEO.VRFY_FMLY_MMBR_RL
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_ELIG_TO_PRTE_RSN_F:PEO'
, /* CODES */ PEO.ELIG_INELIG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ELIG_INELIG'
, PEO.ELIG_INELIG_CD)
, PEO.PRTN_EFF_STRT_DT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRTN_ELIG_STRT'
, PEO.PRTN_EFF_STRT_DT_CD)
, PEO.PRTN_EFF_END_DT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PRTN_ELIG_END'
, PEO.PRTN_EFF_END_DT_CD)
, PEO.WAIT_PERD_DT_TO_USE_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_MX_WTG_DT_TO_USE'
, PEO.WAIT_PERD_DT_TO_USE_CD)
, PEO.MX_POE_DET_DT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_MX_POE_DET_DT'
, PEO.MX_POE_DET_DT_CD)
, PEO.MX_POE_APLS_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_MX_POE_APLS'
, PEO.MX_POE_APLS_CD)
, PEO.VRFY_FMLY_MMBR_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_FMLY_MMBR'
, PEO.VRFY_FMLY_MMBR_CD)
, PEO.PRTN_OVRIDBL_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEO.PRTN_OVRIDBL_FLAG)
, PEO.IGNR_PRTN_OVRID_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEO.IGNR_PRTN_OVRID_FLAG)
, /* ID COLUMNS */ PEO.ELIG_TO_PRTE_RSN_ID
, PEO.BUSINESS_GROUP_ID
, PEO.LER_ID
, PEO.PTIP_ID
, PEO.PLIP_ID
, PEO.OIPL_ID
, PEO.PL_ID
, PEO.PGM_ID
, /* WHO COLUMNS */ PEO.LAST_UPDATE_DATE
, PEO.LAST_UPDATED_BY
, PEO.CREATED_BY
, PEO.CREATION_DATE
FROM BEN_ELIG_TO_PRTE_RSN_F PEO
WHERE PEO.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PEO.BUSINESS_GROUP_ID) WITH READ ONLY