APPS.ZX_HR_LOCATIONS_REPORTING_HOOK dependencies on ZX_REPORTING_CODES_TL

Line 239: DELETE FROM zx_reporting_codes_tl

235: WHERE reporting_code_char_value = p_location_code_o --NOTE
236: AND reporting_type_id = l_reporting_type_id(k);
237:
238: FORALL i IN 1..l_reporting_code_id_tbl.count
239: DELETE FROM zx_reporting_codes_tl
240: WHERE reporting_code_id = l_reporting_code_id_tbl(i);
241:
242: FORALL j IN 1..l_reporting_code_id_tbl.count
243: DELETE FROM zx_reporting_codes_b

Line 269: DELETE FROM zx_reporting_codes_tl

265: WHERE reporting_code_char_value = p_location_code_o
266: AND reporting_type_id = l_reporting_type_id(k);
267:
268: FORALL i IN 1..l_reporting_code_id_tbl.count
269: DELETE FROM zx_reporting_codes_tl
270: WHERE reporting_code_id = l_reporting_code_id_tbl(i);
271:
272: FORALL j IN 1..l_reporting_code_id_tbl.count
273: DELETE FROM zx_reporting_codes_b

Line 334: DELETE FROM zx_reporting_codes_tl

330: WHERE reporting_code_char_value = p_location_code_o;
331: IF l_reporting_code_id_tbl IS NOT NULL
332: THEN
333: FORALL i IN 1..l_reporting_code_id_tbl.count
334: DELETE FROM zx_reporting_codes_tl
335: WHERE reporting_code_id = l_reporting_code_id_tbl(i);
336:
337: FORALL j IN 1..l_reporting_code_id_tbl.count
338: DELETE FROM zx_reporting_codes_b