APPS.QP_MODIFIER_UPGRADE_PVT dependencies on QP_LIST_HEADERS_B

Line 260: FROM SO_DISCOUNTS sod,QP_LIST_HEADERS_B sopl

256: sod.DESCRIPTION, sod.DISCOUNT_LINES_FLAG, sopl.CURRENCY_CODE,sod.CONTEXT,
257: sod.ATTRIBUTE1, sod.ATTRIBUTE2, sod.ATTRIBUTE3,sod.ATTRIBUTE4,sod.ATTRIBUTE5,sod.ATTRIBUTE6,sod.ATTRIBUTE7,
258: sod.ATTRIBUTE8, sod.ATTRIBUTE9,sod.ATTRIBUTE10,sod.ATTRIBUTE11,sod.ATTRIBUTE12,sod.ATTRIBUTE13,
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

Line 301: FROM QP_LIST_HEADERS_B b

297: CURSOR get_discounts_not_migrated_cur IS
298: SELECT a.DISCOUNT_ID,a.PRICE_LIST_ID
299: FROM SO_DISCOUNTS a
300: WHERE NOT EXISTS ( SELECT 'x'
301: FROM QP_LIST_HEADERS_B b
302: WHERE b.LIST_HEADER_ID = a.PRICE_LIST_ID);
303:
304: CURSOR get_contexts_for_pattrs_cur(p_entity_id NUMBER) IS
305: SELECT nvl(a.DESCRIPTIVE_FLEX_CONTEXT_CODE,'Global Data Elements') descriptive_flex_context_code ,

Line 322: x_list_header_id QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE;

318: WHERE a.PRICE_LIST_ID = p_price_list_id
319: AND a.INVENTORY_ITEM_ID = p_entity_value;
320:
321:
322: x_list_header_id QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE;
323: v_list_header_id QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE;
324: x_list_line_id QP_LIST_LINES.LIST_LINE_ID%TYPE;
325: v_list_line_id QP_LIST_LINES.LIST_LINE_ID%TYPE;
326: v_price_break_line_id QP_LIST_LINES.LIST_LINE_ID%TYPE;

Line 323: v_list_header_id QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE;

319: AND a.INVENTORY_ITEM_ID = p_entity_value;
320:
321:
322: x_list_header_id QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE;
323: v_list_header_id QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE;
324: x_list_line_id QP_LIST_LINES.LIST_LINE_ID%TYPE;
325: v_list_line_id QP_LIST_LINES.LIST_LINE_ID%TYPE;
326: v_price_break_line_id QP_LIST_LINES.LIST_LINE_ID%TYPE;
327: x_pricing_attribute_id QP_PRICING_ATTRIBUTES.PRICING_ATTRIBUTE_ID%TYPE;