APPS.QP_COPY_MODIFIERS_PVT dependencies on DUAL

Line 412: FROM dual;

408: --Select next discount_header_id
409:
410: SELECT qp_list_headers_b_s.nextval
411: INTO l_new_discount_header_id
412: FROM dual;
413:
414: --Discount Header Information
415:
416: --if fnd_profile.value('QP_ATTRIBUTE_MANAGER_INSTALLED') = 'Y' then

Line 733: FROM dual;

729:
730: --Get new qualifier_id
731: SELECT qp_qualifiers_s.nextval
732: INTO l_new_qualifier_id
733: FROM dual;
734:
735: /*
736: IF l_qp_qualifiers_rec.qualifier_attr_value =
737: TO_CHAR(p_from_list_header_id) AND

Line 940: FROM dual;

936:
937: --Get New Discount Line Id
938: SELECT qp_list_lines_s.nextval
939: INTO l_new_discount_line_id
940: FROM dual;
941:
942: --Insert Discount Line
943: INSERT INTO qp_list_lines
944: (

Line 1144: FROM dual;

1140:
1141: --Get new qualifier_id
1142: SELECT qp_qualifiers_s.nextval
1143: INTO l_new_qualifier_id
1144: FROM dual;
1145:
1146: /*
1147: IF l_qp_line_qualifiers_rec.qualifier_attr_value =
1148: TO_CHAR(p_from_list_header_id) AND

Line 1352: FROM dual;

1348:
1349: -- Get next pricing_attribute_id
1350: SELECT qp_pricing_attributes_s.nextval
1351: INTO l_new_pricing_attribute_id
1352: FROM dual;
1353:
1354: IF l_qp_discount_lines_rec.list_line_type_code = 'PBH' AND
1355: (l_qp_discount_lines_rec.continuous_price_break_flag IS NULL OR l_qp_discount_lines_rec.continuous_price_break_flag <> 'Y')
1356: AND l_qp_pricing_attributes_rec.list_line_id = l_qp_discount_lines_rec.list_line_id

Line 1511: FROM dual;

1507: LOOP
1508:
1509: SELECT qp_rltd_modifiers_s.nextval
1510: INTO l_new_rltd_modifier_id
1511: FROM dual;
1512:
1513: l_new_from_id := Get_New_Id(
1514: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,
1515: l_mapping_tbl);