APPS.IEM_MIGRATION_PVT dependencies on IEM_AGENTS

Line 1524: (select agent_id from iem_agents);

1520: l_val number;
1521: cursor c_account is select * from iem_email_accounts where email_account_id not in
1522: (select email_account_id from iem_mstemail_accounts);
1523: cursor c_agent is select * from iem_agent_Accounts where agent_account_id not in
1524: (select agent_id from iem_agents);
1525: cursor c_intent is
1526: select distinct a.classification_id,a.classification from
1527: iem_classifications a
1528: where a.email_account_id=l_email_account_id;

Line 1769: insert into IEM_AGENTS

1765: END LOOP; -- End Loop for INTENT DETAILS
1766: END LOOP; -- End Loop For INTENT
1767: END LOOP; -- Edn Loop For Account
1768: for v4 in c_agent LOOP
1769: insert into IEM_AGENTS
1770: (AGENT_ID,
1771: email_account_id,
1772: RESOURCE_ID,
1773: signature,

Line 1804: select nvl(max(agent_id),0) into l_max_id from iem_agents;

1800: END LOOP;
1801:
1802: -- Reset the Sequence to have highest agent id
1803:
1804: select nvl(max(agent_id),0) into l_max_id from iem_agents;
1805: LOOP
1806: select iem_agents_s1.nextval into l_val from dual;
1807: exit when l_val>l_max_id;
1808: END LOOP;

Line 1806: select iem_agents_s1.nextval into l_val from dual;

1802: -- Reset the Sequence to have highest agent id
1803:
1804: select nvl(max(agent_id),0) into l_max_id from iem_agents;
1805: LOOP
1806: select iem_agents_s1.nextval into l_val from dual;
1807: exit when l_val>l_max_id;
1808: END LOOP;
1809:
1810: -- Reset the Sequence to have highest intent id