APPS.IEU_WORKLIST_ENUMS_PVT dependencies on IEU_UWQM_ITEMS

Line 218: from ieu_uwqm_items where

214: if l_node_type = 1 then
215: begin
216: select count(*)
217: into x_count
218: from ieu_uwqm_items where
219: (((owner_id in (select group_id from jtf_rs_group_members where
220: resource_id=p_resource_id ) and owner_type=l_owner_type_grp)
221: OR (owner_id=p_resource_id AND owner_type = l_owner_type_ind))
222: OR

Line 269: from ieu_uwqm_items

265:
266: select count(*)
267: into x_ind_own_count
268: -- from IEU_UWQ_WORKLIST_V
269: from ieu_uwqm_items
270: where owner_type = 'RS_INDIVIDUAL'
271: and owner_id = p_resource_id
272: and (status_id <> 3 or status_id <> 4);
273:

Line 284: from ieu_uwqm_items

280: BEGIN
281:
282: select count(*)
283: into x_grp_own_count
284: from ieu_uwqm_items
285: where owner_type ='RS_GROUP'
286: and owner_id in
287: (
288: select group_id from jtf_rs_group_members

Line 302: from ieu_uwqm_items

298: BEGIN
299:
300: select count(*)
301: into x_ind_asg_count
302: from ieu_uwqm_items
303: where assignee_type ='RS_INDIVIDUAL'
304: and assignee_id = p_resource_id
305: and (status_id <> 3 or status_id <> 4);
306:

Line 316: from ieu_uwqm_items

312: BEGIN
313:
314: select count(*)
315: into x_grp_asg_count
316: from ieu_uwqm_items
317: where
318: assignee_type = 'RS_GROUP'
319: and assignee_id in
320: (