[Home] [Help]
View: PER_REFERRER_LOV_V
| Product: | PER - Human Resources |
| Description: | Used to support user interface |
| Implementation/DBA Data: |
APPS.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 |