147: return '';
148: else
149: select meaning
150: into l_ship_method_meaning
151: from fnd_lookup_values_vl
152: where lookup_type = 'SHIP_METHOD'
153: and view_application_id = 3
154: and lookup_code = p_ship_method_code;
155: end if;
285: select
286: meaning,
287: description,
288: lookup_code ship_method_code
289: from fnd_lookup_values_vl flv
290: where lookup_type = 'SHIP_METHOD'
291: and view_application_id = 3
292: and nvl(start_date_active,sysdate)<=sysdate
293: AND nvl(end_date_active,sysdate)>=sysdate