DBA Data[Home] [Help]

APPS.MSC_WS_SNO_PUBLISH dependencies on FND_USER_RESP_GROUPS

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