[Home] [Help]
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:
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;