550: -- delete from fem_
551: delete from fem_projects_attr
552: where project_id in (
553: select project_id
554: from fem_projects_b
555: where personal_flag = 'Y'
556: and created_by = p_user_id
557: );
558:
559: -- delete from fem_
560: delete from fem_projects_tl
561: where project_id in (
562: select project_id
563: from fem_projects_b
564: where personal_flag = 'Y'
565: and created_by = p_user_id
566: );
567:
565: and created_by = p_user_id
566: );
567:
568: -- delete from fem_
569: delete from fem_projects_b
570: where personal_flag = 'Y'
571: and created_by = p_user_id;
572:
573: elsif (l_dimension_varchar_label = 'CUSTOMER') then