APPS.ZX_HR_LOCATIONS_REPORTING_HOOK dependencies on ZX_REPORT_CODES_ASSOC

Line 198: FROM zx_report_codes_assoc

194: l_cnt_assoc_rep_codes := 0;
195: -- Is reporting code associated with tax rate code?
196: SELECT count(reporting_code_char_value)
197: INTO l_cnt_assoc_rep_codes
198: FROM zx_report_codes_assoc
199: WHERE reporting_code_char_value = p_location_code_o
200: AND reporting_type_id = l_reporting_type_id(k);
201:
202: IF l_cnt_assoc_rep_codes = 0 THEN

Line 255: FROM zx_report_codes_assoc

251: l_cnt_assoc_rep_codes := 0;
252: -- Is reporting code associated with tax rate code?
253: SELECT count(reporting_code_char_value)
254: INTO l_cnt_assoc_rep_codes
255: FROM zx_report_codes_assoc
256: WHERE reporting_code_char_value = p_location_code_o
257: AND reporting_type_id = l_reporting_type_id(k);
258:
259: IF l_cnt_assoc_rep_codes = 0 THEN

Line 319: FROM zx_report_codes_assoc

315: THEN
316: -- Is reporting code associated with tax rate code?
317: SELECT count(reporting_code_char_value)
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');