525: -- delete from fem_
526: delete from fem_ln_items_attr
527: where line_item_id in (
528: select line_item_id
529: from fem_ln_items_b
530: where personal_flag = 'Y'
531: and created_by = p_user_id
532: );
533:
534: -- delete from fem_
535: delete from fem_ln_items_tl
536: where line_item_id in (
537: select line_item_id
538: from fem_ln_items_b
539: where personal_flag = 'Y'
540: and created_by = p_user_id
541: );
542:
540: and created_by = p_user_id
541: );
542:
543: -- delete from fem_
544: delete from fem_ln_items_b
545: where personal_flag = 'Y'
546: and created_by = p_user_id;
547:
548: elsif (l_dimension_varchar_label = 'PROJECT') then