APPS.PER_PER_BUS dependencies on HR_ORGANIZATION_INFORMATION

Line 36: from hr_organization_information hoi

32: -- replaced per_people_f with per_all_people_f in this cursor.
33: --
34: cursor csr_sec_grp is
35: select hoi.org_information14, hoi.org_information9
36: from hr_organization_information hoi
37: , per_all_people_f per
38: where per.person_id = p_person_id
39: and hoi.organization_id = per.business_group_id
40: and hoi.org_information_context||'' = 'Business Group Information';

Line 9318: FROM hr_organization_information o3

9314: -- Declare cursor
9315: -- Bug 14074720
9316: cursor csr_leg_code is
9317: SELECT o3.org_information9
9318: FROM hr_organization_information o3
9319: WHERE o3.org_information_context = 'Business Group Information'
9320: AND o3.organization_id IN
9321: (
9322: SELECT business_group_id