APPS.GMI_UPDATE_ORDER dependencies on DUAL

Line 140: select RCV_INTERFACE_GROUPS_S.NEXTVAL INTO l_group_id FROM DUAL;

136: l_if_internal := 1; -- internal order
137: gmi_reservation_util.println('It is an internal Order');
138: IF nvl(l_group_id,0) = 0 THEN
139: /* only do this once */
140: select RCV_INTERFACE_GROUPS_S.NEXTVAL INTO l_group_id FROM DUAL;
141: END IF;
142: gmi_reservation_util.println('Going to open c_details_for_interface and value of l_detail_in_delivery.delivery_detail_id is '||l_detail_in_delivery.delivery_detail_id);
143: OPEN c_details_for_interface(l_detail_in_delivery.delivery_detail_id);
144: FETCH c_details_for_interface into l_detail_rec;