APPS.QP_CALCULATE_PRICE_PUB dependencies on QP_NPREQ_LINES_TMP

Line 1626: FROM qp_npreq_lines_tmp

1622: IF QP_PREQ_GRP.G_ORDER_ID IS NULL THEN
1623: BEGIN
1624: SELECT line_id
1625: INTO QP_PREQ_GRP.G_ORDER_ID
1626: FROM qp_npreq_lines_tmp
1627: WHERE line_type_code = QP_PREQ_GRP.G_ORDER_LEVEL;
1628: EXCEPTION
1629: WHEN NO_DATA_FOUND THEN
1630: IF l_debug = FND_API.G_TRUE THEN

Line 1655: FROM qp_npreq_lines_tmp lines

1651: QP_PREQ_GRP.engine_debug(' - line_index ('|| l_line_index ||'), prev_line_index ('|| l_prev_line_index || ')');
1652: END IF;
1653: SELECT lines.line_id, lines.pricing_effective_date
1654: INTO v_line_id, v_price_eff_date
1655: FROM qp_npreq_lines_tmp lines
1656: WHERE lines.line_index = l_line_index;
1657:
1658: QP_PREQ_GRP.G_LINE_ID := v_line_id;
1659: QP_PREQ_GRP.G_PRICE_EFF_DATE := v_price_eff_date;

Line 1806: FROM qp_npreq_rltd_lines_tmp rltd, qp_npreq_lines_tmp line

1802: , line.line_quantity ordered_qty
1803: , line.priced_quantity priced_qty
1804: , line.catchweight_qty catchweight_qty
1805: , line.actual_order_quantity actual_order_qty
1806: FROM qp_npreq_rltd_lines_tmp rltd, qp_npreq_lines_tmp line
1807: WHERE rltd.list_line_id = p_list_line_id
1808: AND rltd.line_index = p_line_index
1809: AND line.line_index = p_line_index
1810: AND rltd.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

Line 1828: FROM qp_npreq_rltd_lines_tmp rltd, qp_npreq_lines_tmp line

1824: , line.line_quantity ordered_qty
1825: , line.priced_quantity priced_qty
1826: , line.catchweight_qty catchweight_qty
1827: , line.actual_order_quantity actual_order_qty
1828: FROM qp_npreq_rltd_lines_tmp rltd, qp_npreq_lines_tmp line
1829: WHERE QP_PREQ_GRP.G_PUBLIC_API_CALL_FLAG = QP_PREQ_GRP.G_YES
1830: AND rltd.line_index = p_line_index
1831: AND line_detail_index = p_list_line_id
1832: AND line.line_index = p_line_index