[Home] [Help]
7: result oe_transaction_types_tl.name%type;
8: begin
9: select t.name into result
10: from
11: oe_blanket_headers_all h,
12: oe_transaction_types_all a,
13: oe_transaction_types_tl t
14: where t.transaction_type_id = h.order_type_id
15: and a.transaction_type_id = t.transaction_type_id