APPS.POR_LOAD_LOCATION dependencies on HR_ORGANIZATION_UNITS
Line 181: FROM HR_ORGANIZATION_UNITS HOU,
177: -- this query is written to replace the org_organization_definitions view, which
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