DBA Data[Home] [Help]

APPS.CN_SYS_TABLES_PVT dependencies on CN_TABLE_MAPS_ALL

Line 495: FROM cn_table_maps_all

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(*)

Line 501: FROM cn_table_maps_all

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