APPS.IEM_MGINBOX_PUB dependencies on IEM_RT_INTERACTIONS

Line 122: from iem_rt_media_items rtm, iem_rt_interactions rti

118: rtm.agent_account_id, rtm.resource_id, rtm.folder_name,
119: rtm.folder_uid
120: into l_rt_media_item_id, l_rt_interaction_id, l_agent_account_id,
121: l_resource_id, l_folder_name, l_msg_uid
122: from iem_rt_media_items rtm, iem_rt_interactions rti
123: where rtm.message_id = mdts.message_id and rtm.email_type ='I'
124: and rtm.rt_interaction_id = rti.rt_interaction_id
125: and rti.expire = 'N';
126: exception

Line 128: l_err_msg := substr('Error in query iem_rt_media_items and iem_rt_interactions'||SQLERRM, 1000);

124: and rtm.rt_interaction_id = rti.rt_interaction_id
125: and rti.expire = 'N';
126: exception
127: when others then
128: l_err_msg := substr('Error in query iem_rt_media_items and iem_rt_interactions'||SQLERRM, 1000);
129: end;
130: if (p_type = 'I') then
131: begin -- inbound message
132: begin

Line 234: from iem_rt_media_items rtm, iem_rt_interactions rti

230: rtm.agent_account_id, rtm.resource_id, rtm.folder_name,
231: rtm.folder_uid
232: into l_rt_media_item_id, l_rt_interaction_id, l_agent_account_id,
233: l_resource_id, l_folder_name, l_msg_uid
234: from iem_rt_media_items rtm, iem_rt_interactions rti
235: where rtm.message_id = mdts.message_id and rtm.email_type ='I'
236: and rtm.rt_interaction_id = rti.rt_interaction_id
237: and rti.expire = 'N';
238: exception

Line 240: l_err_msg := substr('Error in query iem_rt_media_items and iem_rt_interactions'||SQLERRM, 1000);

236: and rtm.rt_interaction_id = rti.rt_interaction_id
237: and rti.expire = 'N';
238: exception
239: when others then
240: l_err_msg := substr('Error in query iem_rt_media_items and iem_rt_interactions'||SQLERRM, 1000);
241: end;
242:
243: begin
244: select a.db_link into l_dblink