APPS.QP_PRICE_BOOK_PVT dependencies on QP_PREQ_LINES_TMP

Line 455: FROM qp_preq_lines_tmp

451: IS
452: SELECT line_index, line_unit_price list_price,
453: order_uom_selling_price net_price, line_id,
454: pricing_status_code, pricing_status_text
455: FROM qp_preq_lines_tmp
456: ORDER BY line_index;
457:
458: l_cf_list_header_id_tbl NUMBER_TYPE;
459: l_cf_list_line_id_tbl NUMBER_TYPE;

Line 483: FROM qp_preq_ldets_tmp a, qp_preq_lines_tmp b

479: a.order_qty_adj_amt adjustment_amount,
480: a.created_from_list_line_type, a.pricing_phase_id,
481: a.price_break_type_code, a.line_index, a.line_detail_index,
482: b.line_id
483: FROM qp_preq_ldets_tmp a, qp_preq_lines_tmp b
484: WHERE a.line_index = b.line_index
485: AND a.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
486: AND a.line_detail_type_code = 'NULL' --not a child line
487: AND a.applied_flag = 'Y' --automatic and applied discounts

Line 554: --Insert records in qp_preq_lines_tmp

550: -- all such sets get priced.
551:
552: -- qp_price_request_context.set_request_id;
553:
554: --Insert records in qp_preq_lines_tmp
555: OPEN insert_lines2_cur(p_price_book_header_id,
556: p_pb_input_header_rec.effective_date,
557: p_pb_input_header_rec.item_quantity,
558: p_pb_input_header_rec.request_type_code,