142: assign.supervisor_id manager_id
143: FROM per_people_f per,
144: per_assignments_f assign,
145: hr_all_organization_units hou,
146: pa_resource_txn_attributes rta
147: WHERE rta.resource_id = l_resource_id
148: AND rta.person_id = per.person_id
149: AND rta.person_id = assign.person_id
150: AND assign.primary_flag = 'Y'
4876: hou.name
4877: FROM per_people_f per,
4878: per_assignments_f assign,
4879: hr_all_organization_units hou,
4880: pa_resource_txn_attributes rta
4881: WHERE rta.resource_id = l_resource_id
4882: AND rta.person_id = per.person_id
4883: AND rta.person_id = assign.person_id
4884: AND assign.primary_flag = 'Y'