APPS.CS_SR_RES_CODE_MAPPING_PKG dependencies on CS_LOOKUPS

Line 37: cs_lookups cslkup

33: If it is NOT an active resolution code, we stop validation immeadiately
34: Else, we continue with the rest of the resolution code validation */
35: CURSOR cs_sr_active_rc_csr IS
36: select meaning from
37: cs_lookups cslkup
38: where
39: cslkup.lookup_type='REQUEST_RESOLUTION_CODE' and
40: cslkup.lookup_code = l_resolution_code and
41: (cslkup.start_date_active is null or trunc(cslkup.start_date_active) <= trunc(sysdate)) and

Line 51: cs_lookups cslkup

47: an active resolution code mapping. Else, we assume that the resolution code mapping
48: can be disregarded */
49: CURSOR cs_sr_unmapped_rc_csr IS
50: select meaning from
51: cs_lookups cslkup
52: where
53: cslkup.lookup_type='REQUEST_RESOLUTION_CODE' and
54: cslkup.lookup_code = l_resolution_code and
55: not exists

Line 83: cs_lookups cslkup

79: */
80: CURSOR cs_sr_rc_catset_srtype IS
81: select meaning
82: from
83: cs_lookups cslkup
84: where
85: cslkup.lookup_type='REQUEST_RESOLUTION_CODE' and
86: cslkup.lookup_code = l_resolution_code and
87: exists

Line 147: cs_lookups cslkup

143:
144: CURSOR cs_sr_rc_catset_prod IS
145: select meaning
146: from
147: cs_lookups cslkup
148: where
149: cslkup.lookup_type='REQUEST_RESOLUTION_CODE' and
150: cslkup.lookup_code = l_resolution_code and
151: exists

Line 181: cs_lookups cslkup

177:
178: CURSOR cs_sr_rc_catset_prodcat IS
179: select meaning
180: from
181: cs_lookups cslkup
182: where
183: cslkup.lookup_type='REQUEST_RESOLUTION_CODE' and
184: cslkup.lookup_code = l_resolution_code and
185: exists

Line 222: cs_lookups cslkup

218:
219: CURSOR cs_sr_rc_catset_probc IS
220: select meaning
221: from
222: cs_lookups cslkup
223: where
224: cslkup.lookup_type='REQUEST_RESOLUTION_CODE' and
225: cslkup.lookup_code = l_resolution_code and
226: exists

Line 263: cs_lookups cslkup

259:
260: CURSOR cs_sr_rc_cat_srtype IS
261: select meaning
262: from
263: cs_lookups cslkup
264: where
265: cslkup.lookup_type='REQUEST_RESOLUTION_CODE' and
266: cslkup.lookup_code = l_resolution_code and
267: exists

Line 317: cs_lookups cslkup

313:
314: CURSOR cs_sr_rc_cat_prodcat IS
315: select meaning
316: from
317: cs_lookups cslkup
318: where
319: cslkup.lookup_type='REQUEST_RESOLUTION_CODE' and
320: cslkup.lookup_code = l_resolution_code and
321: exists

Line 710: SELECT lookup_code from cs_lookups

706: WHERE category_set_id = to_number(l_product_category_set)
707: AND category_id = l_product_category_id;
708:
709: CURSOR c_sr_resolution_code_valid_csr IS
710: SELECT lookup_code from cs_lookups
711: WHERE lookup_code = l_resolution_code
712: AND lookup_type = 'REQUEST_RESOLUTION_CODE'and
713: (start_date_active is null or
714: trunc(start_date_active) <= trunc(sysdate)) and

Line 1078: SELECT lookup_code from cs_lookups a

1074: trunc(end_date_active) >= trunc(sysdate));
1075:
1076:
1077: CURSOR cs_sr_res_code_valid_csr IS
1078: SELECT lookup_code from cs_lookups a
1079: WHERE lookup_code = l_resolution_code
1080: AND lookup_type = 'REQUEST_RESOLUTION_CODE' and
1081: (start_date_active is null or
1082: trunc(start_date_active) <= trunc(sysdate)) and