VIEW: APPS.BENBV_ELIG_ENRLD_ANTHR_PLIP_V

Source

View Text - Preformatted

SELECT EAI.EFFECTIVE_START_DATE, EAI.EFFECTIVE_END_DATE, EAI.ORDR_NUM, /* descriptive flexfield */ '_DF:BEN:BEN_ELIG_ENRLD_ANTHR_PLIP_F:EAI', /* codes */ EAI.ENRL_DET_DT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_ENRL_DET_DT',EAI.ENRL_DET_DT_CD), EAI.EXCLD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',EAI.EXCLD_FLAG), /* id columns */ EAI.ELIG_ENRLD_ANTHR_PLIP_ID, EAI.PLIP_ID, EAI.ELIGY_PRFL_ID, EAI.BUSINESS_GROUP_ID, /* who columns */ EAI.LAST_UPDATE_DATE, EAI.LAST_UPDATED_BY, EAI.CREATED_BY, EAI.CREATION_DATE FROM BEN_ELIG_ENRLD_ANTHR_PLIP_F EAI WHERE EAI.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, EAI.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT EAI.EFFECTIVE_START_DATE
, EAI.EFFECTIVE_END_DATE
, EAI.ORDR_NUM
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_ELIG_ENRLD_ANTHR_PLIP_F:EAI'
, /* CODES */ EAI.ENRL_DET_DT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ENRL_DET_DT'
, EAI.ENRL_DET_DT_CD)
, EAI.EXCLD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, EAI.EXCLD_FLAG)
, /* ID COLUMNS */ EAI.ELIG_ENRLD_ANTHR_PLIP_ID
, EAI.PLIP_ID
, EAI.ELIGY_PRFL_ID
, EAI.BUSINESS_GROUP_ID
, /* WHO COLUMNS */ EAI.LAST_UPDATE_DATE
, EAI.LAST_UPDATED_BY
, EAI.CREATED_BY
, EAI.CREATION_DATE
FROM BEN_ELIG_ENRLD_ANTHR_PLIP_F EAI
WHERE EAI.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, EAI.BUSINESS_GROUP_ID) WITH READ ONLY