APPS.AMS_DMSELECTION_PVT dependencies on AMS_DM_SCORES_VL

Line 846: WHERE model_id=(select model_id from ams_dm_scores_vl where score_id=p_scor_id)

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;
850: l_target_id NUMBER;