DBA Data[Home] [Help]

APPS.MSC_WS_COMMON dependencies on FND_USER_RESP_GROUPS

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';