DBA Data[Home] [Help]

APPS.OKL_LEASE_OPPORTUNITY_PVT dependencies on OKL_QUICK_QUOTE_LINES_TL

Line 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);

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: