750: -- delete from fem_
751: delete from fem_user_dim3_attr
752: where user_dim3_id in (
753: select user_dim3_id
754: from fem_user_dim3_b
755: where personal_flag = 'Y'
756: and created_by = p_user_id
757: );
758:
759: -- delete from fem_
760: delete from fem_user_dim3_tl
761: where user_dim3_id in (
762: select user_dim3_id
763: from fem_user_dim3_b
764: where personal_flag = 'Y'
765: and created_by = p_user_id
766: );
767:
765: and created_by = p_user_id
766: );
767:
768: -- delete from fem_
769: delete from fem_user_dim3_b
770: where personal_flag = 'Y'
771: and created_by = p_user_id;
772:
773: elsif (l_dimension_varchar_label = 'USER_DIM4') then