APPS.FND_CONC_RAC_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 47

   SELECT user_id
     into l_userid
     from fnd_user
    where user_name = 'CONCURRENT MANAGER';

Line: 52

   SELECT responsibility_id
     into l_respid
     from fnd_responsibility
    where responsibility_key = 'SYSTEM_ADMINISTRATOR';

Line: 57

   SELECT application_id
     into l_appid
     from fnd_application
    where application_short_name = 'SYSADMIN';

Line: 64

    select instance_number
      into l_inst
      from v$instance;

Line: 157

    select instance_number
      into l_inst
      from v$instance;

Line: 267

      select Session_Id, Instance_Number
        into l_audsid, l_inst
      from FND_CONCURRENT_PROCESSES
      where CONCURRENT_PROCESS_ID = p_cpid;

Line: 292

      select sid, serial#
        into l_sid, l_serial#
        from gv$session
       where audsid = l_audsid
         and inst_id = l_inst;

Line: 378

      select controlling_manager
        into l_cpid
      from FND_CONCURRENT_REQUESTS
      where request_id = p_reqid;

Line: 475

      select oracle_session_id
        into l_audsid
      from FND_CONCURRENT_REQUESTS
      where request_id = p_reqid;

Line: 510

     select inst_id, sid, serial#
       into l_inst, l_sid, l_serial#
       from gv$session
       where audsid = l_audsid;