DBA Data[Home] [Help]

APPS.EC_DOCUMENT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 190

select  parameter_id        parm_id,
	name                parm_name,
        datatype    	parm_datatype,
        default_value
  from    ece_tran_parameters
 where   transaction_type = p_transaction_type
order by parameter_id, sequence_number;
Line: 199

select map_id, map_type from ece_mappings
where ece_mappings.transaction_type = p_transaction_type;
Line: 254

	ec_utils.g_stack.DELETE;
Line: 313

		select ece_output_runs_s.NEXTVAL INTO i_file_id
		FROM DUAL;
Line: 400

	m_parm_tmp_tbl.DELETE;