APPS.QP_PRC_UTIL dependencies on OE_PRICE_ADJUSTMENTS

Line 122: FROM OE_PRICE_ADJUSTMENTS

118: -- Query total.
119:
120: SELECT SUM ( OPERAND ) --QP change percent to OPERAND QP END
121: INTO l_adj_total
122: FROM OE_PRICE_ADJUSTMENTS
123: WHERE HEADER_ID = p_header_id
124: AND LINE_ID IS NULL;
125:
126: IF l_adj_total IS NULL THEN

Line 364: FROM OE_PRICE_ADJUSTMENTS P, QP_LIST_HEADERS D

360: P.OPERAND , -- CHANGE PERCENT TO OPERAND
361: P.HEADER_ID , --
362: P.LINE_ID , -- Change OE_DISCOUNT to QP_LIST_HEADERS
363: D.NAME
364: FROM OE_PRICE_ADJUSTMENTS P, QP_LIST_HEADERS D
365: WHERE P.LINE_ID = p_line_id
366: AND P.LIST_HEADER_ID = D.LIST_HEADER_ID;
367: -- QP END
368: CURSOR l_hdr_adj_csr IS

Line 376: FROM OE_PRICE_ADJUSTMENTS P, QP_LIST_HEADERS D

372: P.AUTOMATIC_FLAG ,
373: P.OPERAND , -- CHANGE PERCENT TO OPERAN
374: P.HEADER_ID , -- Change OE_DISCOUNT to QP_LIST_HEADERS
375: D.NAME
376: FROM OE_PRICE_ADJUSTMENTS P, QP_LIST_HEADERS D
377: WHERE HEADER_ID = p_header_id
378: AND LINE_ID IS NULL
379: AND P.DISCOUNT_ID = D.LIST_HEADER_ID;
380: -- QP END