290: , owner_type_code
291: , owner_id
292: , assignee_type_code --5686743
293: , assigned_by_id --5686743
294: FROM cug_sr_task_type_dets_vl
295: WHERE tsk_typ_attr_dep_id = l_tsk_typ_attr_dep_id;
296: l_match_found varchar2(1);
297: l_sr_attr_found varchar2(1);
298: l_sr_attr_task_found varchar2(1);
296: l_match_found varchar2(1);
297: l_sr_attr_found varchar2(1);
298: l_sr_attr_task_found varchar2(1);
299: l_dummy fnd_lookups.lookup_type % type;
300: l_owner_type_code cug_sr_task_type_dets_vl.owner_type_code % TYPE;
301: l_owner_id cug_sr_task_type_dets_vl.owner_id % TYPE;
302: l_assignee_type_code cug_sr_task_type_dets_vl.owner_type_code % TYPE; --5686743
303: l_assignee_id cug_sr_task_type_dets_vl.owner_id % TYPE; --5686743
304: begin
297: l_sr_attr_found varchar2(1);
298: l_sr_attr_task_found varchar2(1);
299: l_dummy fnd_lookups.lookup_type % type;
300: l_owner_type_code cug_sr_task_type_dets_vl.owner_type_code % TYPE;
301: l_owner_id cug_sr_task_type_dets_vl.owner_id % TYPE;
302: l_assignee_type_code cug_sr_task_type_dets_vl.owner_type_code % TYPE; --5686743
303: l_assignee_id cug_sr_task_type_dets_vl.owner_id % TYPE; --5686743
304: begin
305: open c_sr_attr_tasks;
298: l_sr_attr_task_found varchar2(1);
299: l_dummy fnd_lookups.lookup_type % type;
300: l_owner_type_code cug_sr_task_type_dets_vl.owner_type_code % TYPE;
301: l_owner_id cug_sr_task_type_dets_vl.owner_id % TYPE;
302: l_assignee_type_code cug_sr_task_type_dets_vl.owner_type_code % TYPE; --5686743
303: l_assignee_id cug_sr_task_type_dets_vl.owner_id % TYPE; --5686743
304: begin
305: open c_sr_attr_tasks;
306: l_sr_attr_task_found := 'n';
299: l_dummy fnd_lookups.lookup_type % type;
300: l_owner_type_code cug_sr_task_type_dets_vl.owner_type_code % TYPE;
301: l_owner_id cug_sr_task_type_dets_vl.owner_id % TYPE;
302: l_assignee_type_code cug_sr_task_type_dets_vl.owner_type_code % TYPE; --5686743
303: l_assignee_id cug_sr_task_type_dets_vl.owner_id % TYPE; --5686743
304: begin
305: open c_sr_attr_tasks;
306: l_sr_attr_task_found := 'n';
307: loop