View: BEN_PRTN_ELIG_PRFL_D

Product:	BEN - Advanced Benefits
Description:	- Retrofitted
Implementation/DBA Data:	APPS.BEN_PRTN_ELIG_PRFL_D

View Text

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(+)

Columns