APPS.CZ_PUBL_SYNC_CRASH dependencies on V$INSTANCE

Line 59: execute immediate 'select INSTANCE_NAME, HOST_NAME from v$instance@'|| lLinkName

55: RAISE DB_LINK_DOWN;
56: END IF;
57: END IF;
58:
59: execute immediate 'select INSTANCE_NAME, HOST_NAME from v$instance@'|| lLinkName
60: INTO lSid, lHost;
61: IF ((upper(lSid) = upper(lServerName)) and (upper(lHost) = upper(lHostName))) THEN
62: return true;
63: ELSE

Line 117: execute immediate 'select INSTANCE_NAME, HOST_NAME from v$instance'

113: IF (lServerName is NOT NULL) THEN
114: IF (lServerName = 'LOCAL') THEN
115: NULL;
116: ELSE
117: execute immediate 'select INSTANCE_NAME, HOST_NAME from v$instance'
118: INTO lSid, lHost ;
119: IF ((upper(lSid) = upper(lServerName)) and (upper(lHost) = upper(lHostName))) THEN
120: return true;
121: ELSE

Line 1265: SELECT INSTANCE_NAME, HOST_NAME INTO lServerName,lHostName from v$instance;

1261: ' SELECT hostname, instance_name INTO ' || lHost || ',' || lSid ||
1262: ' FROM CZ_SERVERS'|| lLinkName ||
1263: ' WHERE source_server_flag = ''1''';
1264:
1265: SELECT INSTANCE_NAME, HOST_NAME INTO lServerName,lHostName from v$instance;
1266: IF ((upper(lSid) = upper(lServerName)) and (upper(lHost) = upper(lHostName))) THEN
1267: return true;
1268: ELSE
1269: /* ERRNO := czError;