85:
86:
87: Cursor Sel_Bus Is
88: select inf.org_information9
89: from hr_organization_information hoi
90: , hr_organization_information inf
91: where hoi.organization_id = p_BUSINESS_GROUP_ID
92: and hoi.org_information_context||'' = 'CLASS'
93: and hoi.org_information1 = 'HR_BG'
86:
87: Cursor Sel_Bus Is
88: select inf.org_information9
89: from hr_organization_information hoi
90: , hr_organization_information inf
91: where hoi.organization_id = p_BUSINESS_GROUP_ID
92: and hoi.org_information_context||'' = 'CLASS'
93: and hoi.org_information1 = 'HR_BG'
94: and hoi.org_information2 = 'Y'
325:
326:
327: Cursor Sel_Bus Is
328: select inf.org_information9
329: from hr_organization_information hoi
330: , hr_organization_information inf
331: where hoi.organization_id = p_BUSINESS_GROUP_ID
332: and hoi.org_information_context||'' = 'CLASS'
333: and hoi.org_information1 = 'HR_BG'
326:
327: Cursor Sel_Bus Is
328: select inf.org_information9
329: from hr_organization_information hoi
330: , hr_organization_information inf
331: where hoi.organization_id = p_BUSINESS_GROUP_ID
332: and hoi.org_information_context||'' = 'CLASS'
333: and hoi.org_information1 = 'HR_BG'
334: and hoi.org_information2 = 'Y'