172:
173: -- Bug no 2932073 And 2878657
174: -- added local Variable to hold the ligislation code.
175:
176: l_legislation_code hr_organization_information.org_information9%TYPE;
177:
178: -- Cursor for selecting the Legislation code
179:
180: cursor c_legislation_code (p_bg_id number) is
179:
180: cursor c_legislation_code (p_bg_id number) is
181: select hoi.org_information9
182: from hr_all_organization_units org
183: , hr_organization_information hoi
184: where hoi.organization_id = org.business_group_id
185: and hoi.org_information_context = 'Business Group Information'
186: and org.business_group_id = p_bg_id;
187: