61:
62: -- Define cursor to get Operating Unit for Inventory Org
63: -- Bug 5196069. SQL Repository Fix SQL ID 17898437.
64: -- Removed usage of inv_organization_info_v and replaced with
65: -- call to base table hr_organization_information
66: -- to improve performance.
67: CURSOR c_org_id IS
68: SELECT to_number(org_information3)
69: FROM hr_organization_information
65: -- call to base table hr_organization_information
66: -- to improve performance.
67: CURSOR c_org_id IS
68: SELECT to_number(org_information3)
69: FROM hr_organization_information
70: WHERE organization_id = p_organization_id
71: AND org_information_context = 'Accounting Information';
72:
73: