168: Begin
169:
170: begin
171: SELECT ccid INTO l_cc_id
172: FROM fun_inter_accounts
173: WHERE from_le_id = p_from_le_id
174: AND to_le_id = p_to_le_id
175: AND type = p_type
176: AND rownum = 1
177: ORDER by default_flag;
178: exception
179: when no_data_found then
180: SELECT ccid INTO l_cc_id
181: FROM fun_inter_accounts
182: WHERE from_le_id = p_from_le_id
183: AND to_le_id = -99
184: AND type = p_type
185: AND rownum = 1