925: -- delete from fem_
926: delete from fem_user_dim10_attr
927: where user_dim10_id in (
928: select user_dim10_id
929: from fem_user_dim10_b
930: where personal_flag = 'Y'
931: and created_by = p_user_id
932: );
933:
934: -- delete from fem_
935: delete from fem_user_dim10_tl
936: where user_dim10_id in (
937: select user_dim10_id
938: from fem_user_dim10_b
939: where personal_flag = 'Y'
940: and created_by = p_user_id
941: );
942:
940: and created_by = p_user_id
941: );
942:
943: -- delete from fem_
944: delete from fem_user_dim10_b
945: where personal_flag = 'Y'
946: and created_by = p_user_id;
947:
948: else