DBA Data[Home] [Help]

APPS.OKE_K_ACCESS_RULES_PKG2 dependencies on OKE_ATTRIBUTE_GROUPS_V

Line 318: , oke_attribute_groups_v ag

314: , L_login_id
315: , kar.access_level
316: , kar.access_rule_id
317: FROM oke_k_access_rules kar
318: , oke_attribute_groups_v ag
319: WHERE kar.role_id = X_Role_ID
320: AND kar.attribute_group_code IS NULL
321: AND kar.attribute_code IS NULL
322: ANd ag.attribute_group_type = 'USER'

Line 360: FROM oke_attribute_groups_v ag

356: , sysdate
357: , L_user_id
358: , L_login_id
359: , L_def_access_level
360: FROM oke_attribute_groups_v ag
361: WHERE ag.attribute_group_type = 'USER'
362: AND NOT EXISTS (
363: SELECT null
364: FROM oke_compiled_access_rules

Line 380: FROM oke_attribute_groups_v ag

376: , sysdate
377: , L_user_id
378: , L_login_id
379: , L_def_access_level
380: FROM oke_attribute_groups_v ag
381: WHERE ag.attribute_group_type = 'USER'
382: AND NOT EXISTS (
383: SELECT null
384: FROM oke_compiled_access_rules