VIEW: APPS.BEN_PRTN_ELIG_PRFL_D

Source

View Text - Preformatted

SELECT CEP.PRTN_ELIG_PRFL_ID , CEP.EFFECTIVE_START_DATE , CEP.EFFECTIVE_END_DATE , ELP.NAME PROFILE_NAME , HL2.MEANING PROFILE_TYPE , HL1.MEANING MNDTRY_FLAG , hl3.meaning compute_score_flag , CEP.LAST_UPDATE_DATE , FUSER.USER_NAME LAST_UPDATED_BY FROM BEN_PRTN_ELIG_PRFL_F CEP ,HR_LOOKUPS HL1 ,FND_USER FUSER ,BEN_ELIGY_PRFL_F ELP ,HR_LOOKUPS HL2 ,hr_lookups hl3 WHERE HL1.LOOKUP_CODE(+) = CEP.MNDTRY_FLAG AND HL1.LOOKUP_TYPE(+) = 'YES_NO' AND HL2.LOOKUP_CODE(+) = CEP.ELIG_PRFL_TYPE_CD AND HL2.LOOKUP_TYPE(+) = 'BEN_ELIG_PRFL_TYPE' AND hl3.lookup_code(+) = cep.compute_score_flag AND hl3.lookup_type(+) = 'YES_NO' AND FUSER.USER_ID(+) = CEP.LAST_UPDATED_BY AND ELP.ELIGY_PRFL_ID(+) = CEP.ELIGY_PRFL_ID AND CEP.EFFECTIVE_START_DATE BETWEEN ELP.EFFECTIVE_START_DATE(+) AND ELP.EFFECTIVE_END_DATE(+)

View Text - HTML Formatted

SELECT CEP.PRTN_ELIG_PRFL_ID
, CEP.EFFECTIVE_START_DATE
, CEP.EFFECTIVE_END_DATE
, ELP.NAME PROFILE_NAME
, HL2.MEANING PROFILE_TYPE
, HL1.MEANING MNDTRY_FLAG
, HL3.MEANING COMPUTE_SCORE_FLAG
, CEP.LAST_UPDATE_DATE
, FUSER.USER_NAME LAST_UPDATED_BY
FROM BEN_PRTN_ELIG_PRFL_F CEP
, HR_LOOKUPS HL1
, FND_USER FUSER
, BEN_ELIGY_PRFL_F ELP
, HR_LOOKUPS HL2
, HR_LOOKUPS HL3
WHERE HL1.LOOKUP_CODE(+) = CEP.MNDTRY_FLAG
AND HL1.LOOKUP_TYPE(+) = 'YES_NO'
AND HL2.LOOKUP_CODE(+) = CEP.ELIG_PRFL_TYPE_CD
AND HL2.LOOKUP_TYPE(+) = 'BEN_ELIG_PRFL_TYPE'
AND HL3.LOOKUP_CODE(+) = CEP.COMPUTE_SCORE_FLAG
AND HL3.LOOKUP_TYPE(+) = 'YES_NO'
AND FUSER.USER_ID(+) = CEP.LAST_UPDATED_BY
AND ELP.ELIGY_PRFL_ID(+) = CEP.ELIGY_PRFL_ID
AND CEP.EFFECTIVE_START_DATE BETWEEN ELP.EFFECTIVE_START_DATE(+)
AND ELP.EFFECTIVE_END_DATE(+)