255: END IF;
256:
257: SELECT vendor_site_code INTO v_vendor_site_code
258: FROM po_vendor_sites_all site,
259: org_organization_definitions ood
260: WHERE site.vendor_site_id = arg_vendor_site_id
261: AND nvl(site.org_id,nvl(ood.operating_unit,-1)) =
262: nvl(ood.operating_unit,-1)
263: AND ood.organization_id = arg_org_id;