496: return '';
497: else
498: select meaning
499: into l_ship_method_meaning
500: from fnd_lookup_values_vl
501: where lookup_type = 'SHIP_METHOD'
502: and view_application_id = 3
503: and lookup_code = p_ship_method_code;
504: end if;
799: meaning,
800:
801: description,
802: lookup_code ship_method_code
803: from fnd_lookup_values_vl flv
804: where lookup_type = 'SHIP_METHOD'
805: and view_application_id = 3
806: and nvl(start_date_active,sysdate)<=sysdate
807: AND nvl(end_date_active,sysdate)>=sysdate