APPS.BSC_LOCKS_PVT dependencies on BSC_APPS_USERS_V

Line 4775: l_user_name BSC_APPS_USERS_V.USER_NAME%TYPE;

4771: ) IS
4772:
4773: l_api_name CONSTANT VARCHAR2(30) := 'RAISE_EXCEPTION';
4774: l_component BSC_LOOKUPS.MEANING%TYPE;
4775: l_user_name BSC_APPS_USERS_V.USER_NAME%TYPE;
4776: l_machine BSC_OBJECT_LOCK_USERS.MACHINE%TYPE;
4777: l_terminal BSC_OBJECT_LOCK_USERS.TERMINAL%TYPE;
4778:
4779: CURSOR c_get_user(

Line 4785: FROM BSC_OBJECT_LOCK_USERS L, BSC_APPS_USERS_V U

4781: ,c_object_type VARCHAR2
4782: ,c_user_type VARCHAR2
4783: ) IS
4784: SELECT L.PROGRAM_ID, U.USER_NAME, L.MACHINE, L.TERMINAL
4785: FROM BSC_OBJECT_LOCK_USERS L, BSC_APPS_USERS_V U
4786: WHERE L.OBJECT_KEY = c_object_key
4787: AND L.OBJECT_TYPE = c_object_type
4788: AND L.USER_TYPE = c_user_type
4789: AND L.USER_ID = U.USER_ID (+);