VIEW: APPS.BEN_ELIG_ENRLD_ANTHR_PLIP_D

Source

View Text - Preformatted

SELECT eai.ROWID ROW_ID, eai.ELIG_ENRLD_ANTHR_PLIP_ID ,eai.EFFECTIVE_START_DATE ,eai.EFFECTIVE_END_DATE ,EXCLD.MEANING ,ENRL_DET_DT.MEANING ,eai.ORDR_NUM ,PLN.NAME ,ELIGY_PRFL.NAME ,eai.LAST_UPDATE_DATE ,fuser.LAST_UPDATED_BY from BEN_ELIG_ENRLD_ANTHR_PLIP_F eai, fnd_user fuser ,BEN_PLIP_F PLIP ,BEN_PL_F PLN ,BEN_ELIGY_PRFL_F ELIGY_PRFL ,hr_lookups ENRL_DET_DT ,hr_lookups EXCLD WHERE fuser.user_id (+)= eai .last_updated_by and PLIP.PLIP_ID (+)= eai .PLIP_ID and PLN.PL_ID (+)= PLIP.PL_ID and ELIGY_PRFL.ELIGY_PRFL_ID (+)= eai .ELIGY_PRFL_ID and ENRL_DET_DT.lookup_code (+)= eai .ENRL_DET_DT_CD and ENRL_DET_DT.lookup_type (+)= 'BEN_ENRL_DET_DT' and EXCLD.lookup_code (+)= eai .EXCLD_FLAG and EXCLD.lookup_type (+)= 'YES_NO' AND eai.effective_start_date BETWEEN eligy_prfl.effective_start_date (+) and eligy_prfl.effective_end_date(+)

View Text - HTML Formatted

SELECT EAI.ROWID ROW_ID
, EAI.ELIG_ENRLD_ANTHR_PLIP_ID
, EAI.EFFECTIVE_START_DATE
, EAI.EFFECTIVE_END_DATE
, EXCLD.MEANING
, ENRL_DET_DT.MEANING
, EAI.ORDR_NUM
, PLN.NAME
, ELIGY_PRFL.NAME
, EAI.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_ELIG_ENRLD_ANTHR_PLIP_F EAI
, FND_USER FUSER
, BEN_PLIP_F PLIP
, BEN_PL_F PLN
, BEN_ELIGY_PRFL_F ELIGY_PRFL
, HR_LOOKUPS ENRL_DET_DT
, HR_LOOKUPS EXCLD
WHERE FUSER.USER_ID (+)= EAI .LAST_UPDATED_BY
AND PLIP.PLIP_ID (+)= EAI .PLIP_ID
AND PLN.PL_ID (+)= PLIP.PL_ID
AND ELIGY_PRFL.ELIGY_PRFL_ID (+)= EAI .ELIGY_PRFL_ID
AND ENRL_DET_DT.LOOKUP_CODE (+)= EAI .ENRL_DET_DT_CD
AND ENRL_DET_DT.LOOKUP_TYPE (+)= 'BEN_ENRL_DET_DT'
AND EXCLD.LOOKUP_CODE (+)= EAI .EXCLD_FLAG
AND EXCLD.LOOKUP_TYPE (+)= 'YES_NO'
AND EAI.EFFECTIVE_START_DATE BETWEEN ELIGY_PRFL.EFFECTIVE_START_DATE (+)
AND ELIGY_PRFL.EFFECTIVE_END_DATE(+)