109: ,ass.establishment_id
110: FROM pay_payroll_actions bppa
111: ,per_assignments_f ass
112: ,hr_organization_information hoi
113: ,hr_organization_units hou
114: WHERE bppa.payroll_action_id = p_payroll_action_id
115: AND ass.person_id BETWEEN p_start_person_id AND p_end_person_id
116: -- Bug 3506172
117: AND ass.establishment_id = hoi.organization_id