APPS.BSC_LOCKS_PUB dependencies on BSC_APPS_USERS_V

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

1603: l_session_id NUMBER;
1604:
1605: CURSOR c_conflict_session(c_program_id NUMBER) IS
1606: SELECT c.program_id, u.user_name, s.machine, s.terminal
1607: FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u
1608: WHERE c.session_id = s.audsid
1609: AND ((c_program_id = -100 AND c.program_id IN (-300, -400, -500, -700, -800, -802))
1610: OR (c_program_id = -101 AND c.program_id IN (-300, -400, -500, -700, -800, -802))
1611: OR (c_program_id = -200 AND c.program_id IN (-300, -400, -500, -700, -800, -802))