APPS.AP_AUTOSELECT_PKG dependencies on PO_VENDOR_SITES_ALL

Line 113: l_address_line1 po_vendor_sites_all.address_line1%TYPE;

109: AND AI.invoice_id = ASI.invoice_id
110: AND AI.invoice_type_lookup_code <> 'PAYMENT REQUEST';
111:
112:
113: l_address_line1 po_vendor_sites_all.address_line1%TYPE;
114: l_address_line2 po_vendor_sites_all.address_line2%TYPE;
115: l_address_line3 po_vendor_sites_all.address_line3%TYPE;
116: l_address_line4 po_vendor_sites_all.address_line4%TYPE;
117: l_amount_remaining NUMBER;

Line 114: l_address_line2 po_vendor_sites_all.address_line2%TYPE;

110: AND AI.invoice_type_lookup_code <> 'PAYMENT REQUEST';
111:
112:
113: l_address_line1 po_vendor_sites_all.address_line1%TYPE;
114: l_address_line2 po_vendor_sites_all.address_line2%TYPE;
115: l_address_line3 po_vendor_sites_all.address_line3%TYPE;
116: l_address_line4 po_vendor_sites_all.address_line4%TYPE;
117: l_amount_remaining NUMBER;
118: l_attention_ar_flag VARCHAR2(1);

Line 115: l_address_line3 po_vendor_sites_all.address_line3%TYPE;

111:
112:
113: l_address_line1 po_vendor_sites_all.address_line1%TYPE;
114: l_address_line2 po_vendor_sites_all.address_line2%TYPE;
115: l_address_line3 po_vendor_sites_all.address_line3%TYPE;
116: l_address_line4 po_vendor_sites_all.address_line4%TYPE;
117: l_amount_remaining NUMBER;
118: l_attention_ar_flag VARCHAR2(1);
119: l_awt_status_lookup_code VARCHAR2(25);

Line 116: l_address_line4 po_vendor_sites_all.address_line4%TYPE;

112:
113: l_address_line1 po_vendor_sites_all.address_line1%TYPE;
114: l_address_line2 po_vendor_sites_all.address_line2%TYPE;
115: l_address_line3 po_vendor_sites_all.address_line3%TYPE;
116: l_address_line4 po_vendor_sites_all.address_line4%TYPE;
117: l_amount_remaining NUMBER;
118: l_attention_ar_flag VARCHAR2(1);
119: l_awt_status_lookup_code VARCHAR2(25);
120: l_city ap_selected_invoices_all.city%type; --6708281

Line 159: l_site_code po_vendor_sites_all.vendor_site_code%TYPE;

155: l_payment_priority NUMBER(2);
156: l_proposed_interest_count NUMBER;
157: l_province VARCHAR2(150);
158: l_set_of_books_id number;
159: l_site_code po_vendor_sites_all.vendor_site_code%TYPE;
160: l_site_id NUMBER(15);
161: l_state VARCHAR2(150);
162: l_vendor_id number;
163: l_voucher_num VARCHAR2(50);