APPS.AMS_DM_MODEL_PVT dependencies on AMS_DM_TARGETS_B

Line 1621: 'ams_dm_targets_b',

1617:
1618: --------------------- target_id ------------------------
1619: IF p_dm_model_rec.target_id <> FND_API.g_miss_num THEN
1620: IF AMS_Utility_PVT.check_fk_exists(
1621: 'ams_dm_targets_b',
1622: 'target_id',
1623: p_dm_model_rec.target_id
1624: ) = FND_API.g_false
1625: THEN

Line 3231: FROM ams_dm_models_all_b m,ams_dm_targets_b t

3227: ;
3228: --start changes rosharma 20-aug-2003 bug 3104201
3229: CURSOR c_data_source (p_model_id IN NUMBER) IS
3230: SELECT t.DATA_SOURCE_ID
3231: FROM ams_dm_models_all_b m,ams_dm_targets_b t
3232: WHERE m.model_id = p_model_id
3233: AND m.target_id = t.target_id
3234: ;
3235:

Line 4124: FROM ams_dm_models_all_b m, ams_dm_targets_b t

4120: L_API_NAME CONSTANT VARCHAR2(30) := 'handle_data_source_changes';
4121:
4122: CURSOR c_models_using_datasource IS
4123: SELECT m.model_id, m.status_code
4124: FROM ams_dm_models_all_b m, ams_dm_targets_b t
4125: WHERE m.target_id = t.target_id
4126: AND t.data_source_id = p_datasource_id
4127: UNION
4128: SELECT m.model_id, m.status_code

Line 4129: FROM ams_dm_models_all_b m, ams_dm_targets_b t, ams_dm_target_sources s

4125: WHERE m.target_id = t.target_id
4126: AND t.data_source_id = p_datasource_id
4127: UNION
4128: SELECT m.model_id, m.status_code
4129: FROM ams_dm_models_all_b m, ams_dm_targets_b t, ams_dm_target_sources s
4130: WHERE m.target_id = t.target_id
4131: AND s.target_id = t.target_id
4132: AND s.data_source_id = p_datasource_id;
4133: