213: subb.maximum_term,
214: subb.name,
215: subt.short_description
216: from
217: okl_subsidies_tl subt,
218: okl_subsidies_b subb
219: where subt.id = subb.id
220: and subt.language = userenv('LANG')
221: and subb.id = p_sub_id;
431: subb.maximum_term,
432: subb.name,
433: subt.short_description
434: from
435: okl_subsidies_tl subt,
436: okl_subsidies_b subb
437: where subt.id = subb.id
438: and subt.language = userenv('LANG')
439: and subb.id = p_sub_id;