APPS.IEM_MIGRATION_PVT dependencies on IEM_AGENTS_S1
Line 1622: select iem_agents_s1.nextval into l_val from dual;
1618: -- Reset the Sequence to have highest agent id
1619:
1620: select nvl(max(agent_id),0) into l_max_id from iem_agents;
1621: LOOP 1622: select iem_agents_s1.nextval into l_val from dual; 1623: exit when l_val>l_max_id;
1624: END LOOP;
1625:
1626: -- Reset the Sequence to have highest intent id