Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_ELIGY_CRIT_VALUES_D |
SELECT ECV.ELIGY_CRIT_VALUES_ID
, ELP.NAME
, EGL.NAME
, ECV.EFFECTIVE_START_DATE
, ECV.EFFECTIVE_END_DATE
, ECV.ORDR_NUM
, ECV.NUMBER_VALUE1
, ECV.NUMBER_VALUE2
, ECV.CHAR_VALUE1
, ECV.CHAR_VALUE2
, ECV.DATE_VALUE1
, ECV.DATE_VALUE2
, HR.MEANING
, ECV.LEGISLATION_CODE
, ECV.LAST_UPDATE_DATE
, FUSER.USER_NAME
, ECV.LAST_UPDATE_LOGIN
FROM BEN_ELIGY_CRIT_VALUES_F ECV
, FND_USER FUSER
, BEN_ELIGY_CRITERIA EGL
, BEN_ELIGY_PRFL_F ELP
, HR_LOOKUPS HR
WHERE FUSER.USER_ID(+) = ECV.LAST_UPDATED_BY
AND ECV.ELIGY_CRITERIA_ID = EGL.ELIGY_CRITERIA_ID
AND ECV.EXCLD_FLAG(+) = HR.LOOKUP_CODE
AND HR.LOOKUP_TYPE = 'YES_NO'
AND ECV.ELIGY_PRFL_ID = ELP.ELIGY_PRFL_ID
AND ECV.EFFECTIVE_START_DATE BETWEEN ELP.EFFECTIVE_START_DATE
AND ELP.EFFECTIVE_END_DATE