APPS.AMS_LISTSOURCETYPE_PVT dependencies on AMS_DM_TARGETS_B

Line 510: DELETE FROM ams_dm_targets_b

506: CLOSE c_get_ds_targets;
507:
508: EXIT WHEN l_target_id IS NULL;
509:
510: DELETE FROM ams_dm_targets_b
511: WHERE target_id = l_target_id;
512:
513: DELETE FROM ams_dm_targets_tl
514: WHERE target_id = l_target_id;

Line 1197: FROM ams_dm_targets_b

1193: l_reference_rec c_reference%ROWTYPE;
1194:
1195: CURSOR c_target_exists (p_list_source_type_id IN NUMBER) IS
1196: SELECT 1
1197: FROM ams_dm_targets_b
1198: WHERE data_source_id = p_list_source_type_id
1199: AND active_flag = 'Y'
1200: ;
1201: