APPS.IEU_WORKLIST_ENUMS_PVT dependencies on JTF_RS_GROUP_MEMBERS

Line 133: ( select group_id from jtf_rs_group_members where resource_id= :owner_id ) and (status_id <> 3 or status_id <> 4) ';

129: l_wl_list(l_node_counter).VIEW_NAME := 'IEU_UWQM_WORKLIST_V';
130: l_wl_list(l_node_counter).DATA_SOURCE := 'IEU_UWQM_WORKLIST_DS';
131: l_wl_list(l_node_counter).MEDIA_TYPE_ID := '';
132: l_wl_list(l_node_counter).WHERE_CLAUSE := 'owner_type = '||''''||'RS_GROUP'||''''||' and owner_id in
133: ( select group_id from jtf_rs_group_members where resource_id= :owner_id ) and (status_id <> 3 or status_id <> 4) ';
134: l_wl_list(l_node_counter).NODE_TYPE := 4;
135: l_wl_list(l_node_counter).HIDE_IF_EMPTY := '';
136: l_wl_list(l_node_counter).NODE_DEPTH := 2;
137: l_wl_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_grp_own_bind_list);

Line 158: ( select group_id from jtf_rs_group_members where resource_id= :assignee_id ) and (status_id <> 3 or status_id <> 4) ';

154: l_wl_list(l_node_counter).VIEW_NAME := 'IEU_UWQM_WORKLIST_V';
155: l_wl_list(l_node_counter).DATA_SOURCE := 'IEU_UWQM_WORKLIST_DS';
156: l_wl_list(l_node_counter).MEDIA_TYPE_ID := '';
157: l_wl_list(l_node_counter).WHERE_CLAUSE := 'assignee_type = '||''''||'RS_GROUP'||''''||' and assignee_id in
158: ( select group_id from jtf_rs_group_members where resource_id= :assignee_id ) and (status_id <> 3 or status_id <> 4) ';
159: l_wl_list(l_node_counter).NODE_TYPE := 5;
160: l_wl_list(l_node_counter).HIDE_IF_EMPTY := '';
161: l_wl_list(l_node_counter).NODE_DEPTH := 2;
162: l_wl_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_grp_asg_bind_list);

Line 219: (((owner_id in (select group_id from jtf_rs_group_members where

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
223: ((assignee_id in (select group_id from jtf_rs_group_members where

Line 223: ((assignee_id in (select group_id from jtf_rs_group_members 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
223: ((assignee_id in (select group_id from jtf_rs_group_members where
224: resource_id=p_resource_id ) and assignee_type=l_owner_type_grp)
225: OR (assignee_id=p_resource_id AND assignee_type = l_owner_type_ind)))
226: and status_id not in (3,4);
227: exception

Line 288: select group_id from jtf_rs_group_members

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
289: where resource_id= p_resource_id
290: )
291: and (status_id <> 3 or status_id <> 4);
292:

Line 321: select group_id from jtf_rs_group_members

317: where
318: assignee_type = 'RS_GROUP'
319: and assignee_id in
320: (
321: select group_id from jtf_rs_group_members
322: where resource_id= p_resource_id
323: )
324: and (status_id <> 3 or status_id <> 4);
325: