APPS.CZ_PB_SYNC_UTIL dependencies on DUAL

Line 19: FROM DUAL;

15:
16: BEGIN
17: SELECT cz_xfr_run_infos_s.NEXTVAL
18: INTO v_run_id
19: FROM DUAL;
20: RETURN v_run_id;
21: EXCEPTION
22: WHEN OTHERS THEN
23: RETURN v_run_id;

Line 262: l_msg := 'SELECT cz_servers_s.nextval from dual'||p_link_name;

258: x_status := '1';
259: x_msg := CZ_UTILS.GET_TEXT('CZ_PB_MGR_NOT_PRD_INSTANCE');
260: END IF;
261: ELSE
262: l_msg := 'SELECT cz_servers_s.nextval from dual'||p_link_name;
263: OPEN seq_ref_cursor FOR 'SELECT cz_servers_s.nextval from dual'||p_link_name;
264: LOOP
265: EXIT WHEN seq_ref_cursor%NOTFOUND;
266: FETCH seq_ref_cursor INTO l_server_local_id;

Line 263: OPEN seq_ref_cursor FOR 'SELECT cz_servers_s.nextval from dual'||p_link_name;

259: x_msg := CZ_UTILS.GET_TEXT('CZ_PB_MGR_NOT_PRD_INSTANCE');
260: END IF;
261: ELSE
262: l_msg := 'SELECT cz_servers_s.nextval from dual'||p_link_name;
263: OPEN seq_ref_cursor FOR 'SELECT cz_servers_s.nextval from dual'||p_link_name;
264: LOOP
265: EXIT WHEN seq_ref_cursor%NOTFOUND;
266: FETCH seq_ref_cursor INTO l_server_local_id;
267: END LOOP;