APPS.OKE_K_ACCESS_RULES_PKG2 dependencies on OKE_OBJECT_ATTRIBUTES_B

Line 84: , oke_object_attributes_b oa

80: )
81: , kar.access_rule_id
82: , oap.form_item_flag
83: FROM oke_k_access_rules kar
84: , oke_object_attributes_b oa
85: , oke_object_attributes_b oap
86: WHERE kar.role_id = X_Role_ID
87: AND kar.attribute_code is not null
88: AND oa.database_object_name = kar.secured_object_name

Line 85: , oke_object_attributes_b oap

81: , kar.access_rule_id
82: , oap.form_item_flag
83: FROM oke_k_access_rules kar
84: , oke_object_attributes_b oa
85: , oke_object_attributes_b oap
86: WHERE kar.role_id = X_Role_ID
87: AND kar.attribute_code is not null
88: AND oa.database_object_name = kar.secured_object_name
89: AND oa.attribute_code = kar.attribute_code

Line 133: , oke_object_attributes_b oa

129: )
130: , kar.access_rule_id
131: , oap.form_item_flag
132: FROM oke_k_access_rules kar
133: , oke_object_attributes_b oa
134: , oke_object_attributes_b oap
135: WHERE kar.role_id = X_Role_ID
136: AND kar.attribute_code is null
137: AND oa.database_object_name = kar.secured_object_name

Line 134: , oke_object_attributes_b oap

130: , kar.access_rule_id
131: , oap.form_item_flag
132: FROM oke_k_access_rules kar
133: , oke_object_attributes_b oa
134: , oke_object_attributes_b oap
135: WHERE kar.role_id = X_Role_ID
136: AND kar.attribute_code is null
137: AND oa.database_object_name = kar.secured_object_name
138: AND oa.attribute_group_code = kar.attribute_group_code

Line 187: , oke_object_attributes_b oa

183: )
184: , kar.access_rule_id
185: , oap.form_item_flag
186: FROM oke_k_access_rules kar
187: , oke_object_attributes_b oa
188: , oke_object_attributes_b oap
189: WHERE kar.role_id = X_Role_ID
190: AND kar.secured_object_name = oa.database_object_name
191: AND kar.attribute_group_code IS NULL

Line 188: , oke_object_attributes_b oap

184: , kar.access_rule_id
185: , oap.form_item_flag
186: FROM oke_k_access_rules kar
187: , oke_object_attributes_b oa
188: , oke_object_attributes_b oap
189: WHERE kar.role_id = X_Role_ID
190: AND kar.secured_object_name = oa.database_object_name
191: AND kar.attribute_group_code IS NULL
192: AND kar.attribute_code IS NULL

Line 231: FROM oke_object_attributes_b oa

227: , L_user_id
228: , L_login_id
229: , L_def_access_level
230: , oap.form_item_flag
231: FROM oke_object_attributes_b oa
232: , oke_object_attributes_b oap
233: WHERE oa.database_object_name in ( 'OKE_K_HEADERS'
234: , 'OKE_K_LINES'
235: , 'OKE_K_DELIVERABLES' )

Line 232: , oke_object_attributes_b oap

228: , L_login_id
229: , L_def_access_level
230: , oap.form_item_flag
231: FROM oke_object_attributes_b oa
232: , oke_object_attributes_b oap
233: WHERE oa.database_object_name in ( 'OKE_K_HEADERS'
234: , 'OKE_K_LINES'
235: , 'OKE_K_DELIVERABLES' )
236: AND oap.database_object_name = oa.database_object_name