APPS.QP_CALCULATE_PRICE_PUB dependencies on QP_NPREQ_LINES_TMP

Line 1634: FROM qp_npreq_lines_tmp

1630: IF QP_PREQ_GRP.G_ORDER_ID IS NULL THEN
1631: BEGIN
1632: SELECT line_id
1633: INTO QP_PREQ_GRP.G_ORDER_ID
1634: FROM qp_npreq_lines_tmp
1635: WHERE line_type_code = QP_PREQ_GRP.G_ORDER_LEVEL;
1636: EXCEPTION
1637: WHEN NO_DATA_FOUND THEN
1638: IF l_debug = FND_API.G_TRUE THEN

Line 1663: FROM qp_npreq_lines_tmp lines

1659: QP_PREQ_GRP.engine_debug(' - line_index ('|| l_line_index ||'), prev_line_index ('|| l_prev_line_index || ')');
1660: END IF;
1661: SELECT lines.line_id, lines.pricing_effective_date
1662: INTO v_line_id, v_price_eff_date
1663: FROM qp_npreq_lines_tmp lines
1664: WHERE lines.line_index = l_line_index;
1665:
1666: QP_PREQ_GRP.G_LINE_ID := v_line_id;
1667: QP_PREQ_GRP.G_PRICE_EFF_DATE := v_price_eff_date;

Line 1834: FROM qp_npreq_rltd_lines_tmp rltd, qp_npreq_lines_tmp line

1830: , line.priced_quantity priced_qty
1831: , line.catchweight_qty catchweight_qty
1832: , line.actual_order_quantity actual_order_qty
1833: , line.PRICE_REQUEST_CODE PRICE_REQUEST_CODE --bug#12916970
1834: FROM qp_npreq_rltd_lines_tmp rltd, qp_npreq_lines_tmp line
1835: WHERE rltd.list_line_id = p_list_line_id
1836: AND rltd.line_index = p_line_index
1837: AND line.line_index = p_line_index
1838: AND rltd.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

Line 1857: FROM qp_npreq_rltd_lines_tmp rltd, qp_npreq_lines_tmp line

1853: , line.priced_quantity priced_qty
1854: , line.catchweight_qty catchweight_qty
1855: , line.actual_order_quantity actual_order_qty
1856: , line.PRICE_REQUEST_CODE PRICE_REQUEST_CODE -- bug#12916970
1857: FROM qp_npreq_rltd_lines_tmp rltd, qp_npreq_lines_tmp line
1858: WHERE QP_PREQ_GRP.G_PUBLIC_API_CALL_FLAG = QP_PREQ_GRP.G_YES
1859: AND rltd.line_index = p_line_index
1860: AND line_detail_index = p_list_line_id
1861: AND line.line_index = p_line_index