DBA Data[Home] [Help]

APPS.BSC_SCORECARD_PVT dependencies on FND_USER

Line 1326: FROM fnd_user_resp_groups ur,

1322: )IS
1323:
1324: CURSOR c_BscUserPool IS
1325: SELECT distinct usr.user_name
1326: FROM fnd_user_resp_groups ur,
1327: fnd_responsibility r,
1328: fnd_user usr
1329: WHERE ur.responsibility_id = r.responsibility_id
1330: AND usr.user_id = ur.user_id

Line 1328: fnd_user usr

1324: CURSOR c_BscUserPool IS
1325: SELECT distinct usr.user_name
1326: FROM fnd_user_resp_groups ur,
1327: fnd_responsibility r,
1328: fnd_user usr
1329: WHERE ur.responsibility_id = r.responsibility_id
1330: AND usr.user_id = ur.user_id
1331: AND ur.responsibility_application_id = r.application_id
1332: AND r.application_id = 271

Line 1469: FND_USER_RESP_GROUPS fug,

1465: l_object_id NUMBER;
1466: /*CURSOR c_BscUserPool IS
1467: SELECT DISTINCT U.USER_ID,U.USER_NAME,U.FULL_NAME
1468: FROM bsc_apps_users_v U,
1469: FND_USER_RESP_GROUPS fug,
1470: FND_RESPONSIBILITY rd
1471: WHERE U.BSC_VALID_FLAG =1
1472: AND U.USER_ID = fug.USER_ID
1473: AND fug.RESPONSIBILITY_ID = rd.RESPONSIBILITY_ID