APPS.CS_EA_AUTOGEN_TASKS_PVT dependencies on CUG_TSK_TYP_ATTR_DEPS_VL

Line 237: l_sr_attr_op cug_tsk_typ_attr_deps_vl.sr_attribute_operator % type;

233: p_taskrec_table in out nocopy ea_task_table_type,
234: p_task_count in out nocopy number) is
235: --
236: l_task_type_id jtf_task_types_b.task_type_id % type;
237: l_sr_attr_op cug_tsk_typ_attr_deps_vl.sr_attribute_operator % type;
238: l_sr_attr_val_for_Task cug_tsk_typ_attr_deps_vl.sr_attribute_value % type;
239: l_sr_attr_val_for_Task1 cug_tsk_typ_attr_deps_vl.sr_attribute_value % type;
240: cursor c_sr_attr_tasks is
241: select task_type_id,

Line 238: l_sr_attr_val_for_Task cug_tsk_typ_attr_deps_vl.sr_attribute_value % type;

234: p_task_count in out nocopy number) is
235: --
236: l_task_type_id jtf_task_types_b.task_type_id % type;
237: l_sr_attr_op cug_tsk_typ_attr_deps_vl.sr_attribute_operator % type;
238: l_sr_attr_val_for_Task cug_tsk_typ_attr_deps_vl.sr_attribute_value % type;
239: l_sr_attr_val_for_Task1 cug_tsk_typ_attr_deps_vl.sr_attribute_value % type;
240: cursor c_sr_attr_tasks is
241: select task_type_id,
242: sr_attribute_operator,

Line 239: l_sr_attr_val_for_Task1 cug_tsk_typ_attr_deps_vl.sr_attribute_value % type;

235: --
236: l_task_type_id jtf_task_types_b.task_type_id % type;
237: l_sr_attr_op cug_tsk_typ_attr_deps_vl.sr_attribute_operator % type;
238: l_sr_attr_val_for_Task cug_tsk_typ_attr_deps_vl.sr_attribute_value % type;
239: l_sr_attr_val_for_Task1 cug_tsk_typ_attr_deps_vl.sr_attribute_value % type;
240: cursor c_sr_attr_tasks is
241: select task_type_id,
242: sr_attribute_operator,
243: sr_attribute_value,

Line 245: from cug_tsk_typ_attr_deps_vl

241: select task_type_id,
242: sr_attribute_operator,
243: sr_attribute_value,
244: tsk_typ_attr_dep_id
245: from cug_tsk_typ_attr_deps_vl
246: where incident_type_id = p_incident_type_id
247: and nvl(sr_attribute_code,'-909') = nvl(p_sr_ea_attr_code,'-909')
248: and trunc(sysdate) between nvl(start_date_active,sysdate-1)
249: and nvl(end_date_active ,sysdate+1)