32: ,per_all_assignments_f paaf
33: ,per_all_people_f papf
34: ,hr_soft_coding_keyflex hsck
35: ,per_business_groups pbg
36: ,hr_organization_units org
37: ,per_person_types ppt
38: ,per_assignment_status_types past
39: WHERE ptoa.object_id = paaf.assignment_id
40: AND ptoa.object_type = 'ASG'