APPS.AMS_SCORERESULT_PVT dependencies on AMS_DM_SCORES_ALL_B

Line 849: 'ams_dm_scores_all_b',

845: x_return_status := FND_API.g_ret_sts_success;
846:
847: IF p_scoreresult_rec.score_id <> FND_API.g_miss_num THEN
848: IF AMS_Utility_PVT.check_fk_exists (
849: 'ams_dm_scores_all_b',
850: 'score_id',
851: p_scoreresult_rec.score_id
852: ) = FND_API.g_false THEN
853: AMS_Utility_PVT.error_message ('AMS_SCORRES_BAD_SCORE_ID');

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 1654: FROM AMS_DM_SCORES_ALL_B

1650: WHERE model_id=p_model_id;
1651:
1652: CURSOR c_model_id(p_scor_id IN NUMBER) IS
1653: SELECT model_id
1654: FROM AMS_DM_SCORES_ALL_B
1655: WHERE score_id=p_scor_id;
1656:
1657: l_model_type VARCHAR2(30);
1658: l_is_b2b BOOLEAN := FALSE;

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);