APPS.EGO_MASS_UPDATE_PVT dependencies on DUAL

Line 68: FROM dual;

64: -- Can we avoid this select and directly use the seq val
65: -- Using currval in the insert may perhaps give diff values if nextval is used elsewhere?
66: SELECT mtl_system_items_intf_sets_s.NEXTVAL
67: INTO l_set_process_id
68: FROM dual;
69:
70: Write_Debug('In Item Org Assignment API');
71:
72: -- Commented for Bug 5464843

Line 187: FROM dual;

183: -- because for each row the sequence value is being incremented
184:
185: /* SELECT mtl_system_items_intf_sets_s.NEXTVAL
186: INTO l_batch_set_process_id
187: FROM dual;
188:
189: UPDATE mtl_system_items_interface
190: SET set_process_id = l_batch_set_process_id
191: WHERE set_process_id = l_set_process_id