The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT SUM ( OPERAND ) --QP change percent to OPERAND QP END
INTO l_adj_total
FROM OE_PRICE_ADJUSTMENTS
WHERE HEADER_ID = p_header_id
AND LINE_ID IS NULL;
SELECT AGREEMENT_TYPE_CODE
INTO l_agr_type_code
FROM OE_AGREEMENTS
WHERE AGREEMENT_ID = p_agreement_id;
SELECT CATEGORY_ID
INTO l_item_category_id
FROM MTL_ITEM_CATEGORIES CAT
, MTL_DEFAULT_CATEGORY_SETS DCS
WHERE CAT.INVENTORY_ITEM_ID = p_item_id
AND CAT.ORGANIZATION_ID = l_org_id
AND CAT.CATEGORY_SET_ID = DCS.CATEGORY_SET_ID
AND DCS.FUNCTIONAL_AREA_ID = 7;
SELECT CUSTOMER_CLASS_CODE
INTO l_class_code
FROM HZ_CUST_ACCOUNTS
WHERE CUST_ACCOUNT_ID = p_sold_to_org_id;
SELECT AK.NAME
INTO l_attribute_name
FROM AK_ATTRIBUTES_VL AK
WHERE AK.attribute_code = upper(p_attribute_code)
AND AK.attribute_application_id = 661;
SELECT P.PRICE_ADJUSTMENT_ID , -- QP
P.LIST_HEADER_ID , -- CHANGE FROM DISCOUNT_ID TO LIST_HEADER_ID
P.LIST_LINE_ID , -- CHANGE FROM DISCOUNT_LINE TO LIST_LINE_ID
P.AUTOMATIC_FLAG ,
P.OPERAND , -- CHANGE PERCENT TO OPERAND
P.HEADER_ID , --
P.LINE_ID , -- Change OE_DISCOUNT to QP_LIST_HEADERS
D.NAME
FROM OE_PRICE_ADJUSTMENTS P, QP_LIST_HEADERS D
WHERE P.LINE_ID = p_line_id
AND P.LIST_HEADER_ID = D.LIST_HEADER_ID;
SELECT P.PRICE_ADJUSTMENT_ID ,
P.LIST_HEADER_ID , --QP CHANGE FROM DISCOUNT_ID TO LIST_HEADER_ID
P.LIST_LINE_ID , -- CHANGE FROM DISCOUNT_LINE_ID TO LIST_LINE_ID
P.AUTOMATIC_FLAG ,
P.OPERAND , -- CHANGE PERCENT TO OPERAN
P.HEADER_ID , -- Change OE_DISCOUNT to QP_LIST_HEADERS
D.NAME
FROM OE_PRICE_ADJUSTMENTS P, QP_LIST_HEADERS D
WHERE HEADER_ID = p_header_id
AND LINE_ID IS NULL
AND P.DISCOUNT_ID = D.LIST_HEADER_ID;
SELECT DISTINCT l.entity_id
FROM oe_discount_lines l,
oe_discounts d
WHERE d.automatic_discount_flag = 'Y'
AND d.discount_id = l.discount_id;
SELECT DISTINCT QPPA.PRODUCT_ATTRIBUTE
FROM QP_PRICING_ATTRIBUTES QPPA
, QP_LIST_LINES QPLL
, QP_LIST_HEADERS QPLH
WHERE QPLL.LIST_LINE_ID = QPPA.LIST_LINE_ID
AND QPLL.LIST_HEADER_ID = QPLH.LIST_HEADER_ID
AND QPLH.AUTOMATIC_FLAG = 'Y'
AND QPPA.PRODUCT_ATTRIBUTE IN (G_ITEM_NAME
,G_ITEM_CATEGORY_NAME)
AND QPPA.PRODUCT_ATTRIBUTE_CONTEXT IN (G_ITEM_CONTEXT
,G_ITEM_CATEGORY_CONTEXT)
UNION
SELECT DISTINCT QPQ.QUALIFIER_ATTRIBUTE
FROM QP_QUALIFIERS QPQ
,QP_LIST_HEADERS QPLH
,QP_LIST_LINES QPLL
WHERE QPQ.LIST_HEADER_ID = QPLH.LIST_HEADER_ID
AND QPLL.LIST_HEADER_ID = QPLH.LIST_HEADER_ID
AND QPLH.AUTOMATIC_FLAG = 'Y'
AND QPQ.QUALIFIER_ATTRIBUTE IN (G_CUSTOMER_PO_NAME
,G_AGREEMENT_TYPE_NAME
,G_AGREEMENT_NAME
,G_ORDER_TYPE_NAME)
AND QPQ.QUALIFIER_CONTEXT IN (G_CUSTOMER_PO_CONTEXT
,G_AGREEMENT_TYPE_CONTEXT
,G_AGREEMENT_CONTEXT
,G_ORDER_TYPE_CONTEXT);*/
OE_DEBUG_PUB.ADD('|IN Big select statement --Header| ');
SELECT QPH.LIST_HEADER_ID, QPL.LIST_LINE_ID, QPH.NAME,
DECODE(QPL.ARITHMETIC_OPERATOR,'AMT',NVL(QPL.OPERAND/p_list_price * 100,0),
'%',NVL(QPL.OPERAND,0))
FROM QP_LIST_HEADERS QPH , QP_LIST_LINES QPL , QP_QUALIFIERS QPQ
WHERE QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
AND QPH.LIST_HEADER_ID = QPQ.LIST_HEADER_ID
AND QPQ.QUALIFIER_CONTEXT = G_PRICE_LIST_CONTEXT
AND QPQ.QUALIFIER_ATTRIBUTE =G_PRICE_LIST_NAME
AND QPQ.QUALIFIER_ATTR_VALUE = p_price_list_id
AND QPH.AUTOMATIC_FLAG = 'Y'
AND QPH.DISCOUNT_LINES_FLAG = 'N'
AND (p_gsa = 'Y'
OR NVL(QPH.GSA_INDICATOR,'N') = 'N')
AND TRUNC(l_pricing_date) BETWEEN NVL(QPH.START_DATE_ACTIVE, TRUNC(l_pricing_date))
AND NVL(QPH.END_DATE_ACTIVE, l_pricing_date)
AND DECODE(QPL.ARITHMETIC_OPERATOR,'AMT',NVL(QPL.OPERAND/p_list_price * 100,0),
'%', NVL(QPL.OPERAND,0)) < p_best_adj_percent
AND ( NOT EXISTS (SELECT NULL
FROM QP_QUALIFIERS QPQ
WHERE QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID
AND QPQ.QUALIFIER_CONTEXT = G_CUSTOMER_CLASS_CONTEXT
AND QPQ.QUALIFIER_ATTRIBUTE IN (G_CUSTOMER_CLASS_NAME
,G_SOLD_TO_ORG_NAME
,G_SITE_ORG_NAME))
OR
( EXISTS(SELECT NULL
FROM QP_QUALIFIERS QPQ
WHERE QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID
AND (QPQ.QUALIFIER_CONTEXT = G_SOLD_TO_ORG_CONTEXT
AND QPQ.QUALIFIER_ATTRIBUTE = G_SOLD_TO_ORG_NAME
AND NVL(QPQ.QUALIFIER_ATTR_VALUE,p_sold_to_org_id) = p_sold_to_org_id))
OR EXISTS(SELECT NULL
FROM QP_QUALIFIERS QPQ
WHERE QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID
AND (qpq.qualifier_context = G_CUSTOMER_CLASS_CONTEXT
AND QPQ.QUALIFIER_ATTRIBUTE = G_CUSTOMER_CLASS_NAME
AND NVL(QPQ.QUALIFIER_ATTR_VALUE,p_customer_class_code) =
p_customer_class_code))
AND EXISTS(SELECT NULL
FROM QP_QUALIFIERS QPQ
WHERE (QPQ.QUALIFIER_CONTEXT = G_CUSTOMER_CLASS_CONTEXT
AND QPQ.QUALIFIER_ATTRIBUTE = G_SITE_ORG_NAME
AND (NVL(QPQ.QUALIFIER_ATTR_VALUE,p_ship_to_id) = p_ship_to_id
OR NVL(QPQ.QUALIFIER_ATTR_VALUE,p_invoice_to_id) = p_invoice_to_id)))))
AND TRUNC(l_pricing_date) BETWEEN NVL(QPH.START_DATE_ACTIVE, TRUNC(l_pricing_date))
AND NVL(QPH.END_DATE_ACTIVE, l_pricing_date)
ORDER BY DECODE(QPL.ARITHMETIC_OPERATOR,'AMT',nvl(QPL.OPERAND/p_list_price * 100,0),
'%', NVL(QPL.OPERAND,0)) ASC;
OE_DEBUG_PUB.ADD('|IN Big select statement --Header| ');
SELECT QPH.LIST_HEADER_ID,QPL.LIST_LINE_ID, QPH.NAME,
DECODE(QPL.ARITHMETIC_OPERATOR,'AMT',NVL(QPL.OPERAND/p_list_price * 100,0),
'%',NVL(QPL.OPERAND,0))
FROM QP_LIST_HEADERS QPH , QP_LIST_LINES QPL , QP_QUALIFIERS QPQ
WHERE QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
AND QPH.LIST_HEADER_ID = QPQ.LIST_HEADER_ID
AND QPQ.QUALIFIER_CONTEXT = G_PRICE_LIST_CONTEXT
AND QPQ.QUALIFIER_ATTRIBUTE =G_PRICE_LIST_NAME
AND QPQ.QUALIFIER_ATTR_VALUE = p_price_list_id
AND QPH.AUTOMATIC_FLAG = 'Y'
AND QPH.DISCOUNT_LINES_FLAG = 'N'
AND (p_gsa = 'Y'
OR NVL(QPH.GSA_INDICATOR,'N') = 'N')
AND TRUNC(l_pricing_date) BETWEEN NVL(QPH.START_DATE_ACTIVE, TRUNC(l_pricing_date))
AND NVL(QPH.END_DATE_ACTIVE, l_pricing_date)
AND DECODE(QPL.ARITHMETIC_OPERATOR,'AMT',NVL(QPL.OPERAND/p_list_price * 100,0),
'%', NVL(QPL.OPERAND,0)) > p_best_adj_percent
AND ( NOT EXISTS (SELECT NULL
FROM QP_QUALIFIERS QPQ
WHERE QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID
AND QPQ.QUALIFIER_CONTEXT = G_CUSTOMER_CLASS_CONTEXT
AND QPQ.QUALIFIER_ATTRIBUTE IN (G_CUSTOMER_CLASS_NAME
,G_SOLD_TO_ORG_NAME
,G_SITE_ORG_NAME))
OR
( EXISTS(SELECT NULL
FROM QP_QUALIFIERS QPQ
WHERE QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID
AND (QPQ.QUALIFIER_CONTEXT = G_SOLD_TO_ORG_CONTEXT
AND QPQ.QUALIFIER_ATTRIBUTE = G_SOLD_TO_ORG_NAME
AND NVL(QPQ.QUALIFIER_ATTR_VALUE,p_sold_to_org_id) = p_sold_to_org_id))
AND EXISTS(SELECT NULL
FROM QP_QUALIFIERS QPQ
WHERE QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID
AND (qpq.qualifier_context = G_CUSTOMER_CLASS_CONTEXT
AND QPQ.QUALIFIER_ATTRIBUTE = G_CUSTOMER_CLASS_NAME
AND NVL(QPQ.QUALIFIER_ATTR_VALUE,
NVL(p_customer_class_code,'NULL')) =
NVL(p_customer_class_code,'NULL') ))
AND EXISTS(SELECT NULL
FROM QP_QUALIFIERS QPQ
WHERE QPQ.QUALIFIER_CONTEXT = G_CUSTOMER_CLASS_CONTEXT
AND QPQ.QUALIFIER_ATTRIBUTE = G_SITE_ORG_NAME
AND (NVL(QPQ.QUALIFIER_ATTR_VALUE,p_ship_to_id) = p_ship_to_id
OR NVL(QPQ.QUALIFIER_ATTR_VALUE,p_invoice_to_id) = p_invoice_to_id
)
)
)
)
AND TRUNC(l_pricing_date) BETWEEN NVL(QPH.START_DATE_ACTIVE, TRUNC(l_pricing_date))
AND NVL(QPH.END_DATE_ACTIVE, l_pricing_date)
ORDER BY DECODE(QPL.ARITHMETIC_OPERATOR,'AMT',nvl(QPL.OPERAND/p_list_price * 100,0),
'%', NVL(QPL.OPERAND,0)) DESC;
SELECT
ORDERED
INDEX(OEDLN OE_DISCOUNT_LINE_N2)
INDEX(OEDIS OE_DISCOUNTS_U1)
OEDIS.DISCOUNT_ID,
OEDIS.NAME,
NVL( OEDLN.DISCOUNT_LINE_ID, -1 ),
NVL( OEDIS.AMOUNT / p_list_price * 100,
NVL( OEDIS.PERCENT,
NVL( ( p_list_price - OEDLN.PRICE ) / p_list_price * 100,
NVL( OEDLN.AMOUNT / p_list_price * 100,
NVL( OEDLN.PERCENT,
NVL( ( p_list_price - OEPBL.PRICE ) / p_list_price * 100,
NVL( OEPBL.AMOUNT / p_list_price * 100,
NVL( OEPBL.PERCENT, 0 ) ) ) ) ) ) ) )
FROM OE_DISCOUNT_LINES OEDLN
, OE_DISCOUNTS OEDIS
, OE_PRICE_BREAK_LINES OEPBL
WHERE OEDLN.ENTITY_ID = p_attribute_id
AND OEDLN.ENTITY_VALUE = p_attribute_value
AND TRUNC(L_PRICING_DATE) BETWEEN
NVL( OEDLN.START_DATE_ACTIVE, TRUNC(L_PRICING_DATE) )
AND NVL( OEDLN.END_DATE_ACTIVE, TRUNC(L_PRICING_DATE) )
AND OEDIS.DISCOUNT_ID = OEDLN.DISCOUNT_ID
AND OEDIS.PRICE_LIST_ID = p_price_list_id
AND OEDIS.AUTOMATIC_DISCOUNT_FLAG = 'Y'
AND ( p_gsa = 'Y'
OR NVL( OEDIS.GSA_INDICATOR, 'N' ) = 'N' )
AND TRUNC(L_PRICING_DATE)
BETWEEN NVL( OEDIS.START_DATE_ACTIVE, TRUNC(L_PRICING_DATE) )
AND NVL( OEDIS.END_DATE_ACTIVE, TRUNC(L_PRICING_DATE) )
AND OEPBL.DISCOUNT_LINE_ID (+) = OEDLN.DISCOUNT_LINE_ID
AND TRUNC(L_PRICING_DATE)
BETWEEN NVL( OEPBL.START_DATE_ACTIVE (+), TRUNC(L_PRICING_DATE) )
AND NVL( OEPBL.END_DATE_ACTIVE (+), TRUNC(L_PRICING_DATE) )
AND DECODE( OEPBL.METHOD_TYPE_CODE (+),
'UNITS', p_quantity,
'DOLLARS', p_quantity * p_list_price,
0 )
BETWEEN NVL( OEPBL.PRICE_BREAK_LINES_LOW_RANGE (+),
DECODE( OEPBL.METHOD_TYPE_CODE (+),
'UNITS', p_quantity,
'DOLLARS', p_quantity * p_list_price,
0 ) )
AND NVL( OEPBL.PRICE_BREAK_LINES_HIGH_RANGE (+),
DECODE( OEPBL.METHOD_TYPE_CODE (+),
'UNITS', p_quantity,
'DOLLARS', p_quantity * p_list_price,
0 ) )
AND NVL(OEPBL.UNIT_CODE(+),NVL(p_unit_code,'NULL'))=
NVL(p_unit_code,'NULL')
AND NVL( OEDIS.AMOUNT / p_list_price * 100,
NVL( OEDIS.PERCENT,
NVL( ( p_list_price - OEDLN.PRICE ) / p_list_price * 100,
NVL( OEDLN.AMOUNT / p_list_price * 100,
NVL( OEDLN.PERCENT,
NVL( ( p_list_price - OEPBL.PRICE ) / p_list_price * 100,
NVL( OEPBL.AMOUNT / p_list_price * 100,
NVL( OEPBL.PERCENT , 0 ) ) ) ) ) ) ) ) < p_best_adj_percent
AND ( NOT EXISTS (SELECT NULL
FROM OE_DISCOUNT_CUSTOMERS OECST
WHERE OECST.DISCOUNT_ID = OEDIS.DISCOUNT_ID )
OR EXISTS (SELECT NULL
FROM OE_DISCOUNT_CUSTOMERS OECST
WHERE OECST.DISCOUNT_ID = OEDIS.DISCOUNT_ID
AND NVL( OECST.sold_to_org_id, p_sold_to_org_id ) =
p_sold_to_org_id
AND NVL( OECST.CUSTOMER_CLASS_CODE,
NVL ( p_customer_class_code, 'NULL'
) )=
NVL ( p_customer_class_code , 'NULL' )
AND ( NVL( OECST.site_org_id, p_ship_to_id) =
p_ship_to_id
OR
NVL( OECST.site_org_id, p_invoice_to_id)
= p_invoice_to_id )
AND TRUNC(L_PRICING_DATE)
BETWEEN NVL( OECST.START_DATE_ACTIVE,
TRUNC(L_PRICING_DATE))
AND NVL( OECST.END_DATE_ACTIVE,
TRUNC(L_PRICING_DATE))))
ORDER BY NVL( OEDIS.AMOUNT / p_list_price * 100,
NVL( OEDIS.PERCENT,
NVL( ( p_list_price - OEDLN.PRICE ) / p_list_price * 100,
NVL( OEDLN.AMOUNT / p_list_price * 100,
NVL( OEDLN.PERCENT,
NVL( ( p_list_price - OEPBL.PRICE ) / p_list_price * 100,
NVL( OEPBL.AMOUNT / p_list_price * 100,
NVL( OEPBL.PERCENT, 0 ) ) ) ) ) ) ) ) ASC;
SELECT
ORDERED
INDEX(OEDLN OE_DISCOUNT_LINE_N2)
INDEX(OEDIS OE_DISCOUNTS_U1)
OEDIS.DISCOUNT_ID,
OEDIS.NAME,
NVL( OEDLN.DISCOUNT_LINE_ID, -1 ),
NVL( OEDIS.AMOUNT / p_list_price * 100,
NVL( OEDIS.PERCENT,
NVL( ( p_list_price - OEDLN.PRICE ) / p_list_price * 100,
NVL( OEDLN.AMOUNT / p_list_price * 100,
NVL( OEDLN.PERCENT,
NVL( ( p_list_price - OEPBL.PRICE ) / p_list_price * 100,
NVL( OEPBL.AMOUNT / p_list_price * 100,
NVL( OEPBL.PERCENT, 0 ) ) ) ) ) ) ) )
FROM OE_DISCOUNT_LINES OEDLN
, OE_DISCOUNTS OEDIS
, OE_PRICE_BREAK_LINES OEPBL
WHERE OEDLN.ENTITY_ID = p_attribute_id
AND OEDLN.ENTITY_VALUE = p_attribute_value
AND TRUNC(L_PRICING_DATE) BETWEEN
NVL( OEDLN.START_DATE_ACTIVE, TRUNC(L_PRICING_DATE) )
AND NVL( OEDLN.END_DATE_ACTIVE, TRUNC(L_PRICING_DATE) )
AND OEDIS.DISCOUNT_ID = OEDLN.DISCOUNT_ID
AND OEDIS.PRICE_LIST_ID = p_price_list_id
AND OEDIS.AUTOMATIC_DISCOUNT_FLAG = 'Y'
AND ( p_gsa = 'Y'
OR NVL( OEDIS.GSA_INDICATOR, 'N' ) = 'N' )
AND TRUNC(L_PRICING_DATE)
BETWEEN NVL( OEDIS.START_DATE_ACTIVE, TRUNC(L_PRICING_DATE) )
AND NVL( OEDIS.END_DATE_ACTIVE, TRUNC(L_PRICING_DATE) )
AND OEPBL.DISCOUNT_LINE_ID (+) = OEDLN.DISCOUNT_LINE_ID
AND TRUNC(L_PRICING_DATE)
BETWEEN NVL( OEPBL.START_DATE_ACTIVE (+), TRUNC(L_PRICING_DATE) )
AND NVL( OEPBL.END_DATE_ACTIVE (+), TRUNC(L_PRICING_DATE) )
AND DECODE( OEPBL.METHOD_TYPE_CODE (+),
'UNITS', p_quantity,
'DOLLARS', p_quantity * p_list_price,
0 )
BETWEEN NVL( OEPBL.PRICE_BREAK_LINES_LOW_RANGE (+),
DECODE( OEPBL.METHOD_TYPE_CODE (+),
'UNITS', p_quantity,
'DOLLARS', p_quantity * p_list_price,
0 ) )
AND NVL( OEPBL.PRICE_BREAK_LINES_HIGH_RANGE (+),
DECODE( OEPBL.METHOD_TYPE_CODE (+),
'UNITS', p_quantity,
'DOLLARS', p_quantity * p_list_price,
0 ) )
AND NVL(OEPBL.UNIT_CODE(+),NVL(p_unit_code,'NULL'))=
NVL(p_unit_code,'NULL')
AND NVL( OEDIS.AMOUNT / p_list_price * 100,
NVL( OEDIS.PERCENT,
NVL( ( p_list_price - OEDLN.PRICE ) / p_list_price * 100,
NVL( OEDLN.AMOUNT / p_list_price * 100,
NVL( OEDLN.PERCENT,
NVL( ( p_list_price - OEPBL.PRICE ) / p_list_price * 100,
NVL( OEPBL.AMOUNT / p_list_price * 100,
NVL( OEPBL.PERCENT , 0 ) ) ) ) ) ) ) ) > p_best_adj_percent
AND ( NOT EXISTS (SELECT NULL
FROM OE_DISCOUNT_CUSTOMERS OECST
WHERE OECST.DISCOUNT_ID = OEDIS.DISCOUNT_ID )
OR EXISTS (SELECT NULL
FROM OE_DISCOUNT_CUSTOMERS OECST
WHERE OECST.DISCOUNT_ID = OEDIS.DISCOUNT_ID
AND NVL( OECST.sold_to_org_id, p_sold_to_org_id ) =
p_sold_to_org_id
AND NVL( OECST.CUSTOMER_CLASS_CODE,
NVL ( p_customer_class_code, 'NULL'
) )=
NVL ( p_customer_class_code , 'NULL' )
AND ( NVL( OECST.site_org_id, p_ship_to_id) =
p_ship_to_id
OR
NVL( OECST.site_org_id, p_invoice_to_id)
= p_invoice_to_id )
AND TRUNC(L_PRICING_DATE)
BETWEEN NVL( OECST.START_DATE_ACTIVE,
TRUNC(L_PRICING_DATE))
AND NVL( OECST.END_DATE_ACTIVE,
TRUNC(L_PRICING_DATE))))
ORDER BY NVL( OEDIS.AMOUNT / p_list_price * 100,
NVL( OEDIS.PERCENT,
NVL( ( p_list_price - OEDLN.PRICE ) / p_list_price * 100,
NVL( OEDLN.AMOUNT / p_list_price * 100,
NVL( OEDLN.PERCENT,
NVL( ( p_list_price - OEPBL.PRICE ) / p_list_price * 100,
NVL( OEPBL.AMOUNT / p_list_price * 100,
NVL( OEPBL.PERCENT, 0 ) ) ) ) ) ) ) ) DESC;
SELECT GSA_INDICATOR
INTO l_GSA
FROM HZ_CUST_SITE_USES
WHERE SITE_USE_ID = p_invoice_to_id;
SELECT NVL( DECODE(party.PARTY_TYPE,'ORGANIZATION',party.GSA_INDICATOR_FLAG, 'N'),'N' )
INTO l_gsa
FROM HZ_CUST_ACCOUNTS cust_acct,HZ_PARTIES party
WHERE cust_acct.PARTY_ID = party.PARTY_ID and
cust_acct.CUST_ACCOUNT_ID = p_sold_to_org_id;
OE_DEBUG_PUB.ADD('|Befor calling header big select statement|');
OE_DEBUG_PUB.ADD('|After calling header big select statement|');
SELECT ROUNDING_FACTOR
INTO l_rounding_factor
FROM oe_price_lists
WHERE price_list_id = p_price_list_id;
SELECT ROUNDING_FACTOR
INTO l_rounding_factor
FROM QP_LIST_HEADERS
WHERE LIST_HEADER_ID = p_price_list_id;
-- adjustments, but since we don't do actual inserts the
-- code will temporarily reside here.
if l_item_rec.agreement_id is null then
FND_MESSAGE.SET_NAME('QP','OE_PRC_AUTOADJUSTMENT_APPLIED');