APPS.IEU_UWQ_GET_NEXT_WORK_PVT dependencies on JTF_RS_GROUP_MEMBERS

Line 322: and owner_id in (select group_id from jtf_rs_group_members where resource_id = p_resource_id)

318: select work_item_id, priority_level, to_char(due_date,'dd-mon-yyyy hh24:mi:ss') due_date,
319: workitem_obj_code
320: from ieu_uwqm_items
321: where owner_type = l_owner_type_grp
322: and owner_id in (select group_id from jtf_rs_group_members where resource_id = p_resource_id)
323: and status_id in (0,1,2)
324: and reschedule_time <= sysdate
325: order by priority_level, due_date;
326:

Line 388: and assignee_id in (select group_id from jtf_rs_group_members where resource_id =p_resource_id)

384: select work_item_id, priority_level, to_char(due_date,'dd-mon-yyyy hh24:mi:ss') due_date,
385: workitem_obj_code
386: from ieu_uwqm_items
387: where assignee_type = l_owner_type_grp
388: and assignee_id in (select group_id from jtf_rs_group_members where resource_id =p_resource_id)
389: and status_id in (0,1,2)
390: and reschedule_time <= sysdate
391: order by priority_level, due_date;
392:

Line 872: and owner_id in (select group_id from jtf_rs_group_members where resource_id = p_resource_id)

868: union
869: select work_item_id
870: from ieu_uwqm_items
871: where owner_type = l_owner_type_grp
872: and owner_id in (select group_id from jtf_rs_group_members where resource_id = p_resource_id)
873: and status_id = p_status_id
874: and (p_node_type = 1 or p_node_type = 3)
875: and reschedule_time <= sysdate
876: union

Line 888: and assignee_id in (select group_id from jtf_rs_group_members where resource_id =p_resource_id)

884: union
885: select work_item_id
886: from ieu_uwqm_items
887: where assignee_type = l_owner_type_grp
888: and assignee_id in (select group_id from jtf_rs_group_members where resource_id =p_resource_id)
889: and status_id = p_status_id
890: and (p_node_type = 1 or p_node_type = 5)
891: and reschedule_time <= sysdate;
892: begin

Line 4366: select group_id from jtf_rs_group_members

4362:
4363: l_delete_flag_yes varchar2(1);
4364:
4365: cursor c_grp_id(p_resource_id in number) is
4366: select group_id from jtf_rs_group_members
4367: where resource_id = p_resource_id
4368: and nvl(delete_flag, 'N') <> l_delete_flag_yes;
4369:
4370: l_not_valid_flag VARCHAR2(1);

Line 4409: 1. owner_id in (select group_id from jtf_rs_group_members

4405: END;
4406: END IF;
4407:
4408: /* performance issues with the query and try three different approach and using the one that is giving better performance
4409: 1. owner_id in (select group_id from jtf_rs_group_members
4410: where resource_id = :resource_id
4411: and nvl(delete_flag,'N') <> 'Y');
4412: 2. exists (select 1 from jtf_rs_group_members
4413: where resource_id = :resource_id

Line 4412: 2. exists (select 1 from jtf_rs_group_members

4408: /* performance issues with the query and try three different approach and using the one that is giving better performance
4409: 1. owner_id in (select group_id from jtf_rs_group_members
4410: where resource_id = :resource_id
4411: and nvl(delete_flag,'N') <> 'Y');
4412: 2. exists (select 1 from jtf_rs_group_members
4413: where resource_id = :resource_id
4414: and nvl(delete_flag,'N') <> 'Y');
4415: 3. owner_id in (group_id1, group_id2, group_id3); - Explicitly passing the string.
4416:

Line 4574: (select group_id from jtf_rs_group_members

4570:
4571: -- Build the complete Grp Asg Where clause
4572: l_df_asg_where_clause := ' assignee_type = '||':assignee_type'||(l_bindvar_fm_ctr-2)||
4573: ' and assignee_id in
4574: (select group_id from jtf_rs_group_members
4575: where resource_id = :resource_id'||
4576: ' and nvl(delete_flag,'||':delete_flag'||(l_bindvar_fm_ctr-1)||') <> '||':delete_flag'||l_bindvar_fm_ctr||')';
4577:
4578: l_fm_group_assigned_flag := 'T';

Line 4896: select group_id from jtf_rs_group_members

4892:
4893: l_delete_flag_no varchar2(1);
4894:
4895: cursor c_grp_id(p_resource_id in number) is
4896: select group_id from jtf_rs_group_members
4897: where resource_id = p_resource_id
4898: and nvl(delete_flag, 'N') = l_delete_flag_no;
4899:
4900: BEGIN