DBA Data[Home] [Help]

APPS.GMF_GET_TRANSFER_PRICE_PUB dependencies on QP_PREQ_LINES_TMP

Line 1581: FROM qp_preq_lines_tmp;

1577: END IF;
1578:
1579: SELECT count(*)
1580: INTO i
1581: FROM qp_preq_lines_tmp;
1582:
1583: IF (l_debug = 1) THEN
1584: print_debug('GMF_get_transfer_price_PUB.Populate_Temp_Table: No. of records inserted in QP_PREQ_LINES_TMP=' || to_char(i));
1585: END IF;

Line 1584: print_debug('GMF_get_transfer_price_PUB.Populate_Temp_Table: No. of records inserted in QP_PREQ_LINES_TMP=' || to_char(i));

1580: INTO i
1581: FROM qp_preq_lines_tmp;
1582:
1583: IF (l_debug = 1) THEN
1584: print_debug('GMF_get_transfer_price_PUB.Populate_Temp_Table: No. of records inserted in QP_PREQ_LINES_TMP=' || to_char(i));
1585: END IF;
1586:
1587: EXCEPTION
1588: WHEN FND_API.G_EXC_ERROR THEN

Line 1639: FROM qp_preq_lines_tmp lines

1635: , G_UNIT_SELLING_PERCENT_TBL(i)
1636: , G_CURRENCY_CODE_TBL(i)
1637: , G_PRICING_STATUS_CODE_TBL(i)
1638: , G_PRICING_STATUS_TEXT_TBL(i)
1639: FROM qp_preq_lines_tmp lines
1640: WHERE lines.line_id=G_LINE_ID_TBL(i);
1641:
1642: EXCEPTION
1643: WHEN NO_DATA_FOUND THEN