[Home] [Help]
38: a.owner_type,
39: a.ASSIGNEE_ID,
40: a.assignee_type,
41: a.ws_id
42: from ieu_uwqm_items a
43: Where a.DISTRIBUTION_STATUS_ID = 0
44: And nvl(a.owner_type, 'NULL') <> 'RS_GROUP'
45: AND nvl(a.assignee_type, 'NULL') <> 'RS_INDIVIDUAL'
46: and a.creation_date BETWEEN p_from_date AND p_to_date
237: a.owner_type,
238: a.ASSIGNEE_ID,
239: a.assignee_type,
240: a.ws_id
241: from ieu_uwqm_items a
242: Where a.DISTRIBUTION_STATUS_ID = 3
243: And a.assignee_type = 'RS_INDIVIDUAL'
244: And a.assignee_id IN ( select resource_id from JTF_RS_RESOURCE_EXTNS where lower(user_name) = lower(p_user_name))
245: and a.creation_date BETWEEN p_from_date AND p_to_date
501:
502:
503: begin
504: select title into title
505: from ieu_uwqm_items where workitem_pk_id = cur_rec.workitem_pk_id
506: and workitem_obj_code=cur_rec.workitem_obj_code;
507: exception
508: when no_data_found then null;
509: end;
740:
741:
742: begin
743: select title into title
744: from ieu_uwqm_items where workitem_pk_id = cur_rec.workitem_pk_id
745: and workitem_obj_code=cur_rec.workitem_obj_code;
746: exception
747: when no_data_found then null;
748: end;
928: a.owner_type,
929: a.ASSIGNEE_ID,
930: a.assignee_type,
931: a.ws_id
932: from ieu_uwqm_items a
933: Where a.DISTRIBUTION_STATUS_ID = 2
934: And a.owner_type = 'RS_GROUP'
935: And a.owner_id IN (select group_id FROM jtf_rs_groups_vl WHERE lower(GROUP_name) = lower(p_group_name))
936: and a.creation_date BETWEEN p_from_date AND p_to_date
1476:
1477:
1478: begin
1479: select title into title
1480: from ieu_uwqm_items where workitem_pk_id = cur_rec.workitem_pk_id
1481: and workitem_obj_code=p_object_code;
1482: exception
1483: when no_data_found then null;
1484: end;