850: -- delete from fem_
851: delete from fem_user_dim7_attr
852: where user_dim7_id in (
853: select user_dim7_id
854: from fem_user_dim7_b
855: where personal_flag = 'Y'
856: and created_by = p_user_id
857: );
858:
859: -- delete from fem_
860: delete from fem_user_dim7_tl
861: where user_dim7_id in (
862: select user_dim7_id
863: from fem_user_dim7_b
864: where personal_flag = 'Y'
865: and created_by = p_user_id
866: );
867:
865: and created_by = p_user_id
866: );
867:
868: -- delete from fem_
869: delete from fem_user_dim7_b
870: where personal_flag = 'Y'
871: and created_by = p_user_id;
872:
873: elsif (l_dimension_varchar_label = 'USER_DIM8') then