DBA Data[Home] [Help]

APPS.CN_SYS_TABLES_PVT dependencies on CN_TABLE_MAPS_ALL

Line 494: FROM cn_table_maps_all

490: -- Check IF Table is used as a Part Of Transaction Source.
491: --
492: SELECT COUNT(*)
493: INTO l_dest_count
494: FROM cn_table_maps_all
495: WHERE source_table_id = p_table_rec.object_id
496: and org_id=p_table_rec.org_id;
497:
498: SELECT COUNT(*)

Line 500: FROM cn_table_maps_all

496: and org_id=p_table_rec.org_id;
497:
498: SELECT COUNT(*)
499: INTO l_sorc_count
500: FROM cn_table_maps_all
501: WHERE destination_table_id = p_table_rec.object_id
502: and org_id=p_table_rec.org_id;
503: --
504: -- IF Yes, Do Not Allow User To Delete That Table