APPS.AHL_LTP_SPACE_CAPB_PVT dependencies on BOM_DEPARTMENTS

Line 152: FROM BOM_DEPARTMENTS

148: IF (p_department_id IS NOT NULL)
149: THEN
150: SELECT department_id
151: INTO x_department_id
152: FROM BOM_DEPARTMENTS
153: WHERE organization_id = p_organization_id
154: AND department_id = p_department_id;
155: END IF;
156: --

Line 160: FROM BOM_DEPARTMENTS

156: --
157: IF(p_dept_description IS NOT NULL) THEN
158: SELECT department_id
159: INTO x_department_id
160: FROM BOM_DEPARTMENTS
161: WHERE organization_id = p_organization_id
162: AND description = p_dept_description;
163: END IF;
164: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;