APPS.QP_MODIFIER_UPGRADE_PVT dependencies on SO_DISCOUNTS

Line 215: SO_DISCOUNTS;

211: INTO
212: l_min_line,
213: l_max_line
214: FROM
215: SO_DISCOUNTS;
216:
217: EXCEPTION
218: when others then
219: null;

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 299: FROM SO_DISCOUNTS a

295: WHERE DISCOUNT_LINE_ID = p_discount_line_id;
296:
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:

Line 937: -- in so_discounts table

933: IF (are_there_discount_lines = 'N' ) THEN /* Order Level Discount */
934:
935:
936: -- Determine the Arthimetic Operator and Operand in qp_list_lines from Percent and Amount columns
937: -- in so_discounts table
938:
939: Get_Percent(i.percent , i.amount , 0 , x_operand , x_arithmetic_operator);
940:
941: IF (x_arithmetic_operator = 'AMT') THEN