APPS.GME_MOVE_ORDERS_PVT dependencies on DUAL

Line 244: l_in_trolin_tbl (l_count).carton_grouping_id from dual;

240: CLOSE cur_wms_enabled;
241:
242: IF NVL(l_wms_enabled_flag,'N') = 'Y' THEN
243: select WSH_DELIVERY_GROUP_S.nextval into
244: l_in_trolin_tbl (l_count).carton_grouping_id from dual;
245: END IF;
246:
247: END IF;
248: IF (l_sec_uom_code IS NOT NULL) THEN

Line 1153: -- Namit S. Bug4917629 Modified query to not select from sysdual.

1149: l_api_name CONSTANT VARCHAR2 (30) := 'pending_move_orders_exist';
1150: l_exists BOOLEAN := FALSE;
1151: l_dummy NUMBER;
1152:
1153: -- Namit S. Bug4917629 Modified query to not select from sysdual.
1154: -- This is for perf reasons to reduce the sharable memory.
1155:
1156: CURSOR cur_move_order_lines
1157: IS