APPS.IEM_SPV_MONITORING_PVT dependencies on FND_USER_RESP_GROUPS

Line 270: bulk collect into l_resource_id_tbl, l_resource_name_tbl from fnd_user_resp_groups respgrp,

266:
267: if p_resource_role = 0 then -- All Agents
268: if (p_resource_name is not null) then
269: select unique res.resource_id,concat(concat(res.source_last_name, ', '), res.source_first_name) as resource_name
270: bulk collect into l_resource_id_tbl, l_resource_name_tbl from fnd_user_resp_groups respgrp,
271: jtf_rs_resource_extns res, fnd_responsibility resp where res.user_id=respgrp.user_id
272: and respgrp.responsibility_id=resp.responsibility_id and resp.application_id=680
273: and (resp.responsibility_key = 'EMAIL_CENTER_SUPERVISOR' or resp.responsibility_key = 'IEM_SA_AGENT')
274: and res.resource_id in ( select unique rel.role_resource_id from jtf_rs_role_relations rel where

Line 286: bulk collect into l_resource_id_tbl, l_resource_name_tbl from fnd_user_resp_groups respgrp,

282: or upper(res.user_name) like upper(p_resource_name))
283: order by resource_name;
284: else
285: select unique res.resource_id,concat(concat(res.source_last_name, ', '), res.source_first_name) as resource_name
286: bulk collect into l_resource_id_tbl, l_resource_name_tbl from fnd_user_resp_groups respgrp,
287: jtf_rs_resource_extns res, fnd_responsibility resp where res.user_id=respgrp.user_id
288: and respgrp.responsibility_id=resp.responsibility_id and resp.application_id=680
289: and (resp.responsibility_key = 'EMAIL_CENTER_SUPERVISOR' or resp.responsibility_key = 'IEM_SA_AGENT')
290: and res.resource_id in ( select unique rel.role_resource_id from jtf_rs_role_relations rel where

Line 314: bulk collect into l_resource_id_tbl, l_resource_name_tbl from fnd_user_resp_groups respgrp,

310: end if;
311:
312: if (p_resource_name is not null) then
313: select res.resource_id,concat(concat(res.source_last_name, ', '), res.source_first_name) as resource_name
314: bulk collect into l_resource_id_tbl, l_resource_name_tbl from fnd_user_resp_groups respgrp,
315: jtf_rs_resource_extns res, fnd_responsibility resp where res.user_id=respgrp.user_id
316: and respgrp.responsibility_id=resp.responsibility_id and resp.application_id=680
317: and resp.responsibility_key = l_resource_role
318: and res.resource_id in ( select unique rel.role_resource_id from jtf_rs_role_relations rel where

Line 329: bulk collect into l_resource_id_tbl, l_resource_name_tbl from fnd_user_resp_groups respgrp,

325: or upper(res.user_name) like upper(p_resource_name))
326: order by resource_name;
327: else
328: select res.resource_id,concat(concat(res.source_last_name, ', '), res.source_first_name) as resource_name
329: bulk collect into l_resource_id_tbl, l_resource_name_tbl from fnd_user_resp_groups respgrp,
330: jtf_rs_resource_extns res, fnd_responsibility resp where res.user_id=respgrp.user_id
331: and respgrp.responsibility_id=resp.responsibility_id and resp.application_id=680
332: and resp.responsibility_key = l_resource_role
333: and res.resource_id in ( select unique rel.role_resource_id from jtf_rs_role_relations rel where