APPS.AMS_DMSOURCE_PVT dependencies on AMS_DM_SCORES_ALL_B

Line 1001: 'ams_dm_scores_all_b',

997: END IF;
998: ELSIF p_source_rec.arc_used_for_object = 'SCOR' THEN
999: IF p_source_rec.used_for_object_id <> FND_API.g_miss_num THEN
1000: IF AMS_Utility_PVT.check_fk_exists(
1001: 'ams_dm_scores_all_b',
1002: 'score_id',
1003: p_source_rec.used_for_object_id
1004: ) = FND_API.g_false
1005: 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 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: