767: -- WORKAROUND: Until QP fixes their API
768: x_from_advanced_pricing := 'N';
769: BEGIN
770: SELECT 'Y' INTO x_from_advanced_pricing 771: FROM qp_ldets_v 772: WHERE line_index = 1
773: AND LIST_LINE_TYPE_CODE = 'PLL';
774: EXCEPTION WHEN OTHERS THEN
775: null; -- if no_data_found then value remains unchanged. If other error no need to raise it