103: SELECT
104: vendor_name,
105: segment1 vendor_num
106: FROM
107: ap_suppliers
108: WHERE
109: vendor_id = p_vendor_id;
110:
111: CURSOR get_vendor_site_csr(p_vendor_id IN NUMBER, p_vendor_site_id IN NUMBER, p_org_id IN NUMBER)
409: SELECT
410: vendor_name,
411: segment1 vendor_num
412: FROM
413: ap_suppliers
414: WHERE
415: vendor_id = p_vendor_id;
416:
417: CURSOR get_vendor_site_csr(p_vendor_id IN NUMBER, p_vendor_site_id IN NUMBER, p_org_id IN NUMBER)
721: SELECT
722: vendor_name,
723: segment1 vendor_num
724: FROM
725: ap_suppliers
726: WHERE
727: vendor_id = p_vendor_id;
728:
729: CURSOR get_vendor_site_csr(p_vendor_id IN NUMBER, p_vendor_site_id IN NUMBER, p_org_id IN NUMBER)