171: order by cparty_code,security_name,deal_subtype;
172: --
173: CURSOR c_limit_control IS
174: SELECT substr(param_name,13) limit_check 175: FROM xtr_pro_param_v 176: WHERE param_name in ('LIMIT_CHECK_CPARTY','LIMIT_CHECK_GROUP','LIMIT_CHECK_SOVRN')
177: AND nvl(param_value,'N') = 'Y';
178: --
179: v_limit_check_type VARCHAR2(8);