[Home] [Help]
VIEW: APPS.PER_REFERRER_LOV_V
Source
View Text - Preformatted
SELECT PER.PERSON_ID , PER.FULL_NAME , PER.ORDER_NAME , PER.EMPLOYEE_NUMBER , PER.EFFECTIVE_START_DATE , PER.EFFECTIVE_END_DATE , PER.BUSINESS_GROUP_ID FROM PER_PEOPLE_F PER WHERE PER.CURRENT_EMPLOYEE_FLAG = 'Y'
View Text - HTML Formatted
SELECT PER.PERSON_ID
, PER.FULL_NAME
, PER.ORDER_NAME
, PER.EMPLOYEE_NUMBER
, PER.EFFECTIVE_START_DATE
, PER.EFFECTIVE_END_DATE
, PER.BUSINESS_GROUP_ID
FROM PER_PEOPLE_F PER
WHERE PER.CURRENT_EMPLOYEE_FLAG = 'Y'