APPS.PJI_PJP_PRG_PERF_ALL dependencies on V$SESSION

Line 6333: from v$session

6329:
6330: select decode (PDML_STATUS, 'DISABLED', 'DISABLE', 'ENABLED', 'ENABLE', 'FORCED', 'FORCE', 'DISABLE'),
6331: decode (PQ_STATUS, 'DISABLED', 'DISABLE', 'ENABLED', 'ENABLE', 'FORCED', 'FORCE', 'ENABLE')
6332: into l_pdml_state, l_pq_state
6333: from v$session
6334: where sid = (select min(sid) from v$mystat where rownum < 2);
6335:
6336: commit;
6337: execute immediate 'alter session disable parallel query';

Line 6482: from v$session

6478:
6479: select decode (PDML_STATUS, 'DISABLED', 'DISABLE', 'ENABLED', 'ENABLE', 'FORCED', 'FORCE', 'DISABLE'),
6480: decode (PQ_STATUS, 'DISABLED', 'DISABLE', 'ENABLED', 'ENABLE', 'FORCED', 'FORCE', 'ENABLE')
6481: into l_pdml_state, l_pq_state
6482: from v$session
6483: where sid = (select min(sid) from v$mystat where rownum < 2);
6484:
6485: commit;
6486: end if;

Line 6506: from v$session

6502: if (upper(nvl(l_profile_check, 'N')) = 'Y') then
6503: select decode (PDML_STATUS, 'DISABLED', 'DISABLE', 'ENABLED', 'ENABLE', 'FORCED', 'FORCE', 'DISABLE'),
6504: decode (PQ_STATUS, 'DISABLED', 'DISABLE', 'ENABLED', 'ENABLE', 'FORCED', 'FORCE', 'ENABLE')
6505: into l_pdml_state, l_pq_state
6506: from v$session
6507: where sid = (select min(sid) from v$mystat where rownum < 2);
6508:
6509: commit;
6510: execute immediate 'alter session enable parallel query';