APPS.CZ_PB_SYNC dependencies on V$INSTANCE

Line 113: FROM v$instance

109: END IF;
110:
111: SELECT COUNT(*)
112: INTO x_src_verification
113: FROM v$instance
114: WHERE UPPER(host_name) = UPPER(l_hostname)
115: AND UPPER(instance_name) = UPPER(l_instance_name);
116:
117: IF (x_src_verification = 0) THEN

Line 155: FROM v$instance'||p_link_name;

151: v_return_flg BOOLEAN := FALSE;
152:
153: BEGIN
154: OPEN gl_ref_cursor FOR 'SELECT instance_name,host_name
155: FROM v$instance'||p_link_name;
156: LOOP
157: FETCH gl_ref_cursor INTO l_instance_name,l_host_name;
158: EXIT WHEN gl_ref_cursor%NOTFOUND;
159: END LOOP;

Line 1485: FROM v$instance;

1481:
1482: BEGIN
1483: SELECT host_name,instance_name
1484: INTO x_hostname,x_instance_name
1485: FROM v$instance;
1486: EXCEPTION
1487: WHEN OTHERS THEN
1488: RAISE;
1489: END get_local_server_info;