53: where route_name = p_route_name;
54:
55: cursor cur_ff_routes_s is
56: select ff_routes_s.nextval
57: from dual;
58:
59: l_route_id ff_routes.route_id%TYPE;
60:
61: begin
133: and legislation_code = 'CA';
134:
135: cursor cur_user_entity_id is
136: select ff_user_entities_s.nextval
137: from dual;
138:
139: l_user_entity_id number;
140: l_creator_type ff_user_entities.creator_type%TYPE;
141: begin
217: and parameter_name = p_parameter_name;
218:
219: cursor cur_route_parameters is
220: select ff_route_parameters_s.nextval
221: from dual;
222:
223: l_route_parameter_id ff_route_parameters.route_parameter_id%TYPE;
224: begin
225: