APPS.AMS_WFMOD_PVT dependencies on AMS_DM_SCORES_VL

Line 313: FROM ams_dm_scores_vl score

309: ;
310:
311: CURSOR c_get_score_owner(p_obj_id NUMBER) IS
312: SELECT score.owner_user_id
313: FROM ams_dm_scores_vl score
314: WHERE score_id = p_obj_id
315: ;
316:
317: l_owner_user_id NUMBER;

Line 605: FROM ams_dm_models_all_b model, ams_dm_scores_vl score, ams_dm_targets_b target

601: , score.score_name
602: , score.status_code
603: , score.owner_user_id
604: , target.active_flag
605: FROM ams_dm_models_all_b model, ams_dm_scores_vl score, ams_dm_targets_b target
606: WHERE score_id = p_obj_id
607: AND score.model_id = model.model_id
608: AND target.target_id = model.target_id
609: ;