APPS.BSC_MO_HELPER_PKG dependencies on V$SESSION

Line 6247: FROM btable, v$session

6243: SELECT table_name, owner
6244: FROM btable
6245: MINUS
6246: SELECT table_name, owner
6247: FROM btable, v$session
6248: WHERE substr(table_name, instr(table_name, '_', -1)+1, 100) in
6249: (select to_char(audsid) from v$session where status<>'KILLED');
6250:
6251: l_table_name VARCHAR2(100);

Line 6249: (select to_char(audsid) from v$session where status<>'KILLED');

6245: MINUS
6246: SELECT table_name, owner
6247: FROM btable, v$session
6248: WHERE substr(table_name, instr(table_name, '_', -1)+1, 100) in
6249: (select to_char(audsid) from v$session where status<>'KILLED');
6250:
6251: l_table_name VARCHAR2(100);
6252: l_owner VARCHAR2(100);
6253: BEGIN