710:
711: CURSOR srv_csr (p_serv_top_line_id NUMBER) IS
712: SELECT item_id inventory_item_id,
713: SUM(service_item_qty) quantity
714: FROM okl_la_cov_asset_uv
715: WHERE serv_top_line_id = p_serv_top_line_id
716: GROUP BY item_id;
717:
718: l_lne l_lne_csr%ROWTYPE;
892:
893: CURSOR srv_amt_csr (p_serv_top_line_id NUMBER) IS
894: SELECT item_id inventory_item_id,
895: SUM(NVL(price_negotiated,0)) amount
896: FROM okl_la_cov_asset_uv
897: WHERE serv_top_line_id = p_serv_top_line_id
898: GROUP BY item_id;
899:
900: l_lne l_toplne_csr%ROWTYPE;