APPS.IEM_MIGRATION_PVT dependencies on IEM_AGENT_ACCOUNTS

Line 51: cursor c_agent is select agent_account_id,resource_id from iem_agent_accounts

47: l_msg_table iem_im_wrappers_pvt.msg_table;
48: l_status varchar2(1);
49: l_status_text varchar2(1000);
50: l_ack_flag number:=0;
51: cursor c_agent is select agent_account_id,resource_id from iem_agent_accounts
52: where email_account_id= l_email_account_id;
53: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
54: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
55: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;

Line 1523: cursor c_agent is select * from iem_agent_Accounts where agent_account_id not in

1519: l_max_id number;
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