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