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)
400: SELECT
401: vendor_name,
402: segment1 vendor_num
403: FROM
404: ap_suppliers
405: WHERE
406: vendor_id = p_vendor_id;
407:
408: CURSOR get_vendor_site_csr(p_vendor_id IN NUMBER, p_vendor_site_id IN NUMBER, p_org_id IN NUMBER)
702: SELECT
703: vendor_name,
704: segment1 vendor_num
705: FROM
706: ap_suppliers
707: WHERE
708: vendor_id = p_vendor_id;
709:
710: CURSOR get_vendor_site_csr(p_vendor_id IN NUMBER, p_vendor_site_id IN NUMBER, p_org_id IN NUMBER)