APPS.IEM_OP_ADMIN_PUB dependencies on IEM_AGENTS

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:

Line 633: select email_account_id into v_to_master_acct_id from iem_agents

629: where media_id = v_media_id and rt_media_item_id <> p_rt_media_item_id
630: and expire <> G_EXPIRE
631: and rownum < 2;
632:
633: select email_account_id into v_to_master_acct_id from iem_agents
634: where agent_id = l_agent_acct_id;
635: end if;
636:
637: if ( l_ih_status = 'X' ) then