APPS.QP_DEFAULT_PLL_PRICING_ATTR dependencies on QP_PRICING_ATTRIBUTES

Line 31: from qp_pricing_attributes

27: BEGIN
28:
29: select attribute_grouping_no
30: into l_attribute_grouping_no
31: from qp_pricing_attributes
32: where list_line_id = g_Pricing_Attr_rec.list_line_id
33: and rownum < 2;
34:
35: return l_attribute_grouping_no;

Line 111: select qp_pricing_attributes_s.nextval

107: IS
108: l_pricing_attribute_id number;
109: BEGIN
110:
111: select qp_pricing_attributes_s.nextval
112: into l_pricing_attribute_id
113: from dual;
114:
115: RETURN l_pricing_attribute_id;

Line 273: from qp_pricing_attributes

269: and g_Pricing_Attr_rec.from_rltd_modifier_id <> FND_API.G_MISS_NUM) THEN
270:
271: select product_attribute
272: into l_prod_attr
273: from qp_pricing_attributes
274: where list_line_id = g_Pricing_Attr_rec.from_rltd_modifier_id
275: and excluder_flag = 'N'
276: and rownum < 2;
277:

Line 285: from qp_pricing_attributes

281: and g_Pricing_Attr_rec.list_line_id <> FND_API.G_MISS_NUM) THEN
282:
283: select product_attribute
284: into l_prod_attr
285: from qp_pricing_attributes
286: where list_line_id = g_Pricing_Attr_rec.list_line_id
287: and excluder_flag = 'N'
288: and rownum < 2;
289:

Line 313: from qp_pricing_attributes

309: and g_Pricing_Attr_rec.from_rltd_modifier_id <> FND_API.G_MISS_NUM) THEN
310:
311: select product_attribute_context
312: into l_prod_attr_cont
313: from qp_pricing_attributes
314: where list_line_id = g_Pricing_Attr_rec.from_rltd_modifier_id
315: and excluder_flag = 'N'
316: and rownum < 2;
317:

Line 325: from qp_pricing_attributes

321: and g_Pricing_Attr_rec.list_line_id <> FND_API.G_MISS_NUM) THEN
322:
323: select product_attribute_context
324: into l_prod_attr_cont
325: from qp_pricing_attributes
326: where list_line_id = g_Pricing_Attr_rec.list_line_id
327: and excluder_flag = 'N'
328: and rownum < 2;
329:

Line 351: from qp_pricing_attributes

347: and g_Pricing_Attr_rec.from_rltd_modifier_id <> FND_API.G_MISS_NUM) THEN
348:
349: select product_attr_value
350: into l_prod_attr_value
351: from qp_pricing_attributes
352: where list_line_id = g_Pricing_Attr_rec.from_rltd_modifier_id
353: and excluder_flag = 'N'
354: and rownum < 2;
355:

Line 363: from qp_pricing_attributes

359: and g_Pricing_Attr_rec.list_line_id <> FND_API.G_MISS_NUM) THEN
360:
361: select product_attr_value
362: into l_prod_attr_value
363: from qp_pricing_attributes
364: where list_line_id = g_Pricing_Attr_rec.list_line_id
365: and excluder_flag = 'N'
366: and rownum < 2;
367:

Line 389: from qp_pricing_attributes

385: and g_Pricing_Attr_rec.from_rltd_modifier_id <> FND_API.G_MISS_NUM) THEN
386:
387: select product_uom_code
388: into l_prod_uom
389: from qp_pricing_attributes
390: where list_line_id = g_Pricing_Attr_rec.from_rltd_modifier_id
391: and excluder_flag = 'N'
392: and rownum < 2;
393:

Line 401: from qp_pricing_attributes

397: and g_Pricing_Attr_rec.list_line_id <> FND_API.G_MISS_NUM) THEN
398:
399: select product_uom_code
400: into l_prod_uom
401: from qp_pricing_attributes
402: where list_line_id = g_Pricing_Attr_rec.list_line_id
403: and excluder_flag = 'N'
404: and rownum < 2;
405: