eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.BEN_ELIG_LGL_ENTY_PRTE_D

Source

View Text - Preformatted


SELECT eln.elig_lgl_enty_prte_id, eln.effective_start_date, eln.effective_end_date, eln.ordr_num, hl1.meaning, hou.NAME, eln.criteria_weight, eln.criteria_score, eln.last_update_date, fuser.user_name FROM ben_elig_lgl_enty_prte_f eln, hr_lookups hl1, hr_organization_units_v hou, fnd_user fuser WHERE HL1.LOOKUP_CODE (+) = ELN.EXCLD_FLAG AND HL1.LOOKUP_TYPE (+) = 'YES_NO' AND HOU.ORGANIZATION_ID = ELN.ORGANIZATION_ID AND HOU.BUSINESS_GROUP_ID + 0 = ELN.BUSINESS_GROUP_ID AND ELN.EFFECTIVE_START_DATE BETWEEN HOU.DATE_FROM AND NVL(HOU.DATE_TO, ELN.EFFECTIVE_END_DATE) AND FUSER.USER_ID (+) = ELN.LAST_UPDATED_BY

View Text - HTML Formatted

SELECT ELN.ELIG_LGL_ENTY_PRTE_ID
, ELN.EFFECTIVE_START_DATE
, ELN.EFFECTIVE_END_DATE
, ELN.ORDR_NUM
, HL1.MEANING
, HOU.NAME
, ELN.CRITERIA_WEIGHT
, ELN.CRITERIA_SCORE
, ELN.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_ELIG_LGL_ENTY_PRTE_F ELN
, HR_LOOKUPS HL1
, HR_ORGANIZATION_UNITS_V HOU
, FND_USER FUSER
WHERE HL1.LOOKUP_CODE (+) = ELN.EXCLD_FLAG
AND HL1.LOOKUP_TYPE (+) = 'YES_NO'
AND HOU.ORGANIZATION_ID = ELN.ORGANIZATION_ID
AND HOU.BUSINESS_GROUP_ID + 0 = ELN.BUSINESS_GROUP_ID
AND ELN.EFFECTIVE_START_DATE BETWEEN HOU.DATE_FROM
AND NVL(HOU.DATE_TO
, ELN.EFFECTIVE_END_DATE)
AND FUSER.USER_ID (+) = ELN.LAST_UPDATED_BY