APPS.BIS_RG_SCHEDULES_PVT dependencies on WF_LOCAL_USER_ROLES

Line 990: from WF_LOCAL_USER_ROLES ur, fnd_user u

986:
987: -- Check if user is not already part of the role
988: select count(1)
989: into vUserExists
990: from WF_LOCAL_USER_ROLES ur, fnd_user u
991: where u.user_id = pUserId
992: and ur.user_name = u.user_name
993: and role_name = pRole;
994:

Line 1797: from WF_LOCAL_USER_ROLES

1793: if vUserName is not null then
1794: -- Check if user is part of the role
1795: select count(1)
1796: into vUserExists
1797: from WF_LOCAL_USER_ROLES
1798: where user_name = vUserName
1799: and role_name = vRoleName;
1800:
1801: if vUserExists > 0 then

Line 1808: from WF_LOCAL_USER_ROLES

1804:
1805: -- If no more subscribers to this file, then delete this role as well
1806: select count(1)
1807: into vUserExists
1808: from WF_LOCAL_USER_ROLES
1809: where role_name = vRoleName;
1810:
1811: if vUserExists = 0 then
1812: delete wf_local_roles