DBA Data[Home] [Help]

APPS.WF_SOA_CTX_PKG dependencies on FND_USER_RESP_GROUPS

Line 272: FROM FND_USER_RESP_GROUPS

268: IF pRespID <> -1 THEN
269: If fnd_profile.value_specific('ENABLE_SECURITY_GROUPS',RESPONSIBILITY_ID=> pRespID, APPLICATION_ID=>pRespAppID )='Y' Then
270: SELECT 1
271: INTO nTemp
272: FROM FND_USER_RESP_GROUPS
273: WHERE user_id=pUserID
274: AND RESPONSIBILITY_ID=pRespID
275: and SECURITY_GROUP_ID=pSecurityGroupID
276: AND rownum <2;

Line 280: FROM FND_USER_RESP_GROUPS

276: AND rownum <2;
277: Else
278: SELECT 1
279: INTO nTemp
280: FROM FND_USER_RESP_GROUPS
281: WHERE user_id=pUserID
282: AND RESPONSIBILITY_ID=pRespID
283: AND rownum <2;
284: End if;