VIEW: APPS.PER_MANAGER_LOV

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'