DBA Data[Home] [Help]

APPS.BSC_APPS dependencies on FND_USER_RESP_GROUPS

Line 1547: FROM FND_USER fu, FND_RESPONSIBILITY fr,FND_USER_RESP_GROUPS fur

1543: l_count := 0;
1544:
1545: SELECT COUNT(0)
1546: INTO l_count
1547: FROM FND_USER fu, FND_RESPONSIBILITY fr,FND_USER_RESP_GROUPS fur
1548: WHERE fu.User_Id = x_User_Id
1549: AND fu.User_Id = fur.User_Id
1550: AND fr.Responsibility_Id = fur.Responsibility_Id
1551: AND fr.Application_Id = fur.Responsibility_Application_Id

Line 1591: FROM FND_USER fu, FND_RESPONSIBILITY fr,FND_USER_RESP_GROUPS fur

1587: l_count := 0;
1588:
1589: SELECT COUNT(0)
1590: INTO l_count
1591: FROM FND_USER fu, FND_RESPONSIBILITY fr,FND_USER_RESP_GROUPS fur
1592: WHERE fu.User_Id = x_User_Id
1593: AND fu.User_Id = fur.User_Id
1594: AND (fr.responsibility_key = 'BSC_DESIGNER' OR fr.responsibility_key = 'BSC_Manager')
1595: AND fr.Responsibility_Id = fur.Responsibility_Id