APPS.AMS_DMSOURCE_PVT dependencies on AMS_DM_MODELS_ALL_B

Line 986: 'ams_dm_models_all_b',

982: --------------------used_for_object_id---------------------------
983: IF p_source_rec.arc_used_for_object = 'MODL' THEN
984: IF p_source_rec.used_for_object_id <> FND_API.g_miss_num THEN
985: IF AMS_Utility_PVT.check_fk_exists(
986: 'ams_dm_models_all_b',
987: 'model_id',
988: p_source_rec.used_for_object_id
989: ) = FND_API.g_false
990: THEN

Line 1344: FROM ams_dm_scores_all_b s, ams_dm_models_all_b m

1340: FROM V$DATABASE;
1341:
1342: CURSOR c_target_positive_value (p_score_id IN NUMBER) IS
1343: SELECT m.target_positive_value
1344: FROM ams_dm_scores_all_b s, ams_dm_models_all_b m
1345: WHERE s.model_id = m.model_id
1346: AND s.score_id = p_score_id;
1347: BEGIN
1348:

Line 1572: FROM ams_dm_models_all_b model

1568: --SOURCE_OBJECT_ALIAS VARCHAR2(2) := 'ds';
1569:
1570: CURSOR c_target_model (p_model_id IN NUMBER) IS
1571: SELECT model.target_id
1572: FROM ams_dm_models_all_b model
1573: WHERE model.model_id = p_model_id
1574: ;
1575:
1576: CURSOR c_target_score (p_score_id IN NUMBER) IS

Line 1578: FROM ams_dm_scores_all_b score, ams_dm_models_all_b model

1574: ;
1575:
1576: CURSOR c_target_score (p_score_id IN NUMBER) IS
1577: SELECT model.target_id,model.model_id
1578: FROM ams_dm_scores_all_b score, ams_dm_models_all_b model
1579: WHERE model.model_id = score.model_id
1580: AND score.score_id = p_score_id
1581: ;
1582: