[Home] [Help]
View: PER_MANAGER_LOV
Product: | PER - Human Resources |
Description: | Used to support user interface |
Implementation/DBA Data: |
APPS.PER_MANAGER_LOV
|
View Text
SELECT E.FULL_NAME
, E.EMPLOYEE_NUMBER
, A.ORGANIZATION_ID
, A.BUSINESS_GROUP_ID + 0
, A.EFFECTIVE_START_DATE
, A.EFFECTIVE_END_DATE
, E.EFFECTIVE_START_DATE
, E.EFFECTIVE_END_DATE
, E.NPW_NUMBER
FROM PER_ALL_PEOPLE_F E
, PER_ALL_ASSIGNMENTS_F A
WHERE A.PERSON_ID = E.PERSON_ID
AND ((E.CURRENT_EMPLOYEE_FLAG = 'Y'
AND A.ASSIGNMENT_TYPE = 'E') OR (E.CURRENT_NPW_FLAG = 'Y'
AND A.ASSIGNMENT_TYPE = 'C'))
AND A.MANAGER_FLAG = 'Y'
Columns
Name |
FULL_NAME |
EMPLOYEE_NUMBER |
ORGANIZATION_ID |
BUSINESS_GROUP_ID |
ASS_EFFECTIVE_START_DATE |
ASS_EFFECTIVE_END_DATE |
PEO_EFFECTIVE_START_DATE |
PEO_EFFECTIVE_END_DATE |
NPW_NUMBER |