DBA Data[Home] [Help]

APPS.CCT_SRSEC_CHECK_PUB dependencies on CCT_AGENT_RT_STATS

Line 25: SELECT agent_id, resp_id, app_id FROM cct_agent_rt_stats

21: --c cur_typ;
22: --query_str VARCHAR2(32767);
23:
24: CURSOR l_agents_csr IS
25: SELECT agent_id, resp_id, app_id FROM cct_agent_rt_stats
26: WHERE agent_id IN (p_agentIDs) AND attribute1 = 'T';
27:
28: BEGIN
29: x_return_status := FND_API.G_FALSE;

Line 45: --query_str := 'SELECT agent_id, resp_id, app_id FROM cct_agent_rt_stats

41: i := p_table.FIRST;
42: --tbd : change "F" to "T" as that's what we want here..
43: -- If p_isServerGroupID is true, then p_agentIDs represents "Super Server Group ID".
44: -- p_agentIDs := '('||p_agentIDs||')'; Bug 4283551 - do not use literal in sql. replaced with cursor
45: --query_str := 'SELECT agent_id, resp_id, app_id FROM cct_agent_rt_stats
46: -- WHERE agent_id IN'||p_agentIDs ||' AND attribute1 = ''T'' ';
47: --p_agentIDs := '';
48:
49: