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 1143: FROM dual;

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

Line 1351: FROM dual;

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

Line 1510: FROM dual;

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