APPS.ASO_VALIDATE_PVT dependencies on ASO_PRICE_ATTRIBUTES

Line 4431: FROM aso_price_attributes

4427: p_quote_line_id NUMBER,
4428: p_pricing_attribute1 VARCHAR2,
4429: p_pricing_attribute2 VARCHAR2 ) IS
4430: SELECT price_attribute_id
4431: FROM aso_price_attributes
4432: WHERE quote_header_id = p_quote_header_id
4433: AND nvl(quote_line_id,0) = nvl(decode(p_quote_line_id,FND_API.G_MISS_NUM,null,p_quote_line_id),0)
4434: AND nvl(pricing_attribute1,'X') = nvl(p_pricing_attribute1,'X')
4435: AND nvl(pricing_attribute2,'Y') = nvl(p_pricing_attribute2,'Y');

Line 4441: FROM aso_price_attributes

4437: Cursor C_get_attr1(p_quote_header_id NUMBER,
4438: p_quote_line_id NUMBER,
4439: p_list_line_id NUMBER) IS
4440: SELECT price_attribute_id
4441: FROM aso_price_attributes
4442: WHERE quote_header_id = p_quote_header_id
4443: AND nvl(quote_line_id,0) = nvl(decode(p_quote_line_id,FND_API.G_MISS_NUM,null,p_quote_line_id),0)
4444: AND pricing_attribute1 IN ( SELECT to_char(qpe.list_header_id)
4445: FROM qp_list_lines qpe

Line 4453: FROM aso_price_attributes

4449: p_quote_line_id NUMBER,
4450: p_list_header_id NUMBER,
4451: p_pricing_attribute2 VARCHAR2) IS
4452: SELECT price_attribute_id
4453: FROM aso_price_attributes
4454: WHERE quote_header_id = p_quote_header_id
4455: AND nvl(quote_line_id,0) = nvl(decode(p_quote_line_id,FND_API.G_MISS_NUM,null,p_quote_line_id),0)
4456: AND (
4457: ( nvl(pricing_attribute2,'X') = nvl(p_pricing_attribute2,'X') AND