432: l_count NUMBER;
433: l_return_status VARCHAR2(80);
434:
435: CURSOR sel_item_taxable_flag
436: (c_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE,
437: c_item_org_id mtl_system_items_b.organization_id%TYPE,
438: c_ship_to_loc_org_id mtl_system_items_b.organization_id%TYPE) IS
439:
440: SELECT taxable_flag
433: l_return_status VARCHAR2(80);
434:
435: CURSOR sel_item_taxable_flag
436: (c_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE,
437: c_item_org_id mtl_system_items_b.organization_id%TYPE,
438: c_ship_to_loc_org_id mtl_system_items_b.organization_id%TYPE) IS
439:
440: SELECT taxable_flag
441: FROM mtl_system_items si
434:
435: CURSOR sel_item_taxable_flag
436: (c_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE,
437: c_item_org_id mtl_system_items_b.organization_id%TYPE,
438: c_ship_to_loc_org_id mtl_system_items_b.organization_id%TYPE) IS
439:
440: SELECT taxable_flag
441: FROM mtl_system_items si
442: WHERE si.inventory_item_id = c_inventory_item_id