[Home] [Help]
425: ELSE
426: BEGIN
427: SELECT SUPPLIER_NEW_PRICE, PRICE_CHANGE
428: INTO l_supp_new_price, l_price_change
429: FROM DPP_TRANSACTION_LINES_ALL
430: WHERE transaction_line_id = l_customer_tbl(i).transaction_line_id;
431: EXCEPTION
432: WHEN NO_DATA_FOUND THEN
433: l_supp_new_price := 0;