APPS.BSC_BIS_LOCKS_PUB dependencies on BSC_APPS_USERS_V

Line 1539: FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u

1535: )IS
1536: PRAGMA AUTONOMOUS_TRANSACTION;
1537: CURSOR c_conflict_session IS
1538: SELECT c.program_id, u.user_name, s.machine, s.terminal
1539: FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u
1540: WHERE c.session_id = s.audsid
1541: AND c.program_id IN (-100, -101, -200, -201, -700, -800, -802)
1542: AND c.session_id <> USERENV('SESSIONID')
1543: AND c.user_id = u.user_id (+);