APPS.AMS_DM_SCORE_PVT dependencies on AMS_USER_STATUSES_VL

Line 420: FROM ams_user_statuses_vl

416: WHERE score_id = l_id;
417:
418: CURSOR c_status_code (p_user_status_id IN NUMBER) IS
419: SELECT system_status_code
420: FROM ams_user_statuses_vl
421: WHERE user_status_id = p_user_status_id;
422:
423: -- 22-Aug-2003 - nyostos
424: -- Changed cursor to retrieve custom_setup_id = 145 or 146 (for cue card menu

Line 761: FROM ams_user_statuses_vl

757: l_reference_rec c_reference%ROWTYPE;
758:
759: CURSOR c_status (p_id IN NUMBER) IS
760: SELECT system_status_code
761: FROM ams_user_statuses_vl
762: WHERE user_status_id = p_id;
763:
764: CURSOR c_target_id (p_score_id IN NUMBER) IS
765: SELECT m.target_id from ams_dm_models_all_b m,ams_dm_scores_all_b s