APPS.FND_DCP dependencies on V$INSTANCE

Line 744: * the current instance number is retrieved from v$instance,

740: * service requests only for the instance associated with
741: * its primary node.
742: *
743: * If the manager was started on its primary node, then
744: * the current instance number is retrieved from v$instance,
745: * stored in fnd_concurrent_queues, and returned to the caller.
746: *
747: * If the manager was started on its secondary node, then
748: * the instance number is retrieved from fnd_concurrent_queues

Line 789: /* Get inst number from v$instance */

785: and application_id = queue_appl_id;
786:
787:
788: if (upper(current_node) = primary_node) then /* PCP Primary node */
789: /* Get inst number from v$instance */
790: select instance_number
791: into inst_num
792: from v$instance;
793:

Line 792: from v$instance;

788: if (upper(current_node) = primary_node) then /* PCP Primary node */
789: /* Get inst number from v$instance */
790: select instance_number
791: into inst_num
792: from v$instance;
793:
794: /* Store it into fnd_concurrent_queues. */
795:
796: update fnd_concurrent_queues