APPS.ZPB_PERSONAL_AW dependencies on V$SESSION

Line 1333: from v$session

1329:
1330: select sid, serial#, username, osuser, status, schemaname, machine
1331: into p_SID, p_serial_no, p_sess_user, p_os_user,
1332: p_status, p_schema_name, p_machine
1333: from v$session
1334: where sid = l_val
1335: and status <> 'KILLED';
1336:
1337: zpb_log.write('zpb_personal_aw.views_update.end',

Line 1370: from v$session ses, v$aw_olap vao

1366: -- give up if it is not killed after 30 seconds
1367: l_numtries:=0;
1368: while l_numtries < 60 loop
1369: select count(1) into l_stillExists
1370: from v$session ses, v$aw_olap vao
1371: where ses.sid=p_SID and
1372: ses.logon_time 1373: vao.session_id=ses.sid;
1374: -- if session still not killed sleep for a second and try again