DBA Data[Home] [Help]

APPS.CS_EA_AUTOGEN_TASKS_PVT dependencies on CUG_SR_TASK_TYPE_DETS_VL

Line 294: FROM cug_sr_task_type_dets_vl

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);

Line 300: l_owner_type_code cug_sr_task_type_dets_vl.owner_type_code % TYPE;

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

Line 301: l_owner_id cug_sr_task_type_dets_vl.owner_id % TYPE;

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;

Line 302: l_assignee_type_code cug_sr_task_type_dets_vl.owner_type_code % TYPE; --5686743

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';

Line 303: l_assignee_id cug_sr_task_type_dets_vl.owner_id % TYPE; --5686743

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