APPS.IEM_OP_ADMIN_PUB dependencies on IEM_RT_PROC_EMAILS

Line 591: from iem_rt_proc_emails where message_id = v_mdt_msg_id;

587: begin
588: no_post_mdts := 0;
589: select email_account_id, subject, from_address
590: into v_master_acct_id, v_subject, v_sender
591: from iem_rt_proc_emails where message_id = v_mdt_msg_id;
592:
593: select from_name into v_master_acct_name from iem_mstemail_accounts
594: where email_account_id = v_master_acct_id;
595: end;

Line 957: update iem_rt_proc_emails set queue_status = null

953: update iem_rt_interactions set expire = G_ACTIVE
954: where rt_interaction_id = l_rt_interaction_id;
955:
956: if ( l_message_id > 0 ) then
957: update iem_rt_proc_emails set queue_status = null
958: where message_id = l_message_id;
959: end if;
960:
961: update iem_outbox_errors set expire = G_EXPIRE