APPS.IEM_OP_ADMIN_PUB dependencies on IEM_MSTEMAIL_ACCOUNTS

Line 593: select from_name into v_master_acct_name from iem_mstemail_accounts

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;
596: end if; -- mdt_msg_id > 0
597:

Line 611: select from_name into v_master_acct_name from iem_mstemail_accounts

607: into l_email_acct_id, l_agent_acct_id
608: from iem_rt_media_items where rt_media_item_id = l_rt_media_item_id;
609:
610: if (l_email_acct_id > 0) then
611: select from_name into v_master_acct_name from iem_mstemail_accounts
612: where email_account_id = l_email_acct_id;
613: v_master_acct_id := l_email_acct_id;
614:
615: elsif ( l_agent_acct_id > 0) then

Line 618: from iem_mstemail_accounts a, iem_agents b

614:
615: elsif ( l_agent_acct_id > 0) then
616: select a.from_name, a.email_account_id
617: into v_master_acct_name, v_master_acct_id
618: from iem_mstemail_accounts a, iem_agents b
619: where a.email_account_id = b.email_account_id
620: and b.agent_id = l_agent_acct_id;
621: end if;
622: