VIEW: APPS.PA_PER_EMP_V

Source

View Text - Preformatted

SELECT distinct per.employee_number FROM per_people_f per, per_person_types person_types WHERE per.person_type_id = person_types.person_type_id and person_types.system_person_type = 'EMP' and per.employee_number is not null

View Text - HTML Formatted

SELECT DISTINCT PER.EMPLOYEE_NUMBER
FROM PER_PEOPLE_F PER
, PER_PERSON_TYPES PERSON_TYPES
WHERE PER.PERSON_TYPE_ID = PERSON_TYPES.PERSON_TYPE_ID
AND PERSON_TYPES.SYSTEM_PERSON_TYPE = 'EMP'
AND PER.EMPLOYEE_NUMBER IS NOT NULL