APPS.MSC_WS_SNO_PUBLISH dependencies on FND_USER

Line 2756: FROM FND_USER

2752: BEGIN
2753:
2754: BEGIN
2755: SELECT USER_ID INTO V_USER_ID
2756: FROM FND_USER
2757: WHERE USER_ID = USERID;
2758: EXCEPTION WHEN no_data_found THEN
2759: VRETURN := 'INVALID_USERID';
2760: RETURN;

Line 2767: FROM FND_USER_RESP_GROUPS

2763: END;
2764:
2765: BEGIN
2766: SELECT RESPONSIBILITY_ID INTO V_RESPID
2767: FROM FND_USER_RESP_GROUPS
2768: WHERE USER_ID = V_USER_ID AND RESPONSIBILITY_ID = RESPID AND
2769: (sysdate BETWEEN nvl(start_date,sysdate) AND nvl(end_date,sysdate));
2770: EXCEPTION WHEN no_data_found THEN
2771: VRETURN := 'INVALID_RESP_ID';