DBA Data[Home] [Help]

APPS.AMS_LIST_SRC_TYPES_NEW_PKG dependencies on AMS_QUERY_TEMPLATE_ALL

Line 424: SELECT 'Y' FROM AMS_QUERY_TEMPLATE_ALL

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
425: WHERE LIST_SRC_TYPE = ( SELECT SOURCE_TYPE_CODE
426: FROM AMS_LIST_SRC_TYPES
427: WHERE LIST_SOURCE_TYPE_ID = c_list_source_type_id);
428: