DBA Data[Home] [Help]

APPS.PV_ORDER_MGMT_PVT dependencies on DUAL

Line 273: select 1 from dual where exists

269: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
270: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
271:
272: CURSOR validate_price (cv_order_header_id JTF_NUMBER_TABLE) IS
273: select 1 from dual where exists
274: (select /*+ CARDINALITY(t 10) */ 1
275: from oe_order_lines_all,(SELECT * FROM TABLE (CAST(cv_order_header_id AS JTF_NUMBER_TABLE))) t
276: where header_id = t.column_value
277: and (unit_list_price is null or