DBA Data[Home] [Help]

APPS.PON_PRINTING_PKG dependencies on ORG_FREIGHT

Line 304: l_carrier org_freight.description%TYPE;

300: FUNCTION get_carrier_description(p_org_id in NUMBER,p_carrier_code in VARCHAR2)
301: return varchar2
302: is
303:
304: l_carrier org_freight.description%TYPE;
305:
306: begin
307:
308: select

Line 314: org_freight orgf

310: into
311: l_carrier
312: from
313: financials_system_params_all fsp,
314: org_freight orgf
315: where
316: nvl(fsp.org_id, -9999)= nvl(p_org_id, -9999)
317: and orgf.organization_id = fsp.inventory_organization_id
318: and orgf.freight_code = p_carrier_code