VIEW: APPS.HR_ASSIGN_BASE_V

Source

View Text - Preformatted

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'))

View Text - HTML Formatted

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'))