APPS.BSC_SCORECARD_PUB dependencies on BSC_USER_TAB_ACCESS

Line 497: FROM bsc_user_tab_access

493:
494: FOR CD IN c_Resp_Ids LOOP
495: SELECT COUNT(1)
496: INTO l_Count
497: FROM bsc_user_tab_access
498: WHERE tab_id = p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id
499: AND responsibility_id = CD.responsibility_id;
500: --dbms_output.put_line(' resp id :-' || CD.responsibility_id);
501: l_Bsc_Tab_Entity_Rec.Bsc_Responsibility_Id := CD.responsibility_id;

Line 999: FROM bsc_user_tab_access

995: AND e.function_id = l_function_id;
996:
997: SELECT COUNT(1)
998: INTO l_resp_count
999: FROM bsc_user_tab_access
1000: WHERE tab_id = p_tab_id
1001: AND responsibility_id =l_resp_id
1002: AND (SYSDATE BETWEEN NVL(start_date, SYSDATE) AND NVL(end_date, SYSDATE));
1003: --Scorecard security is both at user , responsibility levels