DBA Data[Home] [Help]

APPS.IEM_TAGPROCESS_PUB dependencies on IEM_AGENTS

Line 27: -- To look into IEM_AGENTS instead of IEM_AGENT_ACCOUNTS.

23: -- Liang Xia 06/02/2005 Fixed GSCC sql.46 according to bug 4289628
24: -- PKESANI 05/20/2006 For Bug 5195496, change the SQL to look for responsibility_key
25: -- instead of responsibility_id.
26: -- PKESANI 06/27/2006 For Bug 5143181, changed the SQL in isValidAgent Function,
27: -- To look into IEM_AGENTS instead of IEM_AGENT_ACCOUNTS.
28: -- --------- ------ -----------------------------------------
29:
30: -- Enter procedure, function bodies as shown below
31:

Line 1000: select count(*) into l_asso_count from iem_agents where resource_id=p_agent_id and email_account_id=p_email_acct_id;

996: l_grp_count number;
997: l_user_resp number;
998:
999: begin
1000: select count(*) into l_asso_count from iem_agents where resource_id=p_agent_id and email_account_id=p_email_acct_id;
1001: if l_asso_count < 1 then
1002: return false;
1003: end if;
1004: