DBA Data[Home] [Help]

APPS.BSC_LAUNCH_PAD_PUB dependencies on BSC_USER_TAB_ACCESS

Line 279: AND B.Responsibility_Id IN (SELECT DISTINCT Responsibility_Id from BSC_USER_TAB_ACCESS);

275: FROM FND_MENUS_VL A
276: ,FND_RESPONSIBILITY_VL B
277: WHERE B.Application_Id =271
278: AND B.Menu_Id = A.MENU_ID
279: AND B.Responsibility_Id IN (SELECT DISTINCT Responsibility_Id from BSC_USER_TAB_ACCESS);
280:
281: BEGIN
282:
283: FOR table_index in 0..x_Root_Menu_Tbl.COUNT-1 LOOP