[Home] [Help]
162: where param_name = pc3_param_name;
163: --
164: cursor c_date_restr is
165: select range
166: from XTR_TIME_RESTRICTIONS
167: where deal_type = p_deal_type
168: and (cparty_code like p_cparty_code or cparty_code is null)
169: and (deal_subtype like p_deal_subtype or deal_subtype is null)
170: and (security_name like p_product_type or security_name is null)