APPS.ECE_FLATFILE_PVT dependencies on ECE_INTERFACE_TABLES

Line 34: FROM ece_interface_tables

30: n_record_count NUMBER := 0;
31:
32: CURSOR c_tran_attribute IS
33: SELECT key_column_name
34: FROM ece_interface_tables
35: WHERE transaction_type = p_transaction_type AND
36: key_column_name IS NOT NULL
37: ORDER BY output_level;
38:

Line 115: ece_interface_tables eit

111: eic.interface_column_id int_col_id,
112: eic.width width,
113: eic.data_type col_type
114: FROM ece_interface_columns eic,
115: ece_interface_tables eit
116: WHERE eit.transaction_type = cTransaction_Type AND
117: eit.interface_table_name = cInterface_Table AND
118: eit.output_level = NVL(p_output_level,eit.output_level) AND
119: eit.interface_table_id = eic.interface_table_id AND

Line 224: FROM ece_interface_tables eit

220: SELECT eit.extension_table_name, -- select extension table name
221: eit.key_column_name
222: INTO cExtension_Table,
223: p_common_key_name
224: FROM ece_interface_tables eit
225: WHERE eit.transaction_type = cTransaction_Type AND
226: eit.interface_table_name = cInterface_Table AND
227: eit.map_id = iMap_ID AND
228: eit.output_level = NVL(p_output_level,eit.output_level);

Line 786: ece_interface_tables eit

782: eic.record_layout_code,
783: eic.record_layout_qualifier,
784: eic.column_name ext_column_name
785: FROM ece_interface_columns eic,
786: ece_interface_tables eit
787: WHERE eit.transaction_type = cTransaction_type AND
788: eit.interface_table_name = cInt_tbl_name AND
789: eic.interface_table_id = eit.interface_table_id AND
790: eit.output_level = NVL(cOutput_level,eit.output_level) AND