APPS.AHL_LTP_SPACE_ASSIGN_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 354: FROM HR_ALL_ORGANIZATION_UNITS

350: IF (p_organization_id IS NOT NULL)
351: THEN
352: SELECT organization_id
353: INTO x_organization_id
354: FROM HR_ALL_ORGANIZATION_UNITS
355: WHERE organization_id = p_organization_id;
356: ELSE
357: SELECT organization_id
358: INTO x_organization_id

Line 359: FROM HR_ALL_ORGANIZATION_UNITS

355: WHERE organization_id = p_organization_id;
356: ELSE
357: SELECT organization_id
358: INTO x_organization_id
359: FROM HR_ALL_ORGANIZATION_UNITS
360: WHERE NAME = p_org_name;
361: END IF;
362: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
363: EXCEPTION