DBA Data[Home] [Help]

APPS.JL_ZZ_GLOBE_VAL_PKG dependencies on PO_VENDORS

Line 339: FROM po_vendors pv

335: l_is_foreign BOOLEAN;
336: BEGIN
337: SELECT count(*)
338: INTO l_count
339: FROM po_vendors pv
340: WHERE pv.vendor_id = p_vendor_id AND
341: pv.global_attribute9 = 'FOREIGN_ORIGIN';
342:
343: IF l_count = 1 THEN

Line 397: FROM po_vendors pv

393: l_vendor_name VARCHAR2(80);
394: BEGIN
395: SELECT pv.vendor_name
396: INTO l_vendor_name
397: FROM po_vendors pv
398: WHERE pv.segment1 = p_taxpayer_id;
399:
400: RETURN l_vendor_name;
401:

Line 421: FROM po_vendors pv

417: l_vendor_id NUMBER;
418: BEGIN
419: SELECT pv.vendor_id
420: INTO l_vendor_id
421: FROM po_vendors pv
422: WHERE pv.segment1 = p_vendor_number;
423:
424: RETURN l_vendor_id;
425: