DBA Data[Home] [Help]

APPS.ZX_HR_LOCATIONS_REPORTING_HOOK dependencies on DUAL

Line 54: FROM dual;

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:
57: ZX_REPORTING_CODES_PKG.INSERT_ROW (
58: X_ROWID => l_rowid ,

Line 206: FROM dual;

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 (
209: X_ROWID => l_rowid ,
210: X_REPORTING_CODE_ID => l_reporting_code_id ,