439: BEGIN
440:
441: FOR l_qqh IN c_qqh LOOP
442:
443: DELETE FROM okl_quick_quote_lines_tl WHERE id IN (SELECT id FROM okl_quick_quote_lines_b WHERE quick_quote_id = l_qqh.id);
444: DELETE FROM okl_quick_quote_lines_b WHERE quick_quote_id = l_qqh.id;
445: DELETE FROM okl_quick_quotes_b WHERE id = l_qqh.id;
446: DELETE FROM okl_quick_quotes_tl WHERE id = l_qqh.id;
447:
440:
441: FOR l_qqh IN c_qqh LOOP
442:
443: DELETE FROM okl_quick_quote_lines_tl WHERE id IN (SELECT id FROM okl_quick_quote_lines_b WHERE quick_quote_id = l_qqh.id);
444: DELETE FROM okl_quick_quote_lines_b WHERE quick_quote_id = l_qqh.id;
445: DELETE FROM okl_quick_quotes_b WHERE id = l_qqh.id;
446: DELETE FROM okl_quick_quotes_tl WHERE id = l_qqh.id;
447:
448: END LOOP;