DBA Data[Home] [Help]

APPS.AHL_PP_MATERIALS_PVT dependencies on BOM_DEPARTMENTS

Line 202: FROM BOM_DEPARTMENTS

198: p_department_id <> FND_API.G_MISS_NUM)
199: THEN
200: SELECT department_id
201: INTO x_department_id
202: FROM BOM_DEPARTMENTS
203: WHERE organization_id = p_organization_id
204: AND department_id = p_department_id;
205: ELSE
206: --

Line 209: FROM BOM_DEPARTMENTS

205: ELSE
206: --
207: SELECT department_id
208: INTO x_department_id
209: FROM BOM_DEPARTMENTS
210: WHERE organization_id = p_organization_id
211: AND description = p_dept_description;
212: END IF;
213: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;