APPS.AMS_LISTSOURCETYPE_PVT dependencies on AMS_DM_TARGETS_B

Line 508: DELETE FROM ams_dm_targets_b

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

Line 1195: FROM ams_dm_targets_b

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