861: interface_table_name,
862: parent_level,
863: interface_table_id,
864: key_column_name
865: from ece_interface_tables
866: where transaction_type = p_transaction_type
867: and map_id = p_map_id
868: order by to_number(output_level);
869:
873: )
874: is
875: select to_number(eit.output_level) output_level
876: from ece_level_matrices elm,
877: ece_interface_tables eit
878: where elm.external_level_id = p_external_id
879: and eit.interface_table_id = elm.interface_table_id;
880:
881: cursor mapping_rec