638: --
639: --BUG 4287842
640:
641: CURSOR get_inv_item_id(p_instance_id number) IS
642: select inventory_item_id from csi_item_instances
643: where instance_id = p_instance_id;
644: --
645: CURSOR acct_from_party(p_party_id number) IS
646: SELECT count(cust_account_id)
1892: l_ib_serial_number := null;
1893: BEGIN
1894: select serial_number
1895: into l_ib_serial_number
1896: from CSI_ITEM_INSTANCES
1897: where instance_id = EstDtlTab(i).customer_product_id;
1898: EXCEPTION
1899: -- Serial_number is available only if the instance is serialized
1900: /* WHEN NO_DATA_FOUND THEN