18: and application_id = l_application_id
19: GROUP BY resource_id HAVING count(resource_id) > 1;
20:
21: -- SELECT resource_id
22: --FROM JTF_RS_RESOURCE_EXTNS j, FND_USER f
23: --where j.user_id = f.user_id;
24:
25: --Select all the sessions corresponding to a particular resource_id
26: --which are open by UWQ
334: l_upper_agent := upper(p_agent_name);
335:
336:
337: select resource_id into l_agent_resource_id
338: FROM JTF_RS_RESOURCE_EXTNS
339: where user_name=l_upper_agent;
340:
341:
342: EXCEPTION