APPS.AHL_PP_MATERIALS_PVT dependencies on BOM_DEPARTMENTS

Line 162: FROM BOM_DEPARTMENTS

158: p_department_id <> FND_API.G_MISS_NUM)
159: THEN
160: SELECT department_id
161: INTO x_department_id
162: FROM BOM_DEPARTMENTS
163: WHERE organization_id = p_organization_id
164: AND department_id = p_department_id;
165: ELSE
166: --

Line 169: FROM BOM_DEPARTMENTS

165: ELSE
166: --
167: SELECT department_id
168: INTO x_department_id
169: FROM BOM_DEPARTMENTS
170: WHERE organization_id = p_organization_id
171: AND description = p_dept_description;
172: END IF;
173: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;