APPS.PER_OSV_BUS dependencies on PER_ORGANIZATION_STRUCTURES

Line 34: from per_organization_structures

30: hr_utility.set_location('Entering:'|| l_proc, 10);
31: --
32: select business_group_id
33: into p_business_group_id
34: from per_organization_structures
35: where p_organization_structure_id = organization_structure_id;
36:
37: --
38: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 163: from per_organization_structures

159: -- Declare cursor
160: --
161: cursor csr_parent is
162: select count(*) as count
163: from per_organization_structures
164: where position_control_structure_flg = 'Y'
165: and p_organization_structure_id = organization_structure_id;
166: begin
167: --

Line 214: from per_organization_structures

210: --
211: --
212: select count(*) as count
213: into l_count
214: from per_organization_structures
215: where p_organization_structure_id = organization_structure_id;
216:
217: if l_count =0 then
218: hr_utility.set_message(800, 'HR_51022_HR_INV_PRIMARY_KEY');