[Home] [Help]
491: -- Check IF Table is used as a Part Of Transaction Source.
492: --
493: SELECT COUNT(*)
494: INTO l_dest_count
495: FROM cn_table_maps_all
496: WHERE source_table_id = p_table_rec.object_id
497: and org_id=p_table_rec.org_id;
498:
499: SELECT COUNT(*)
497: and org_id=p_table_rec.org_id;
498:
499: SELECT COUNT(*)
500: INTO l_sorc_count
501: FROM cn_table_maps_all
502: WHERE destination_table_id = p_table_rec.object_id
503: and org_id=p_table_rec.org_id;
504: --
505: -- IF Yes, Do Not Allow User To Delete That Table