APPS.PO_RFQS_SV dependencies on PO_VENDORS

Line 330: l_vendor_name po_vendors.vendor_name%TYPE := NULL;

326: x_progress VARCHAR2(3) := '';
327: x_vendor_list_name po_vendor_list_headers.vendor_list_name%type := null;
328:
329: /* Bug # 6161855 */
330: l_vendor_name po_vendors.vendor_name%TYPE := NULL;
331: myResult number;
332: flagValue varchar2(1);
333: /*end of Bug # 6161855*/
334:

Line 342: SELECT Nvl(hold_flag,'F'),vendor_name INTO flagValue, l_vendor_name FROM po_vendors WHERE vendor_id=myResult;

338: OPEN C3;
339: LOOP
340: FETCH C3 into myResult;
341: EXIT WHEN C3%NOTFOUND;
342: SELECT Nvl(hold_flag,'F'),vendor_name INTO flagValue, l_vendor_name FROM po_vendors WHERE vendor_id=myResult;
343:
344: IF flagValue='Y' then
345: x_vendors_hold:=x_vendors_hold ||', '|| l_vendor_name;
346: END if;