APPS.AMS_SCORERESULT_PVT dependencies on AMS_DM_MODELS_ALL_B

Line 1458: FROM ams_dm_scores_all_b s, ams_dm_models_all_b m

1454: GROUP BY s.decile, s.score_result;
1455:
1456: CURSOR c_model_type (p_score_id IN NUMBER) IS
1457: SELECT m.model_type, m.model_id
1458: FROM ams_dm_scores_all_b s, ams_dm_models_all_b m
1459: WHERE s.score_id = p_score_id
1460: AND m.model_id = s.model_id;
1461:
1462: l_model_id NUMBER;

Line 1641: FROM AMS_DM_SCORES_ALL_B S, AMS_DM_MODELS_ALL_B M, AMS_DM_TARGETS_B T, AMS_LIST_SRC_TYPES L

1637: l_tab_ctr NUMBER;
1638:
1639: CURSOR c_ListSourceTypeCode IS
1640: SELECT L.SOURCE_TYPE_CODE, l.source_object_pk_field,T.target_id
1641: FROM AMS_DM_SCORES_ALL_B S, AMS_DM_MODELS_ALL_B M, AMS_DM_TARGETS_B T, AMS_LIST_SRC_TYPES L
1642: WHERE S.SCORE_ID = p_score_id
1643: AND S.MODEL_ID = M.MODEL_ID
1644: AND M.TARGET_ID = T.TARGET_ID
1645: AND T.DATA_SOURCE_ID = L.LIST_SOURCE_TYPE_ID;

Line 1825: FROM ams_dm_scores_all_b s, ams_dm_models_all_b m

1821: l_owner_user_id NUMBER;
1822:
1823: CURSOR c_model_type (p_score_id IN NUMBER) IS
1824: SELECT m.target_group_type, s.owner_user_id
1825: FROM ams_dm_scores_all_b s, ams_dm_models_all_b m
1826: WHERE s.score_id = p_score_id
1827: AND m.model_id = s.model_id;
1828: BEGIN
1829: OPEN c_model_type (p_score_id);