APPS.ZX_HR_LOCATIONS_REPORTING_HOOK dependencies on ZX_REPORTING_TYPES_B

Line 46: FROM zx_reporting_types_b

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

Line 180: FROM zx_reporting_types_b

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

Line 322: FROM zx_reporting_types_b

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