214:
215: PROCEDURE get_remit_email_address (p_check_id in NUMBER,
216: p_email_address out NOCOPY VARCHAR2) is
217:
218: l_vendor_id po_vendor_sites_all.vendor_id%type;
219: l_vendor_site_id po_vendor_sites_all.vendor_site_id%type;
220:
221: BEGIN
222:
215: PROCEDURE get_remit_email_address (p_check_id in NUMBER,
216: p_email_address out NOCOPY VARCHAR2) is
217:
218: l_vendor_id po_vendor_sites_all.vendor_id%type;
219: l_vendor_site_id po_vendor_sites_all.vendor_site_id%type;
220:
221: BEGIN
222:
223: SELECT vendor_id,