APPS.MSC_WS_COMMON dependencies on FND_USER

Line 17: FROM FND_USER

13: BEGIN
14:
15: BEGIN
16: SELECT USER_ID INTO V_USER_ID
17: FROM FND_USER
18: WHERE USER_ID = USERID;
19: EXCEPTION WHEN no_data_found THEN
20: VRETURN := 'INVALID_USERID';
21: RETURN;

Line 28: FROM FND_USER_RESP_GROUPS

24: END;
25:
26: BEGIN
27: SELECT RESPONSIBILITY_ID INTO V_RESPID
28: FROM FND_USER_RESP_GROUPS
29: WHERE USER_ID = V_USER_ID AND RESPONSIBILITY_ID = RESPID AND
30: (sysdate BETWEEN nvl(start_date,sysdate) AND nvl(end_date,sysdate));
31: EXCEPTION WHEN no_data_found THEN
32: VRETURN := 'USER_NOT_ASSIGNED_RESP';

Line 94: FROM fnd_user

90: BEGIN
91: -- query user id by UserName.
92: BEGIN
93: SELECT user_id INTO UserId
94: FROM fnd_user
95: WHERE user_name = upper(UserName);
96: EXCEPTION
97: WHEN no_data_found THEN
98: Status := 'INVALID_USER_NAME';