APPS.QP_MODIFIER_UPGRADE_PVT dependencies on QP_DISCOUNT_MAPPING

Line 84: INSERT INTO QP_DISCOUNT_MAPPING(OLD_DISCOUNT_ID,OLD_DISCOUNT_LINE_ID,

80: err_msg varchar2(2000);
81:
82: BEGIN
83:
84: INSERT INTO QP_DISCOUNT_MAPPING(OLD_DISCOUNT_ID,OLD_DISCOUNT_LINE_ID,
85: NEW_LIST_HEADER_ID,NEW_LIST_LINE_ID, OLD_PRICE_BREAK_LINES_LOW,
86: OLD_PRICE_BREAK_LINES_HIGH, OLD_METHOD_TYPE_CODE, OLD_PRICE_BREAK_PERCENT,
87: OLD_PRICE_BREAK_AMOUNT, OLD_PRICE_BREAK_PRICE, NEW_TYPE,PRICING_CONTEXT)
88: VALUES (p_old_discount_id,p_old_discount_line_id,p_new_list_header_id,p_new_list_line_id,

Line 263: FROM QP_DISCOUNT_MAPPING a

259: sod.ATTRIBUTE14, sod.ATTRIBUTE15
260: FROM SO_DISCOUNTS sod,QP_LIST_HEADERS_B sopl
261: WHERE sod.price_list_id = sopl.list_header_id
262: AND NOT EXISTS (SELECT 'x'
263: FROM QP_DISCOUNT_MAPPING a
264: WHERE a.OLD_DISCOUNT_ID = sod.DISCOUNT_ID
265: AND a.NEW_TYPE in ('O','L','Q','X'))
266: AND sod.DISCOUNT_ID BETWEEN p_min_line and p_max_line;
267: