APPS.AK_FLOW3_PVT dependencies on AK_REGIONS

Line 615: -- Check that the region exists in AK_REGIONS

611: end if;
612: end if;
613:
614: --
615: -- Check that the region exists in AK_REGIONS
616: --
617: if (NOT AK_REGION_PVT.REGION_EXISTS (
618: p_api_version_number => 1.0,
619: p_return_status => l_return_status,

Line 1276: ak_regions ar1, ak_regions ar2

1272: ) return BOOLEAN is
1273: cursor l_check_fk_connect_csr is
1274: select 1
1275: from ak_foreign_keys fk, ak_unique_keys uk,
1276: ak_regions ar1, ak_regions ar2
1277: where fk.database_object_name = ar1.database_object_name
1278: and fk.unique_key_name = uk.unique_key_name
1279: and uk.database_object_name = ar2.database_object_name
1280: and ar1.region_application_id = p_from_region_appl_id

Line 1288: ak_regions ar1, ak_regions ar2

1284: and fk.foreign_key_name = p_foreign_key_name
1285: UNION
1286: select 1
1287: from ak_foreign_keys fk, ak_unique_keys uk,
1288: ak_regions ar1, ak_regions ar2
1289: where fk.database_object_name = ar2.database_object_name
1290: and fk.unique_key_name = uk.unique_key_name
1291: and uk.database_object_name = ar1.database_object_name
1292: and ar1.region_application_id = p_from_region_appl_id