DBA Data[Home] [Help]

APPS.AMS_LIST_SRC_TYPES_NEW_PKG dependencies on DUAL

Line 415: SELECT 'Y' FROM DUAL

411: FROM AMS_LIST_SRC_TYPES
412: WHERE LIST_SOURCE_TYPE_ID = c_list_source_type_id);
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