116: into l_city
117: from ap_system_parameters;
118:
119: ELSIF NVL(l_payment_location,'$') = '2' THEN -- 2 SUPPLIER
120: -- Get city from po_vendor_sites
121: select city
122: into l_city
123: from po_vendor_sites
124: where vendor_site_id = l_vendor_site_id
119: ELSIF NVL(l_payment_location,'$') = '2' THEN -- 2 SUPPLIER
120: -- Get city from po_vendor_sites
121: select city
122: into l_city
123: from po_vendor_sites
124: where vendor_site_id = l_vendor_site_id
125: and nvl(inactive_date,sysdate + 1) > sysdate;
126:
127: END IF;