178: -- causing a performance issue.
179: SELECT HOU.organization_id
180: INTO l_organization_id
181: FROM HR_ORGANIZATION_UNITS HOU,
182: HR_ORGANIZATION_INFORMATION HOI1,
183: HR_ORGANIZATION_INFORMATION HOI2,
184: MTL_PARAMETERS MP,
185: GL_SETS_OF_BOOKS GSOB
186: WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
179: SELECT HOU.organization_id
180: INTO l_organization_id
181: FROM HR_ORGANIZATION_UNITS HOU,
182: HR_ORGANIZATION_INFORMATION HOI1,
183: HR_ORGANIZATION_INFORMATION HOI2,
184: MTL_PARAMETERS MP,
185: GL_SETS_OF_BOOKS GSOB
186: WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
187: AND HOU.ORGANIZATION_ID = HOI2.ORGANIZATION_ID