APPS.CS_UWQ_DISTRIBUTE_ITEMS dependencies on JTF_RS_GROUP_MEMBERS

Line 401: FROM JTF_RS_GROUP_MEMBERS B

397: WHERE PROCESSING_SET_ID = P_PROCESSING_SET_ID
398: AND A.OWNER_TYPE_ACTUAL NOT IN ('RS_GROUP', 'RS_TEAM')
399: AND NOT EXISTS
400: ( SELECT 1
401: FROM JTF_RS_GROUP_MEMBERS B
402: , IEU_UWQM_ITEMS C
403: WHERE B.RESOURCE_ID = A.OWNER_ID
404: AND B.GROUP_ID = C.OWNER_ID
405: AND A.WORKITEM_OBJ_CODE = 'TASK'

Line 535: from jtf_rs_group_members

531: l_task_distributed_to := p_resource_id;
532:
533: begin
534: select 'X' into l_group_id
535: from jtf_rs_group_members
536: where resource_id = p_resource_id
537: and group_id = l_grp_owner
538: and nvl(delete_flag, 'N') = 'N'
539: and rownum < 2;

Line 544: --insert into rm_tmp values (null,null,'DISTRIBUTE_SRTASKS: After jtf_rs_group_members,x_return_status='||x_return_status,rm_tmp_seq.nextval);

540: exception when no_data_found then
541: x_return_status := 'E';
542: end;
543:
544: --insert into rm_tmp values (null,null,'DISTRIBUTE_SRTASKS: After jtf_rs_group_members,x_return_status='||x_return_status,rm_tmp_seq.nextval);
545: --commit;
546: if l_group_id = 'X' then
547:
548: if l_dist_st_based_on_parent_flag = 'Y' then