APPS.MSC_WS_SNO_PUBLISH dependencies on FND_USER

Line 2261: FROM FND_USER

2257: BEGIN
2258:
2259: BEGIN
2260: SELECT USER_ID INTO V_USER_ID
2261: FROM FND_USER
2262: WHERE USER_ID = USERID;
2263: EXCEPTION WHEN no_data_found THEN
2264: VRETURN := 'INVALID_USERID';
2265: RETURN;

Line 2272: FROM FND_USER_RESP_GROUPS

2268: END;
2269:
2270: BEGIN
2271: SELECT RESPONSIBILITY_ID INTO V_RESPID
2272: FROM FND_USER_RESP_GROUPS
2273: WHERE USER_ID = V_USER_ID AND RESPONSIBILITY_ID = RESPID AND
2274: (sysdate BETWEEN nvl(start_date,sysdate) AND nvl(end_date,sysdate));
2275: EXCEPTION WHEN no_data_found THEN
2276: VRETURN := 'INVALID_RESP_ID';