DBA Data[Home] [Help]

APPS.BIS_FN_SECURITY dependencies on FND_RESPONSIBILITY

Line 27: FROM fnd_responsibility

23: 'M', me.sub_menu_id, null);
24:
25: CURSOR CR IS
26: SELECT menu_id
27: FROM fnd_responsibility
28: WHERE responsibility_id = p_responsibility_id
29: AND start_date <= sysdate
30: AND (nvl(end_date, sysdate) >= sysdate);
31:

Line 33: TYPE t_Menu_Tbl_Type IS TABLE OF fnd_responsibility.menu_id%TYPE

29: AND start_date <= sysdate
30: AND (nvl(end_date, sysdate) >= sysdate);
31:
32:
33: TYPE t_Menu_Tbl_Type IS TABLE OF fnd_responsibility.menu_id%TYPE
34: INDEX BY BINARY_INTEGER;
35:
36: l_menu_tbl t_Menu_Tbl_Type;
37: l_add_index BINARY_INTEGER:= 0;