View: HR_ASSIGN_BASE_V

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.HR_ASSIGN_BASE_V

View Text

SELECT DISTINCT PEO.FULL_NAME
, PEO.PERSON_ID
, PEO.BUSINESS_GROUP_ID
, PEO.EFFECTIVE_START_DATE
, PEO.EFFECTIVE_END_DATE
FROM PER_PEOPLE_F PEO
WHERE PEO.PERSON_ID IN ( SELECT PERSON_ID
FROM PER_ASSIGNMENTS_F
WHERE ASSIGNMENT_TYPE ='E'
AND PRIMARY_FLAG = 'Y')
AND PEO.PERSON_TYPE_ID IN ( SELECT PERSON_TYPE_ID
FROM PER_PERSON_TYPES
WHERE SYSTEM_PERSON_TYPE IN('EMP'
, 'EMP_APL'))

Columns