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;
284: select
285: meaning,
286: description,
287: lookup_code ship_method_code
288: from fnd_lookup_values_vl flv
289: where lookup_type = 'SHIP_METHOD'
290: and view_application_id = 3
291: and nvl(start_date_active,sysdate)<=sysdate
292: AND nvl(end_date_active,sysdate)>=sysdate