APPS.AMS_LIST_SRC_TYPES_NEW_PKG dependencies on AMS_DM_TARGETS_VL

Line 417: SELECT 1 FROM AMS_DM_TARGETS_VL

413:
414: CURSOR TARGET_CUR(c_list_source_type_id IN NUMBER) IS
415: SELECT 'Y' FROM DUAL
416: WHERE EXISTS (
417: SELECT 1 FROM AMS_DM_TARGETS_VL
418: WHERE DATA_SOURCE_ID = c_list_source_type_id
419: UNION
420: SELECT 1 FROM AMS_DM_TARGET_SOURCES
421: WHERE DATA_SOURCE_ID = c_list_source_type_id );