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