APPS.BISM_ACCESS_CONTROL dependencies on BISM_GROUPS

Line 18: select group_id from bism_groups where user_id = myid

14:
15: select max(privilege) into priv from bism_permissions where
16: object_id = fid and subject_id in
17: (
18: select group_id from bism_groups where user_id = myid
19: );
20:
21: if priv is null then
22: begin

Line 54: select group_id from bism_groups where user_id = myid

50: -- or an object - it does not matter)
51: select max(privilege) into priv from bism_permissions where
52: object_id = fid and subject_id in
53: (
54: select group_id from bism_groups where user_id = myid
55: );
56:
57: if priv is null then
58: begin

Line 96: select group_id from bism_groups where user_id = curr_user_id

92:
93: select max(privilege) into priv from bism_permissions where
94: object_id = thisid and subject_id in
95: (
96: select group_id from bism_groups where user_id = curr_user_id
97: );
98:
99: if priv is null then
100: begin

Line 140: select group_id from bism_groups where user_id = curr_user_id

136:
137: select max(privilege) into priv from bism_permissions where
138: object_id = tempid and subject_id in
139: (
140: select group_id from bism_groups where user_id = curr_user_id
141: );
142:
143: if priv is null then
144: begin

Line 188: select group_id from bism_groups where user_id = curr_user_id

184:
185: select max(privilege) into priv from bism_permissions
186: where object_id = tempid and subject_id in
187: (
188: select group_id from bism_groups where user_id = curr_user_id
189: );
190:
191:
192: if priv is null then

Line 225: select group_id from bism_groups where user_id = myid

221: -- this function mus be called only on a folder
222: select max(privilege) into priv from bism_permissions where
223: object_id = oid and subject_id in
224: (
225: select group_id from bism_groups where user_id = myid
226: );
227:
228: if priv is null then
229: begin

Line 264: select group_id from bism_groups where user_id = myid

260:
261: select max(privilege) into priv from bism_permissions where
262: object_id = oid and subject_id in
263: (
264: select group_id from bism_groups where user_id = myid
265: );
266:
267: if priv is null then
268: begin