DBA Data[Home] [Help]

APPS.AMS_LIST_SRC_TYPES_NEW_PKG dependencies on AMS_LIST_RULES_ALL

Line 430: SELECT 'Y' FROM AMS_LIST_RULES_ALL

426: FROM AMS_LIST_SRC_TYPES
427: WHERE LIST_SOURCE_TYPE_ID = c_list_source_type_id);
428:
429: CURSOR DEDUP_CUR(c_list_source_type_id IN NUMBER) IS
430: SELECT 'Y' FROM AMS_LIST_RULES_ALL
431: WHERE LIST_SOURCE_TYPE = (SELECT SOURCE_TYPE_CODE
432: FROM AMS_LIST_SRC_TYPES
433: WHERE LIST_SOURCE_TYPE_ID = c_list_source_type_id);
434: