APPS.ZX_HR_LOCATIONS_REPORTING_HOOK dependencies on ZX_REPORTING_CODES_B_S

Line 52: SELECT zx_reporting_codes_b_s.nextval

48:
49: IF l_reporting_type_id IS NOT NULL
50: THEN
51: FOR i in Nvl(l_reporting_type_id.first,1)..Nvl(l_reporting_type_id.last,0) LOOP
52: SELECT zx_reporting_codes_b_s.nextval
53: INTO l_reporting_code_id
54: FROM dual;
55:
56:

Line 204: SELECT zx_reporting_codes_b_s.nextval

200: AND reporting_type_id = l_reporting_type_id(k);
201:
202: IF l_cnt_assoc_rep_codes = 0 THEN
203: -- CASE 1 : Insert and delete
204: SELECT zx_reporting_codes_b_s.nextval
205: INTO l_reporting_code_id
206: FROM dual;
207:
208: ZX_REPORTING_CODES_PKG.INSERT_ROW (