APPS.AMS_LIST_SRC_MAPPING dependencies on AMS_IMP_COL_MAPPING

Line 75: --FROM ams_imp_col_mapping ai

71:
72: --cursor c_count_import(cur_source_type_id number,
73: -- cur_table_name varchar2) is
74: --SELECT COUNT(1)
75: --FROM ams_imp_col_mapping ai
76: --WHERE ai.required_flag = 'Y'
77: --AND ai.table_name = cur_table_name
78: --AND NOT EXISTS ( SELECT 'x'
79: -- FROM ams_list_src_fields al

Line 102: --FROM ams_imp_col_mapping ai

98:
99: --CURSOR c_required_field_id (p_source_type_id NUMBER,
100: -- p_table_name VARCHAR2) IS
101: --SELECT ai.COL_MAPPING_ID
102: --FROM ams_imp_col_mapping ai
103: --WHERE ai.required_flag = 'Y'
104: --AND ai.table_name = p_table_name
105: --AND ai.column_name NOT IN ( SELECT al.field_column_name
106: -- FROM ams_list_src_fields al

Line 314: from ams_imp_col_mapping

310: loop
311: begin
312: select column_name
313: into l_list_target_fields(i)
314: from ams_imp_col_mapping
315: where table_name = p_table_name
316: and meaning = p_list_target_fields(i) ;
317: exception
318: when no_data_found then

Line 333: -- from ams_imp_col_mapping

329: --loop
330: -- begin
331: -- select column_name
332: -- into l_list_target_fields(i)
333: -- from ams_imp_col_mapping
334: -- where table_name = p_table_name
335: -- and meaning = p_list_target_fields(i) ;
336: -- exception
337: -- when no_data_found then