APPS.BSC_APPS dependencies on FND_RESPONSIBILITY

Line 162: FROM fnd_responsibility

158:
159: BEGIN
160:
161: SELECT application_id INTO h_appl_id
162: FROM fnd_responsibility
163: WHERE responsibility_id = x_resp_id;
164:
165: FND_GLOBAL.Apps_Initialize(user_id => x_user_id,
166: resp_id => x_resp_id,

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