APPS.CS_SR_PROB_CODE_MAPPING_PKG dependencies on CS_LOOKUPS

Line 37: cs_lookups cslkup

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

Line 52: cs_lookups cslkup

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

Line 85: cs_lookups cslkup

81:
82: CURSOR cs_sr_pc_catset_with_srtype IS
83: select meaning
84: from
85: cs_lookups cslkup
86: where
87: cslkup.lookup_type='REQUEST_PROBLEM_CODE' and
88: cslkup.lookup_code = l_problem_code and
89: exists

Line 126: cs_lookups cslkup

122:
123: CURSOR cs_sr_pc_catset_with_prod IS
124: select meaning
125: from
126: cs_lookups cslkup
127: where
128: cslkup.lookup_type='REQUEST_PROBLEM_CODE' and
129: cslkup.lookup_code = l_problem_code and
130: exists

Line 176: cs_lookups cslkup

172:
173: CURSOR cs_sr_pc_cat_with_srtype IS
174: select meaning
175: from
176: cs_lookups cslkup
177: where
178: cslkup.lookup_type='REQUEST_PROBLEM_CODE' and
179: cslkup.lookup_code = l_problem_code and
180: exists

Line 210: cs_lookups cslkup

206:
207: CURSOR cs_sr_pc_cat_with_prod IS
208: select meaning
209: from
210: cs_lookups cslkup
211: where
212: cslkup.lookup_type='REQUEST_PROBLEM_CODE' and
213: cslkup.lookup_code = l_problem_code and
214: exists

Line 236: cs_lookups cslkup

232:
233: CURSOR cs_sr_pc_cat_with_prodcat IS
234: select meaning
235: from
236: cs_lookups cslkup
237: where
238: cslkup.lookup_type='REQUEST_PROBLEM_CODE' and
239: cslkup.lookup_code = l_problem_code and
240: exists

Line 550: SELECT lookup_code from cs_lookups

546: WHERE category_set_id = to_number(l_product_category_set)
547: AND category_id = l_product_category_id;
548:
549: CURSOR c_sr_problem_code_valid_csr IS
550: SELECT lookup_code from cs_lookups
551: WHERE lookup_code = l_problem_code
552: AND lookup_type = 'REQUEST_PROBLEM_CODE'and
553: (start_date_active is null or
554: trunc(start_date_active) <= trunc(sysdate)) and

Line 908: SELECT lookup_code from cs_lookups a

904: trunc(end_date_active) >= trunc(sysdate));
905:
906:
907: CURSOR cs_sr_problem_code_valid_csr IS
908: SELECT lookup_code from cs_lookups a
909: WHERE lookup_code = l_problem_code
910: AND lookup_type = 'REQUEST_PROBLEM_CODE' and
911: (start_date_active is null or
912: trunc(start_date_active) <= trunc(sysdate)) and