APPS.CS_EA_AUTOGEN_TASKS_PVT dependencies on FND_LOOKUPS

Line 252: select 1 from fnd_lookups

248: and trunc(sysdate) between nvl(start_date_active,sysdate-1)
249: and nvl(end_date_active ,sysdate+1)
250: ;
251: cursor c_lookup_code is
252: select 1 from fnd_lookups
253: where description = p_sr_ea_attr_val
254: and lookup_code = l_sr_attr_val_for_task
255: and lookup_type in (select sr_attribute_list_name
256: from cug_sr_type_attr_maps_b

Line 299: l_dummy fnd_lookups.lookup_type % type;

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