APPS.PO_COO_S dependencies on PO_APPROVED_SUPPLIER_LIS_VAL_V
Line 13: FROM po_approved_supplier_lis_val_v pasl,
9: x_country_of_origin IN OUT NOCOPY VARCHAR2) IS
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)