985: -- WORKAROUND: Until QP fixes their API
986: x_from_advanced_pricing := 'N';
987: BEGIN
988: SELECT 'Y' INTO x_from_advanced_pricing 989: FROM qp_ldets_v 990: WHERE line_index = 1
991: AND LIST_LINE_TYPE_CODE = 'PLL';
992: EXCEPTION WHEN OTHERS THEN
993: NULL; -- if no_data_found then value remains unchanged. If other error no need to raise it