FND Design Data [Home] [Help]

View: PA_PER_EMP_V

Product: PA - Projects
Description:
Implementation/DBA Data: ViewAPPS.PA_PER_EMP_V
View Text

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

Columns

Name
EMPLOYEE_NUMBER