DBA Data[Home] [Help]

APPS.WSH_ECE_VIEWS_DEF dependencies on OE_LOOKUPS

Line 231: select lookup_code from oe_lookups where lookup_type

227: PROCEDURE get_invoice_number(p_delivery_id IN NUMBER,
228: x_invoice_number OUT NOCOPY NUMBER) IS
229: l_lookup_code Varchar2(30) := NULL;
230: cursor c_lookup_value is
231: select lookup_code from oe_lookups where lookup_type
232: = 'INVOICE_NUMBER_METHOD' and meaning = 'Delivery Name';
233: --
234: l_debug_on BOOLEAN;
235: --