42:
43: IF l_cnt_reporting_code = 0 THEN
44: SELECT reporting_type_id
45: BULK COLLECT INTO l_reporting_type_id
46: FROM zx_reporting_types_b
47: WHERE reporting_type_code = 'KR_BUSINESS_LOCATIONS';
48:
49: IF l_reporting_type_id IS NOT NULL
50: THEN
176: l_cnt_rep_codes := 0;
177:
178: SELECT reporting_type_id
179: BULK COLLECT INTO l_reporting_type_id
180: FROM zx_reporting_types_b
181: WHERE reporting_type_code = 'KR_BUSINESS_LOCATIONS';
182:
183: IF l_reporting_type_id is not null
184: then
318: INTO l_cnt_assoc_rep_codes
319: FROM zx_report_codes_assoc
320: WHERE reporting_code_char_value = p_location_code_o
321: AND reporting_type_id in (SELECT reporting_type_id
322: FROM zx_reporting_types_b
323: WHERE reporting_type_code = 'KR_BUSINESS_LOCATIONS');
324:
325: IF l_cnt_assoc_rep_codes = 0 THEN
326: SELECT reporting_code_id