APPS.PO_PRICE_ADJUSTMENTS_PKG dependencies on QP_PREQ_RLTD_LINES_TMP

Line 1319: DELETE FROM QP_PREQ_RLTD_LINES_TMP_TEST;

1315: END IF;
1316: END LOOP;
1317: /*
1318: IF p_order_header_id = 81699 THEN
1319: DELETE FROM QP_PREQ_RLTD_LINES_TMP_TEST;
1320: DELETE FROM QP_PREQ_LINE_ATTRS_TMP_TEST;
1321: DELETE FROM QP_PREQ_LINES_TMP_TEST;
1322: DELETE FROM QP_PREQ_LDETS_TMP_TEST;
1323:

Line 1324: INSERT INTO QP_PREQ_RLTD_LINES_TMP_TEST (select * from QP_PREQ_RLTD_LINES_TMP);

1320: DELETE FROM QP_PREQ_LINE_ATTRS_TMP_TEST;
1321: DELETE FROM QP_PREQ_LINES_TMP_TEST;
1322: DELETE FROM QP_PREQ_LDETS_TMP_TEST;
1323:
1324: INSERT INTO QP_PREQ_RLTD_LINES_TMP_TEST (select * from QP_PREQ_RLTD_LINES_TMP);
1325: INSERT INTO QP_PREQ_LINE_ATTRS_TMP_TEST (select * from QP_PREQ_LINE_ATTRS_TMP);
1326: INSERT INTO QP_PREQ_LINES_TMP_TEST (select * from QP_PREQ_LINES_TMP);
1327: INSERT INTO QP_PREQ_LDETS_TMP_TEST (select * from QP_PREQ_LDETS_TMP);
1328: END IF;

Line 2085: FROM QP_PREQ_RLTD_LINES_TMP RLTD

2081: SELECT ADJ.price_adjustment_id
2082: , RADJ.price_adjustment_id
2083: BULK COLLECT INTO l_price_adjustment_id_tbl
2084: ,l_rltd_price_adj_id_tbl
2085: FROM QP_PREQ_RLTD_LINES_TMP RLTD
2086: , QP_PREQ_LINES_TMP QPL
2087: , PO_PRICE_ADJUSTMENTS_DRAFT ADJ
2088: , PO_PRICE_ADJUSTMENTS_DRAFT RADJ
2089: WHERE QPL.LINE_INDEX = RLTD.LINE_INDEX