[Home] [Help]
367: -- delete from fem_
368: delete from fem_datasets_attr
369: where dataset_code in (
370: select dataset_code
371: from fem_datasets_b
372: where personal_flag = 'Y'
373: and created_by = p_user_id
374: );
375:
376: -- delete from fem_
377: delete from fem_datasets_tl
378: where dataset_code in (
379: select dataset_code
380: from fem_datasets_b
381: where personal_flag = 'Y'
382: and created_by = p_user_id
383: );
384:
382: and created_by = p_user_id
383: );
384:
385: -- delete from fem_
386: delete from fem_datasets_b
387: where personal_flag = 'Y'
388: and created_by = p_user_id;
389:
390: elsif (l_dimension_varchar_label = 'SOURCE_SYSTEM') then