APPS.FND_DCP dependencies on V$INSTANCE

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

781: * service requests only for the instance associated with
782: * its primary node.
783: *
784: * If the manager was started on its primary node, then
785: * the current instance number is retrieved from v$instance,
786: * stored in fnd_concurrent_queues, and returned to the caller.
787: *
788: * If the manager was started on its secondary node, then
789: * the instance number is retrieved from fnd_concurrent_queues

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

826: and application_id = queue_appl_id;
827:
828:
829: if (upper(current_node) = primary_node) then /* PCP Primary node */
830: /* Get inst number from v$instance */
831: select instance_number
832: into inst_num
833: from v$instance;
834:

Line 833: from v$instance;

829: if (upper(current_node) = primary_node) then /* PCP Primary node */
830: /* Get inst number from v$instance */
831: select instance_number
832: into inst_num
833: from v$instance;
834:
835: /* Store it into fnd_concurrent_queues. */
836:
837: update fnd_concurrent_queues