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