APPS.AMS_DMSOURCE_PVT dependencies on AMS_DM_SOURCE_S

Line 309: SELECT AMS_dm_source_s.NEXTVAL

305: l_SOURCE_ID NUMBER;
306: l_dummy NUMBER;
307:
308: CURSOR c_id IS
309: SELECT AMS_dm_source_s.NEXTVAL
310: FROM dual;
311:
312: CURSOR c_id_exists (l_id IN NUMBER) IS
313: SELECT 1 FROM dual

Line 1432: UPDATE ams_dm_source s

1428: OPEN c_target_positive_value (p_score_id);
1429: FETCH c_target_positive_value INTO l_target_positive_value;
1430: CLOSE c_target_positive_value;
1431:
1432: UPDATE ams_dm_source s
1433: SET (score_result, confidence, continuous_score) = (SELECT score, probability * 100, DECODE (score, l_target_positive_value, probability, 1 - probability) * 100
1434: -- FROM ams_dm_apply_stg stg
1435: FROM ams_dm_apply_stg_gt stg
1436: WHERE stg.source_id = s.source_id)

Line 2364: x_from_clause := ' FROM ' || l_ams_schema || '.ams_dm_source s, ';

2360: l_industry,
2361: l_ams_schema
2362: );
2363:
2364: x_from_clause := ' FROM ' || l_ams_schema || '.ams_dm_source s, ';
2365: x_from_clause := x_from_clause || l_object_name_full;
2366: IF l_model_type = 'CUSTOMER_PROFITABILITY' AND l_is_b2b AND l_is_seeded THEN
2367: x_where_clause := ' WHERE s.party_id = ' || l_object_name || '.ORGANIZATION_ID';
2368: ELSE