184: -- Last, Delete Personal Attributes
185: delete from fem_dim_attr_versions_tl avt
186: where exists (
187: select null
188: from fem_dim_attr_versions_b avb
189: ,fem_dim_attributes_b ab
190: where avb.version_id = avt.version_id
191: --and avb.personal_flag = 'Y'
192: --and avb.created_by = l_user_id
195: and ab.personal_flag = 'Y'
196: and ab.created_by = l_user_id
197: );
198:
199: delete from fem_dim_attr_versions_b
200: --where personal_flag = 'Y'
201: --and created_by = l_user_id
202: where attribute_id in (
203: select attribute_id