769: per_people p
770: , per_assignments asg
771: , hr_assignment_set_amendments asa
772: , hr_assignment_sets ass
773: , per_person_types ppt --added 2943706
774: , per_person_type_usages pptu
775:
776: WHERE ass.assignment_set_id = p_populate_id
777: AND asa.assignment_set_id = ass.assignment_set_id
792: , hr_person_type_usage_info.get_user_person_type(p.effective_start_date, p.person_id) person_type
793: FROM
794: per_people p
795: , per_assignments asg
796: , per_person_types ppt --added 2943706
797: , per_person_type_usages pptu
798: WHERE asg.organization_id = p_populate_id
799: AND p.person_id = asg.person_id
800: AND pptu.person_id = p.person_id