10:
11: CURSOR C is
12: SELECT paa.country_of_origin_code
13: FROM po_approved_supplier_lis_val_v pasl,
14: po_asl_attributes paa
15: WHERE pasl.item_id = x_item_id
16: AND pasl.vendor_id = x_vendor_id
17: AND nvl(pasl.vendor_site_id, -1) = nvl(x_vendor_site_id, -1)
18: AND pasl.using_organization_id IN (-1, x_ship_to_org_id)