APPS.AMS_WFMOD_PVT dependencies on AMS_DM_SCORES_ALL_B

Line 1276: FROM ams_dm_scores_all_b

1272: l_target_positive_value NUMBER;
1273:
1274: CURSOR c_model (p_score_id IN NUMBER) IS
1275: SELECT model_id
1276: FROM ams_dm_scores_all_b
1277: WHERE score_id = p_score_id;
1278: BEGIN
1279: l_object_id := WF_ENGINE.GetItemAttrNumber(
1280: itemtype => itemtype

Line 2181: UPDATE ams_dm_scores_all_b

2177: last_update_login = FND_GLOBAL.conc_login_id
2178: WHERE model_id = p_object_id
2179: AND logs_flag = 'N';
2180: ELSE
2181: UPDATE ams_dm_scores_all_b
2182: SET logs_flag = 'Y',
2183: last_update_date = SYSDATE,
2184: last_updated_by = FND_GLOBAL.user_id,
2185: last_update_login = FND_GLOBAL.conc_login_id

Line 2384: FROM ams_dm_scores_all_b

2380: -- Cursor to get the wf_itemkey for a Scoring Run that is Building, Scoring or Previewing
2381: -- excluding the current wf_itemkey
2382: CURSOR c_scoreProcessing IS
2383: SELECT wf_itemkey
2384: FROM ams_dm_scores_all_b
2385: WHERE status_code = G_STATUS_SCORING
2386: OR status_code = G_STATUS_PREVIEWING
2387: AND wf_itemkey <> p_itemkey;
2388:

Line 2914: FROM ams_dm_models_all_b m , ams_dm_scores_all_b s

2910: ;
2911:
2912: CURSOR c_target_id_score (p_score_id IN NUMBER) IS
2913: SELECT m.target_id
2914: FROM ams_dm_models_all_b m , ams_dm_scores_all_b s
2915: WHERE m.model_id = s.model_id
2916: AND s.score_id = p_score_id
2917: ;
2918: