6: SELECT
7: VENDOR_NAME
8: INTO VEN_NAME
9: FROM
10: PO_VENDORS
11: WHERE VENDOR_ID = CF_VENDOR_NAMEFORMULA0009.VENDOR_ID;
12: RETURN (VEN_NAME);
13: EXCEPTION
14: WHEN OTHERS THEN
41: SELECT
42: VENDOR_NAME
43: INTO VEN_NAME
44: FROM
45: PO_VENDORS
46: WHERE VENDOR_ID = VENDOR_ID1;
47: RETURN (VEN_NAME);
48: END IF;
49: EXCEPTION