APPS.AP_CUSTOM_INT_INV_PKG dependencies on PO_VENDOR_SITES

Line 41: l_city po_vendor_sites.city%type; --6708281

37: l_interest_grace_days number;
38: l_penalty_type varchar2(15);
39: l_penalty_rate_amount number;
40: l_calendar varchar2(10);
41: l_city po_vendor_sites.city%type; --6708281
42: l_payment_location varchar2(80);
43: l_payment_action varchar2(1);
44: l_days_late number;
45: l_exit_code number;

Line 155: -- Get city from po_vendor_sites

151: into l_city
152: from ap_system_parameters;
153:
154: ELSIF NVL(l_payment_location,'$') = '2' THEN -- 2 SUPPLIER
155: -- Get city from po_vendor_sites
156: select city
157: into l_city
158: from po_vendor_sites
159: where vendor_site_id = l_vendor_site_id

Line 158: from po_vendor_sites

154: ELSIF NVL(l_payment_location,'$') = '2' THEN -- 2 SUPPLIER
155: -- Get city from po_vendor_sites
156: select city
157: into l_city
158: from po_vendor_sites
159: where vendor_site_id = l_vendor_site_id
160: and nvl(inactive_date,sysdate + 1) > sysdate;
161:
162: END IF;