5481: IF p_freight_carrier_code IS NOT NULL THEN
5482:
5483: SELECT DESCRIPTION
5484: INTO l_freight_carrier 5485: FROM ORG_FREIGHT 5486: WHERE FREIGHT_CODE = p_freight_carrier_code
5487: AND ORGANIZATION_ID = nvl(l_ship_from_org_id,ORGANIZATION_ID);
5488:
5489: END IF;