APPS.CUG_SR_ATTRIBUTE_INTF dependencies on FND_LOOKUP_VALUES

Line 26: , fnd_lookup_values lkp

22: , lkp.end_date_active lkup_end_Date
23: ,srattr.sr_type_attr_seq_num
24: from cug_sr_type_attr_maps_vl srattr
25: , cs_incident_types_vl inctype
26: , fnd_lookup_values lkp
27: where srattr.incident_type_id = inctype.incident_type_id
28: and srattr.sr_attribute_code = lkp.lookup_code
29: and lkp.lookup_type = 'CUG_SR_TYPE_ATTRIBUTES'
30: and lkp.language = userenv('lang')

Line 40: from fnd_lookup_values

36: /* Cursor to select attribute ListName */
37: Cursor C_attr_listName (P_attr_code varchar2, p_start_date date) is
38: select lookup_code
39: , meaning
40: from fnd_lookup_values
41: where lookup_code = p_attr_code
42: and trunc(last_update_date) >= trunc(p_start_date);
43:
44: /* Cursor to check Existence of template in CS schema) */

Line 74: FROM fnd_lookup_values

70: , description description
71: , start_date_active start_date_active
72: , end_date_active end_date_active
73: , last_update_date last_update_date
74: FROM fnd_lookup_values
75: WHERE lookup_type = p_lookup_type
76: AND trunc(sysdate) between trunc(nvl(start_date_active,sysdate))
77: and trunc(nvl(end_date_active,sysdate))
78: AND language = userenv('LANG');

Line 570: from fnd_lookup_values

566: , lookup_type lookup_type
567: , start_date_active start_date_active
568: , end_date_active end_date_active
569: , last_update_date last_update_date
570: from fnd_lookup_values
571: where trunc(sysdate) between trunc(nvl(start_date_active,sysdate))
572: and trunc(nvl(end_date_active,sysdate))
573: and lookup_type = p_lookup_type
574: and language = userenv('LANG');