APPS.AMS_LISTSOURCETYPE_PVT dependencies on AMS_DM_TARGETS_VL

Line 392: FROM AMS_DM_MODELS_VL m, AMS_DM_TARGETS_VL t

388:
389: -- Cursor to check if ANALYTICS data source is used in any models
390: CURSOR c_analytics_ds_used (l_id IN NUMBER) IS
391: SELECT count(*)
392: FROM AMS_DM_MODELS_VL m, AMS_DM_TARGETS_VL t
393: WHERE m.TARGET_ID = t.TARGET_ID
394: AND t.data_source_id = l_id;
395:
396: -- Cursor to get the target_ids associated with this data source

Line 399: FROM ams_dm_targets_vl t

395:
396: -- Cursor to get the target_ids associated with this data source
397: CURSOR c_get_ds_targets (l_id IN NUMBER) IS
398: SELECT target_id
399: FROM ams_dm_targets_vl t
400: WHERE t.data_source_id = l_id;
401:
402: BEGIN
403: --------------------- initialize -----------------------