APPS.XNP_MSG_SCHEMA SQL Statements

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

Line: 29

		SELECT met.name,
			met.msg_element_id,
			met.parameter_flag,
			mse.data_source,
			mse.data_source_type,
			mse.data_source_reference
		FROM xnp_msg_elements met, xnp_msg_structures mse
		WHERE met.msg_code = mse.msg_code
		AND met.msg_code = p_msg_code
                -- skilaru 03/27/2001
		-- AND met.msg_element_id IN( mse.child_element_id);

Line: 286

		SELECT object_name FROM user_objects
		WHERE object_name = p_msg_code
		AND OBJECT_TYPE <> 'SYNONYM';

Line: 316

		--SELECT * FROM xnp_msg_structures
		SELECT 'Y' FROM xnp_msg_structures
		WHERE parent_element_id = p_element_id ;

Line: 351

		SELECT lookup_code FROM CSI_LOOKUPS
		WHERE lookup_code = l_parameter_name
                AND lookup_type = 'CSI_EXTEND_ATTRIB_POOL';