APPS.IGI_CIS_UPDC dependencies on PO_VENDORS

Line 185: SELECT vendor_name FROM po_vendors

181: (c_start_date BETWEEN start_date AND end_date) OR
182: (c_end_date BETWEEN start_date AND end_date) ) ;
183:
184: CURSOR C3 (c_vendor_id number )IS
185: SELECT vendor_name FROM po_vendors
186: WHERE vendor_id = c_vendor_id ;
187:
188: CURSOR C4(c_vendor_site_id number , c_org_id number , c_vendor_id number) IS
189: SELECT vendor_site_code FROM po_vendor_sites

Line 208: l_vendor_name po_vendors.vendor_name%TYPE;

204: l_new_start_date date;
205: l_new_end_date date;
206: l_special_case boolean := FALSE;
207: l_vendor_site_code varchar2(15);
208: l_vendor_name po_vendors.vendor_name%TYPE;
209: --l_vendor_name varchar2(240) ;UTF changes Bug No. 2524214
210: l_tax_rate number ;
211: l_certificate_type varchar2(25);
212: l_vendor_site varchar2(100) ;