125: sequence_no)
126: select l_route_id,
127: FFC.context_id,
128: 1
129: from ff_contexts FFC
130: where context_name = p_context_name1;
131: --
132: END IF;
133: --
139: sequence_no)
140: select l_route_id,
141: FFC.context_id,
142: 2
143: from ff_contexts FFC
144: where context_name = p_context_name2;
145: --
146: END IF;
147: --
153: sequence_no)
154: select l_route_id,
155: FFC.context_id,
156: 3
157: from ff_contexts FFC
158: where context_name = p_context_name3;
159: --
160: END IF;
161: --
167: sequence_no)
168: select l_route_id,
169: FFC.context_id,
170: 4
171: from ff_contexts FFC
172: where context_name = p_context_name4;
173: --
174: END IF;
175: --
181: sequence_no)
182: select l_route_id,
183: FFC.context_id,
184: 5
185: from ff_contexts FFC
186: where context_name = p_context_name5;
187: --
188: END IF;
189: --
195: sequence_no)
196: select l_route_id,
197: FFC.context_id,
198: 6
199: from ff_contexts FFC
200: where context_name = p_context_name6;
201: --
202: END IF;
203: --
209: sequence_no)
210: select l_route_id,
211: FFC.context_id,
212: 7
213: from ff_contexts FFC
214: where context_name = p_context_name7;
215: --
216: END IF;
217: --
223: sequence_no)
224: select l_route_id,
225: FFC.context_id,
226: 8
227: from ff_contexts FFC
228: where context_name = p_context_name8;
229: --
230: END IF;
231: --
237: sequence_no)
238: select l_route_id,
239: FFC.context_id,
240: 9
241: from ff_contexts FFC
242: where context_name = p_context_name9;
243: --
244: END IF;
245: --
251: sequence_no)
252: select l_route_id,
253: FFC.context_id,
254: 10
255: from ff_contexts FFC
256: where context_name = p_context_name10;
257: --
258: END IF;
259: --