VIEW: APPS.BEN_ELIG_ENRLD_ANTHR_PTIP_D

Source

View Text - Preformatted

SELECT eet.ROWID ROW_ID, eet.ELIG_ENRLD_ANTHR_PTIP_ID ,eet.EFFECTIVE_START_DATE ,eet.EFFECTIVE_END_DATE ,eet.ORDR_NUM ,EXCLD.MEANING ,ENRL_DET_DT.MEANING ,ONLY_PLS_SUBJ_COBRA.MEANING ,PL_TYP.NAME ,ELIGY_PRFL.NAME ,eet.LAST_UPDATE_DATE ,fuser.LAST_UPDATED_BY from BEN_ELIG_ENRLD_ANTHR_PTIP_F eet, fnd_user fuser ,BEN_PTIP_F PTIP ,BEN_PL_TYP_F PL_TYP ,BEN_ELIGY_PRFL_F ELIGY_PRFL ,hr_lookups ENRL_DET_DT ,hr_lookups EXCLD ,hr_lookups ONLY_PLS_SUBJ_COBRA WHERE fuser.user_id (+)= eet .last_updated_by and PTIP.PTIP_ID (+)= eet .PTIP_ID and PL_TYP.PL_TYP_ID (+)= PTIP.PL_TYP_ID and ELIGY_PRFL.ELIGY_PRFL_ID (+)= eet .ELIGY_PRFL_ID and ENRL_DET_DT.lookup_code (+)= eet .ENRL_DET_DT_CD and ENRL_DET_DT.lookup_type (+)= 'BEN_ENRL_DET_DT' and EXCLD.lookup_code (+)= eet .EXCLD_FLAG and EXCLD.lookup_type (+)= 'YES_NO' and ONLY_PLS_SUBJ_COBRA.lookup_code (+)= eet .ONLY_PLS_SUBJ_COBRA_FLAG and ONLY_PLS_SUBJ_COBRA.lookup_type (+)= 'YES_NO' AND eet.effective_start_date BETWEEN eligy_prfl.effective_start_date (+) and eligy_prfl.effective_end_date(+)

View Text - HTML Formatted

SELECT EET.ROWID ROW_ID
, EET.ELIG_ENRLD_ANTHR_PTIP_ID
, EET.EFFECTIVE_START_DATE
, EET.EFFECTIVE_END_DATE
, EET.ORDR_NUM
, EXCLD.MEANING
, ENRL_DET_DT.MEANING
, ONLY_PLS_SUBJ_COBRA.MEANING
, PL_TYP.NAME
, ELIGY_PRFL.NAME
, EET.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_ELIG_ENRLD_ANTHR_PTIP_F EET
, FND_USER FUSER
, BEN_PTIP_F PTIP
, BEN_PL_TYP_F PL_TYP
, BEN_ELIGY_PRFL_F ELIGY_PRFL
, HR_LOOKUPS ENRL_DET_DT
, HR_LOOKUPS EXCLD
, HR_LOOKUPS ONLY_PLS_SUBJ_COBRA
WHERE FUSER.USER_ID (+)= EET .LAST_UPDATED_BY
AND PTIP.PTIP_ID (+)= EET .PTIP_ID
AND PL_TYP.PL_TYP_ID (+)= PTIP.PL_TYP_ID
AND ELIGY_PRFL.ELIGY_PRFL_ID (+)= EET .ELIGY_PRFL_ID
AND ENRL_DET_DT.LOOKUP_CODE (+)= EET .ENRL_DET_DT_CD
AND ENRL_DET_DT.LOOKUP_TYPE (+)= 'BEN_ENRL_DET_DT'
AND EXCLD.LOOKUP_CODE (+)= EET .EXCLD_FLAG
AND EXCLD.LOOKUP_TYPE (+)= 'YES_NO'
AND ONLY_PLS_SUBJ_COBRA.LOOKUP_CODE (+)= EET .ONLY_PLS_SUBJ_COBRA_FLAG
AND ONLY_PLS_SUBJ_COBRA.LOOKUP_TYPE (+)= 'YES_NO'
AND EET.EFFECTIVE_START_DATE BETWEEN ELIGY_PRFL.EFFECTIVE_START_DATE (+)
AND ELIGY_PRFL.EFFECTIVE_END_DATE(+)