APPS.AMS_WFMOD_PVT dependencies on AMS_DM_MODELS_V

Line 307: FROM ams_dm_models_vl model

303:
304:
305: CURSOR c_get_model_owner(p_obj_id NUMBER) IS
306: SELECT owner_user_id
307: FROM ams_dm_models_vl model
308: WHERE model_id = p_obj_id
309: ;
310:
311: CURSOR c_get_score_owner(p_obj_id NUMBER) IS

Line 592: FROM ams_dm_models_vl model, ams_dm_targets_b target

588: , model_name
589: , status_code
590: , owner_user_id
591: , target.active_flag
592: FROM ams_dm_models_vl model, ams_dm_targets_b target
593: WHERE model_id = p_obj_id
594: AND target.target_id = model.target_id
595: ;
596:

Line 1019: FROM ams_dm_models_v

1015: l_seeded_data_source BOOLEAN := FALSE;
1016:
1017: CURSOR c_target_id_model (p_model_id IN NUMBER) IS
1018: SELECT target_id
1019: FROM ams_dm_models_v
1020: WHERE model_id = p_model_id
1021: ;
1022:
1023: CURSOR c_target_id_score (p_score_id IN NUMBER) IS

Line 1025: FROM ams_dm_models_v model , ams_dm_scores_v score

1021: ;
1022:
1023: CURSOR c_target_id_score (p_score_id IN NUMBER) IS
1024: SELECT model.target_id
1025: FROM ams_dm_models_v model , ams_dm_scores_v score
1026: WHERE score.score_id = p_score_id
1027: AND score.model_id = model.model_id
1028: ;
1029: