449: ) IS
450:
451: CURSOR c1 IS
452: SELECT segment1 453: FROM po_vendors 454: WHERE vendor_id = p_supp_id
455: ;
456:
457: BEGIN
Line 471: FROM po_vendors
467: , x_supp_name OUT NOCOPY VARCHAR2
468: ) IS
469: CURSOR c1 IS
470: SELECT vendor_name 471: FROM po_vendors 472: WHERE vendor_id = p_supp_id
473: ;
474:
475: BEGIN