APPS.IEM_MIGRATION_PVT dependencies on IEM_AGENT_ACCOUNTS

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

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

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

1335: l_max_id number;
1336: l_val number;
1337: cursor c_account is select * from iem_email_accounts where email_account_id not in
1338: (select email_account_id from iem_mstemail_accounts);
1339: cursor c_agent is select * from iem_agent_Accounts where agent_account_id not in
1340: (select agent_id from iem_agents);
1341: cursor c_intent is
1342: select distinct a.classification_id,a.classification from
1343: iem_classifications a