APPS.AMS_DMSELECTION_PVT dependencies on AMS_DM_MODELS_VL

Line 839: FROM ams_dm_models_vl

835: ;
836:
837: CURSOR c_model_type(p_model_id IN NUMBER) is
838: SELECT model_type
839: FROM ams_dm_models_vl
840: WHERE model_id=p_model_id
841: ;
842:
843: CURSOR c_model_type_scor(p_scor_id IN NUMBER) is

Line 845: FROM ams_dm_models_vl

841: ;
842:
843: CURSOR c_model_type_scor(p_scor_id IN NUMBER) is
844: SELECT model_id, model_type
845: FROM ams_dm_models_vl
846: WHERE model_id=(select model_id from ams_dm_scores_vl where score_id=p_scor_id)
847: ;
848:
849: l_data_source_id NUMBER;

Line 1241: FROM ams_dm_models_vl

1237: IS
1238:
1239: CURSOR c_model_type(p_model_id IN NUMBER) is
1240: SELECT model_type
1241: FROM ams_dm_models_vl
1242: WHERE model_id=p_model_id
1243: ;
1244:
1245: CURSOR c_model_id (p_score_id IN NUMBER) IS

Line 1465: FROM ams_dm_models_vl

1461: ;
1462:
1463: CURSOR c_model_type(p_model_id IN NUMBER) is
1464: SELECT model_type
1465: FROM ams_dm_models_vl
1466: WHERE model_id=p_model_id
1467: ;
1468:
1469: l_total_records NUMBER := 0;