APPS.AMS_LIST_SRC_TYPES_NEW_PKG dependencies on AMS_DM_TARGET_SOURCES

Line 420: SELECT 1 FROM AMS_DM_TARGET_SOURCES

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 );
422:
423: CURSOR QRY_TEMPL_CUR(c_list_source_type_id IN NUMBER) IS
424: SELECT 'Y' FROM AMS_QUERY_TEMPLATE_ALL