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 2205: FROM IEM_AGENTS

2201:
2202: if (l_agent_account_id IS NOT NULL) then
2203: SELECT email_account_id
2204: INTO l_email_account_id
2205: FROM IEM_AGENTS
2206: WHERE agent_id = l_agent_account_id;
2207: end if;
2208:
2209: SELECT customer_id, resource_id, creation_date, nvl(spv_resource_id, -1)

Line 2742: select agent_id into l_tran_to_acct_id from iem_agents

2738: else
2739: l_tran_lead_id := -1;
2740: end if;
2741:
2742: select agent_id into l_tran_to_acct_id from iem_agents
2743: where resource_id = p_to_resource_id
2744: and email_account_id = l_email_account_id;
2745:
2746: select IEM_RT_INTERACTIONS_S1.nextval into l_i_sequence from DUAL;

Line 3175: FROM iem_agents

3171: l_data NUMBER;
3172:
3173: CURSOR del_status_csr IS
3174: SELECT agent_id
3175: FROM iem_agents
3176: WHERE email_account_id = p_account_id
3177: ORDER BY agent_id;
3178: BEGIN
3179:

Line 4691: from iem_agents where email_account_id = p_email_account_id

4687: x_is_clean := false;
4688:
4689: begin
4690: select agent_id into l_agent_account_id
4691: from iem_agents where email_account_id = p_email_account_id
4692: and resource_id = p_resource_id;
4693:
4694: exception
4695: when others then