825: -- delete from fem_
826: delete from fem_user_dim6_attr
827: where user_dim6_id in (
828: select user_dim6_id
829: from fem_user_dim6_b
830: where personal_flag = 'Y'
831: and created_by = p_user_id
832: );
833:
834: -- delete from fem_
835: delete from fem_user_dim6_tl
836: where user_dim6_id in (
837: select user_dim6_id
838: from fem_user_dim6_b
839: where personal_flag = 'Y'
840: and created_by = p_user_id
841: );
842:
840: and created_by = p_user_id
841: );
842:
843: -- delete from fem_
844: delete from fem_user_dim6_b
845: where personal_flag = 'Y'
846: and created_by = p_user_id;
847:
848: elsif (l_dimension_varchar_label = 'USER_DIM7') then