[Home] [Help]
2549: IF l_k_line_rec.coverage_schd_id IS NULL THEN
2550:
2551: UPDATE oks_k_lines_b
2552: SET toplvl_price_qty = (SELECT Sum(quantity)
2553: FROM OKS_SUBSCR_ELEMENTS_V
2554: WHERE DNZ_CLE_ID=l_lineid),
2555: toplvl_uom_code = (SELECT uom_code
2556: FROM okc_k_items
2557: WHERE cle_id=l_lineid)