APPS.IEM_CLIENT_PUB dependencies on IEM_AGENTS

Line 1050: FROM IEM_AGENTS A

1046:
1047: begin
1048: SELECT A.EMAIL_ACCOUNT_ID
1049: INTO l_email_account_id_ih
1050: FROM IEM_AGENTS A
1051: WHERE A.agent_id = p_account_id;
1052:
1053: exception
1054: when others then

Line 2110: from iem_mstemail_accounts acct, iem_agents agnt

2106: from iem_mstemail_accounts
2107: where email_account_id = l_email_account_id;
2108: else
2109: select acct.account_type into l_acct_type
2110: from iem_mstemail_accounts acct, iem_agents agnt
2111: where agnt.agent_id = l_agent_account_id
2112: and agnt.email_account_id = acct.email_account_id;
2113: end if;
2114:

Line 2231: FROM IEM_AGENTS

2227:
2228: if (l_agent_account_id IS NOT NULL) then
2229: SELECT email_account_id
2230: INTO l_email_account_id
2231: FROM IEM_AGENTS
2232: WHERE agent_id = l_agent_account_id;
2233: end if;
2234:
2235: SELECT customer_id, resource_id, creation_date, nvl(spv_resource_id, -1)

Line 2804: select agent_id into l_tran_to_acct_id from iem_agents

2800: else
2801: l_tran_lead_id := -1;
2802: end if;
2803:
2804: select agent_id into l_tran_to_acct_id from iem_agents
2805: where resource_id = p_to_resource_id
2806: and email_account_id = l_email_account_id;
2807:
2808: select IEM_RT_INTERACTIONS_S1.nextval into l_i_sequence from DUAL;

Line 3237: FROM iem_agents

3233: l_data NUMBER;
3234:
3235: CURSOR del_status_csr IS
3236: SELECT agent_id
3237: FROM iem_agents
3238: WHERE email_account_id = p_account_id
3239: ORDER BY agent_id;
3240: BEGIN
3241:

Line 4766: from iem_agents where email_account_id = p_email_account_id

4762: x_is_clean := false;
4763:
4764: begin
4765: select agent_id into l_agent_account_id
4766: from iem_agents where email_account_id = p_email_account_id
4767: and resource_id = p_resource_id;
4768:
4769: exception
4770: when others then