VIEW: APPS.BENBV_ELIG_TO_PRTE_RSN_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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