DBA Data[Home] [Help]

APPS.AK_FLOW3_PVT dependencies on AK_UNIQUE_KEYS

Line 1275: from ak_foreign_keys fk, ak_unique_keys uk,

1271: p_pass IN NUMBER := 2
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

Line 1287: from ak_foreign_keys fk, ak_unique_keys uk,

1283: and ar2.region_code = p_to_region_code
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