APPS.ASO_CHK_PRICING_ATTR_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 25

 SELECT distinct l.list_line_id
 FROM  qp_list_lines l, qp_pricing_attributes a
 WHERE l.list_line_id = a.list_line_id
 AND l.list_header_id = P_Price_List_Id
 AND   l.list_line_type_code = 'PLL'
 AND   a.product_attribute_context = 'ITEM'
 AND   a.product_attribute = 'PRICING_ATTRIBUTE1'
 AND   a.product_attr_value = P_Inventory_Id
 AND   (price_by_formula_id  IN (SELECT price_formula_id
						  FROM qp_price_formulas_b
						  WHERE EXISTS (SELECT 'x'
									 FROM  qp_price_formula_lines fl, qp_price_formulas_b b
								      WHERE fl.price_formula_line_type_code = 'PRA'
									 AND   fl.price_formula_id = b.price_formula_id)
						  )
 	  OR (a.pricing_attribute_context IS NOT NULL
	   AND  a.pricing_attribute IS NOT NULL )
	  );

Line: 45

SELECT count(rowid) r_count
FROM aso_price_attributes
WHERE quote_line_id = P_Quote_Line_Id;