APPS.QP_PLL_PRICING_ATTR_UTIL dependencies on QP_LIST_LINES

Line 457: FROM qp_list_lines

453:
454: BEGIN
455: SELECT list_header_id
456: INTO l_list_header_id
457: FROM qp_list_lines
458: WHERE list_line_id = p_PRICING_ATTR_rec.list_line_id;
459:
460: EXCEPTION
461: WHEN OTHERS THEN

Line 674: from qp_list_lines ql, qp_rltd_modifiers qrm

670: SET product_uom_code = p_PRICING_ATTR_rec.product_uom_code
671: where list_line_id in
672: (
673: select to_rltd_modifier_id
674: from qp_list_lines ql, qp_rltd_modifiers qrm
675: where from_rltd_modifier_id= p_PRICING_ATTR_rec.list_line_id
676: AND qrm.to_rltd_modifier_id = ql.list_line_id
677: AND qrm.rltd_modifier_grp_type = 'PRICE BREAK'
678: ) ;

Line 1434: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_PRICING_ATTR_rec.list_line_id)

1430: , l_pric_attr_value_to_number
1431: , p_PRICING_ATTR_rec.qualification_ind --euro bug 2138996
1432: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1433: ,to_char(p_PRICING_ATTR_rec.pricing_attribute_id)
1434: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_PRICING_ATTR_rec.list_line_id)
1435: ,(select h.ORIG_SYSTEM_HEADER_REF from QP_LIST_HEADERS_ALL_B h where h.list_header_id=p_PRICING_ATTR_rec.list_header_id)
1436: );
1437:
1438: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');