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 260: l_msg := 'SELECT cz_servers_s.nextval from dual'||p_link_name;

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

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

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