APPS.EGO_ITEM_ASSOCIATIONS_UTIL dependencies on EGO_MASSUPDATE_S

Line 195: SELECT ego_massupdate_s.NEXTVAL

191: -- dbms_output.put_line(' Deleting rows');
192: -- EXECUTE IMMEDIATE 'DELETE FROM ego_suppliersite_tmp WHERE batch_id = :b_batch_id' USING p_batch_id;
193: -- else create one batch_id here. This is only for temp tables..so get it from massupdate seq.
194: -- ELSE
195: SELECT ego_massupdate_s.NEXTVAL
196: INTO p_batch_id
197: FROM dual;
198: END IF;
199: -- construct the search result query dynamically