FND Design Data [Home] [Help]

View: PER_REFERRER_LOV_V

Product: PER - Human Resources
Description: Used to support user interface
Implementation/DBA Data: ViewAPPS.PER_REFERRER_LOV_V
View Text

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'

Columns

Name
PERSON_ID
FULL_NAME
ORDER_NAME
EMPLOYEE_NUMBER
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
BUSINESS_GROUP_ID