APPS.AMS_LIST_SRC_MAPPING dependencies on AMS_LIST_SRC_TYPES_VL

Line 52: SELECT source_type_code FROM ams_list_src_types_vl

48: WHERE list_source_type_id=p_src_id
49: ORDER BY LIST_SOURCE_FIELD_ID;
50:
51: CURSOR c_get_source_name(p_src_type_id number) is
52: SELECT source_type_code FROM ams_list_src_types_vl
53: where list_source_type_id = p_src_type_id ;
54:
55: CURSOR c_get_import_type(p_import_list_header_id number) is
56: SELECT import_type, b2b_flag

Line 63: FROM ams_list_src_types_vl

59: l_import_type c_get_import_type%ROWTYPE;
60:
61: CURSOR c_get_list_source_name(name VARCHAR2) IS
62: SELECT 1
63: FROM ams_list_src_types_vl
64: WHERE list_source_name=name;
65:
66: mapping_table dbms_utility.uncl_array;
67: l_no_of_rows number;