VIEW: APPS.BEN_ELIG_EE_STAT_PRTE_D

Source

View Text - Preformatted

SELECT ees.elig_ee_stat_prte_id, ees.effective_start_date, ees.effective_end_date, hl1.meaning, ees.ordr_num, asa.user_status, ees.criteria_score, ees.criteria_weight, ees.last_update_date, fuser.user_name FROM ben_elig_ee_stat_prte_f ees, hr_lookups hl1, per_ass_status_type_amends asa, fnd_user fuser WHERE hl1.lookup_code(+) = ees.excld_flag AND hl1.lookup_type(+) = 'YES_NO' AND asa.assignment_status_type_id = ees.assignment_status_type_id AND ees.business_group_id = asa.assignment_status_type_id AND fuser.user_id(+) = ees.last_updated_by UNION SELECT ees.elig_ee_stat_prte_id, ees.effective_start_date, ees.effective_end_date, hl1.meaning, ees.ordr_num, ast.user_status, ees.criteria_score, ees.criteria_weight, ees.last_update_date, fuser.user_name FROM ben_elig_ee_stat_prte_f ees, hr_lookups hl1, per_assignment_status_types ast, fnd_user fuser WHERE hl1.lookup_code(+) = ees.excld_flag AND hl1.lookup_type(+) = 'YES_NO' AND ast.assignment_status_type_id(+) = ees.assignment_status_type_id AND NOT EXISTS ( SELECT NULL FROM per_ass_status_type_amends asa WHERE asa.assignment_status_type_id = ast.assignment_status_type_id AND asa.business_group_id = ees.business_group_id) AND fuser.user_id(+) = ees.last_updated_by

View Text - HTML Formatted

SELECT EES.ELIG_EE_STAT_PRTE_ID
, EES.EFFECTIVE_START_DATE
, EES.EFFECTIVE_END_DATE
, HL1.MEANING
, EES.ORDR_NUM
, ASA.USER_STATUS
, EES.CRITERIA_SCORE
, EES.CRITERIA_WEIGHT
, EES.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_ELIG_EE_STAT_PRTE_F EES
, HR_LOOKUPS HL1
, PER_ASS_STATUS_TYPE_AMENDS ASA
, FND_USER FUSER
WHERE HL1.LOOKUP_CODE(+) = EES.EXCLD_FLAG
AND HL1.LOOKUP_TYPE(+) = 'YES_NO'
AND ASA.ASSIGNMENT_STATUS_TYPE_ID = EES.ASSIGNMENT_STATUS_TYPE_ID
AND EES.BUSINESS_GROUP_ID = ASA.ASSIGNMENT_STATUS_TYPE_ID
AND FUSER.USER_ID(+) = EES.LAST_UPDATED_BY UNION SELECT EES.ELIG_EE_STAT_PRTE_ID
, EES.EFFECTIVE_START_DATE
, EES.EFFECTIVE_END_DATE
, HL1.MEANING
, EES.ORDR_NUM
, AST.USER_STATUS
, EES.CRITERIA_SCORE
, EES.CRITERIA_WEIGHT
, EES.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_ELIG_EE_STAT_PRTE_F EES
, HR_LOOKUPS HL1
, PER_ASSIGNMENT_STATUS_TYPES AST
, FND_USER FUSER
WHERE HL1.LOOKUP_CODE(+) = EES.EXCLD_FLAG
AND HL1.LOOKUP_TYPE(+) = 'YES_NO'
AND AST.ASSIGNMENT_STATUS_TYPE_ID(+) = EES.ASSIGNMENT_STATUS_TYPE_ID
AND NOT EXISTS ( SELECT NULL
FROM PER_ASS_STATUS_TYPE_AMENDS ASA
WHERE ASA.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
AND ASA.BUSINESS_GROUP_ID = EES.BUSINESS_GROUP_ID)
AND FUSER.USER_ID(+) = EES.LAST_UPDATED_BY