248: SELECT
249: VENDOR_ID
250: INTO V_VENDOR_ID
251: FROM
252: PO_VENDORS
253: WHERE SEGMENT1 = V_SEGMENT2;
254: SELECT
255: SET_OF_BOOKS_ID
256: INTO V_SET_OF_BOOKS_ID
291: SELECT
292: VENDOR_ID
293: INTO V_VENDOR_ID
294: FROM
295: PO_VENDORS
296: WHERE SEGMENT1 = V_SEGMENT2;
297: SELECT
298: SET_OF_BOOKS_ID
299: INTO V_SET_OF_BOOKS_ID
322: CURSOR FOR_NAME(V_ID IN NUMBER,V_NO IN VARCHAR2) IS
323: SELECT
324: VENDOR_NAME
325: FROM
326: PO_VENDORS
327: WHERE VENDOR_ID = V_ID
328: OR SEGMENT1 = V_NO;
329: V_VENDOR_NAME VARCHAR2(80);
330: BEGIN